Search results

Yeah spotted that. My original date query was back in 2014. No wonder I couldn't remember it! Too many brain cells have left since then. I actually found the Allen Browne solution back then. My memory is not as good as it was! Now about dates, I'm having a problem wi.....

Cheers. Think you have your US date the wrong way round.

Just literally seen another reference to the same! Thanks!

I probably did!! Dates for some reason confuse the hell out of me. Found an Allen Browne solution to convert to mm/dd using newdateformat = Format$(stick your date variable here, "\#mm\/dd\/yyyy hh\:nn\:ss\#")

I have a table that store when the last end of day was performed. It's obviously held as a date format dd/mm/yyy hh:mm:ss When the next end of day is performed it accesses the table and gets the last date when the end of day was performed. It then uses this in a query to get the sum of goods...

My user wants fixed windows. Is it easy to flip over to overlapping windows for testing?

I presume you're not including a breakpoint where the code has actually stopped?

I'm often putting breakpoints into code to check what's going on, what values are in certain fields, making sure the logic is following the right path etc etc. A problem crops up all the time in that I can not see the form at all (I'm using document tabs) and it's only when the processing has...

I decided to change the logic of the program so instead of end of day it's now an end of the last time you did which is actually more what the user wants. Had to change how I held the date to include hh:mm:ss which was the only real hardship. I can now test without having to frig anything.

I like the now() - x if I can remember to reinstate it! I thought abut the table but it's a bigger change to code. Thinking on I can set up some public variable with "prod" or "test" in it and control the now() with that so if I forget no problem. Unless I leave the variable set to test! Hmm!

I'm about to test an end of day process. It's uses now() to pick up the current date and time etc. Is there a simple way without fiddling with the code to pick up different days without actually having to wait for another day!! I'm testing this on a laptop. Can I change the system date so that...

Thanks Maj and Isla. Funnily enough I didn't have the option ticked (I do now). However I do have option explicit in every module or it at least looks that way!!

I'll take a look at this but thanks for helping.

Not sure what you mean by "Do you require variable declaration in all modules." I have to declare all variables in each module if that's what you mean by "Does Option Explicit exist in all code modules?". I've done nothing specific to do this as far as I know! Yeah and thanks for the doevents...

It's general because if I step through the code I don't get the error unless I close down access and restart without any breaks. I was just in the process of looking what I need to decompile (I'm on a new laptop and have forgotten) but decide to do a compile database. Problem has now gone away...

I'm getting a run time error 459, object or class does not support the set of events. This is when I double click on a field to trigger the double clock event. If I click debug the program closes and when I reopen get the same cycle of events. If I click end try the double click again it works...

Yep works like you say. Will be fine if he only wants one form to the left. I suspect he 'll want 2 or 3. Is there no way to change the order itself in the forms collection.

ok i'll take alook in depth and maybe just convince him he only needs 1 form in the left most position!! actually not sure what I should be doing here

He, I think, only wants to move forms to the left. He has 1 or 2 that he wants in this position. Is that possible with your code above.

The user has a system that doesn't do what he wants but he likes the layout. So he wants me to design something utilising the same layout.