Viewing 15 posts - 16 through 30 (of 42 total)
EDIT: I've just realised you're allowing them to navigate through records, so if this is the case, then the Form_Unload event will probably not be entirely applicable. I'd still...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 24, 2010 at 4:22 pm
Hi Westy,
From a purely frontend design perspective, i'd suggest you can do away with the save button completely. Use the Form_Unload event to determine if the user has made...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 24, 2010 at 4:04 pm
Hi Giorgio,
We'd create the date dimension table either manually, or as this is a forum, it would probably be quicker to do it through DDL using an SQL statement. We'd...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 24, 2010 at 3:41 pm
Hi John,
Blimey, you're making me blush and squirm in embarrassment! 😀
Admittedly, I've plenty of experience in VBA and have used it pretty much on a day-to-day basis for what feels...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 24, 2010 at 2:52 pm
Hi nvrwrkn2,
Doh - I made the last change without thinking it through! What is now happening is that for each unique combination of REQDATE and REQTIME it's inserting the...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 24, 2010 at 2:26 pm
nvrwrkn2 (3/16/2010)
Anyhoo... I'm getting a compile error now... I think I got the same thing before:User-defined type not defined, highlighted at Dim rst As.ADODB.Recordset.
Just a quick one, but there's...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 16, 2010 at 6:00 pm
Hi,
Sorry I didn't get back on Sunday - I blame the lack of a hangover! As promised, I've amended the code in the previous post so it handles REQUEST_TIME,...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 16, 2010 at 3:36 pm
I've just got back from the pub and as I didn't drink too much (HIC :-P) I couldn't resist checking up how you got on - I've gotta say well...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 12, 2010 at 6:37 pm
Working through your points...
Aaaaahhhhh! You should have re-copied the whole of code from the previous post as I made a few other minor changes to the SQL, and there was...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 12, 2010 at 8:25 am
Hi,
I've amended some of the SQL (removed the DMax) so you might want to replace the code and see if that works. I created a quick and dirty couple of...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 12, 2010 at 3:15 am
Hi nvrwrkn2,
Sounds like you're having one of those days! 😀
I'm trying to get my head into thinking in terms of "sets" as opposed to "cursors", but I'm not sure how...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 11, 2010 at 4:42 pm
EDIT:
I should have read this first... 🙂
I'm looking for this to run through the entire Requests table to pull the TOP 2 or TOP 3, depending on the DOW.
The expected...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 11, 2010 at 1:15 pm
Aaaahhhh... it could be that your modules have the same names as your procedures, and they're conflicting. Try renaming the modules (not the procedures) and see if that works.
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 11, 2010 at 12:38 pm
nvrwrkn2 (3/11/2010)
I need to invoke on a button's OnClik one or the other module based on:If (Day(Requests.ReqDate) >= 1 Or Day(Requests.ReqDate <= 5)) Then DoCmd.OpenModule (FindTop2) Else DoCmd.OpenModule (FindTop3)
Hi nvrwrkn2,
You...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 11, 2010 at 10:14 am
Hi Steve,
If you're going to do it through VBA, then you'll probably want to set a reference to the MS Excel object model to enable you to format the worksheet(s)....
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 8, 2010 at 5:00 pm
Viewing 15 posts - 16 through 30 (of 42 total)