Search results

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

That's filled with the link to the back end. I didn't quite get what you were getting at

I can't actually "get into" the code on the refreshlinks_07 to see what's going on but not sure it would work for me. Is it possible to pick up the root directory in the code (it may do this but I can't see the code). So if the FE is in Drive Letter:\DirectorYForFE can I pick this up ?

The restart worked and now I can see the linked tables. I was sort of confident that it would> I can bore with you with why I was if you want!! Anyway, great spot appreciate your help.

I thought about restarting machine to push it along a bit but it now seems to have died on me! You've got to love technology eh!? Thanks for all your help btw

see my other reply about doing the update myself!!