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...

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...

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...

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...

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...

Just a quick one, but there's...

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,...

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...

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...

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...

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...

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...

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.

Hi nvrwrkn2,

You...

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)....