Incorrect Dates, Help, I Need Somebody Help!

[DMT Dave]

Ok guy's thank you

[Welshgasman]

I cannot have it in my signature here, but I do have it on another site.
See the post by moke123 in this thread. Micron also supplied a function in that thread.

https://www.access-programmers.co.uk...ed-dbs.306745/

[DMT Dave]

Thanks WGM, i am still trying to work out stepping as all of you suggest it will help massively

I've just read through the link from orange (_{Debugging VBA and Error Handling)}

Pressing Grtl+G opens immediate window
placing cursor at the front of the line to start stepping
press F8 or Step into from Debug Menu also Shift F8

Nothing then appears in the immediate window

I need to read more into this to help myself identify

Can i Step any code ?

So if i had a line strBody = rs.Fields etc etc

just cursor the front of strBody ?

CURSOR HERE ? strBody = strBody & rs.Fields("DelTo") & vbTab & rs.Fields("Town") & vbTab & rs.Fields("SONumber") & vbTab & rs.Fields("ItemNo") & vbTab & rs.Fields("DeliveryDate") & "|"
Debug.Print strBody

[Welshgasman]

Alt + F11 will open the VBA window.
You left click to the left of the code, in the left colum. That puts a red dot (a breakpoint) where the code will stop.
Then I tend to press F8 and step line by line.
You can set multiple breakpoints and use F5 which will run the code until the end, and error or the next breakpoint.

You NEED to learn this, to get to errors like this, especially what I call 'silly' errors, where when you find find it, you want to smack yourself in the forehead.

So if you are processing a form, set the breakpoint in the VBA window, then execute the form, button, combo, whatever and then work from there.
You can also hover the mouse over variables and it will show the value.

There is a link in my signature here for Debugging Access. Use it!

[Micron]

Randomizer is also at this forum:

https://www.accessforums.net/showthread.php?t=77482

[Welshgasman]

Moke123's Db is also here somewhere. Just easier to search, for me at least on the other site.

[Micron]

Moke123's Db is also here somewhere. Just easier to search, for me at least on the other site.

If you're intending to refer to one or the other frequently then bookmark one? No searching required.

[moke123]

randomizer
https://www.access-programmers.co.uk/forums/threads/randomizing-data-for-posted-dbs.306745/#post-1640309