Recent content by ryetee

I'm bug fixing a query that is 99.99% correct. It consists of three tables built using the query design option in access. The driving table is client order table. This is linked to the client table to pick up client specific data and also a payments table which tracks when payments were made...

Design

Thanks I'll take alook

How do you compare. Manually?

I have taken over the releasing of a test version Access database. The problem I have is there is no documentation whatsoever on what tables have been changed. Is there an easy way to work this out. I'm using last updated date but because it's been a while to get this released it's grouping...

bi bit late but thanks!

Hear what you're saying but the watches work perfectly. I can set a break at the start and end of the loops and see immediately what I need.

OK not sure what I'm doing with this. Do I need to do this multiple times and redo when I close and open everything?

OK I'll give that a shot....

I'm wanting to display various SYS table entries, strings and other table entries. In this case this is cumbersome as I've got loops within loops so I need to see when variables change without having to read loads of displays. Thanks for the input.

Not sure I've put this in the right place!

I'm testing/debugging a program I'm setting up about 9 watches for the crucial part of testing I have to end the program to test next part and have to reinput the 9 watches Is there an easier way to do this other than reinput 1 by 1

Thanks copied parts of your code. Had to changed a bit to fit my system and all is working so thanks for the help.

ok i'm all sorted now. there was an issue created by july's update that was corrected by the one in august

Don't think I've placed it in a trusted location. When I opened it in the first place it says it was read only and to save it with a different name. I did, to my documents folder and ran it from there