Recent content by jsv2002

In your title it says FE I assume you men Front end so the database is split is it just the FE that has decreased in size or the overall database size? also have you enabled "compact on exit" this may explain some of it or you may have linked images rather than have them contained withtin the...

Haven't been on in a long while and just happened across this post shocked and saddened to see this news I have used the advise in many of Davids posts to solve some of the problems I have come up against. Best wishes to his family and my heart felt condolances, John

Just in case you can't find namliam post its: http://www.access-programmers.co.uk/forums/showthread.php?t=180962&highlight=location use a similar system myself and works well :)

I assume you where looking at the row source for DepartmentID? this will change after each update of the siteID combobox reflecting the choise there and limiting what you can select to the foreign key in the departments ID table. Using the above suggested will also work but the way I did it...

Also from what I can see if you don't want the update to run if its your "master/design db" being opened this should be run first then skip the update code altogether should it be the case but as SOS said a seperate event may well work better... Not found a problem with macro's yet (specifcally...

Try not to do it too often usually gets me into trouble...;)

Does it work if all you have is the update code in the start up form? Got to be honest never tried it in runtime works well when I have used it in normal access though. You might want to try posting at Utteraccess as well assuming that is Bob Larsons code you are using as he does not post here...

Have you made sure that the code runs before anything else eg. Is the first thing to be run in your startup form. Because from the error message it looks like something else is running first preventing the auto close and update. Good luc John :)

My bad you are right thinking of something totally unrelated :o

Ok fair enough but say you have a lot of invoices and want to serach via multiple criteria? Number, date, partial title a combo box can't do this and as a given the records are only going to grow in number so a drop down list no matter how big you make it will ultimately become limiting. As for...

Still fail to see why a combo box would be a choise for search but hey hooo it limits what they can search.. and if you have not applied restrictions on your form will make unwanted records...

You can't use new record as its meant to be a search why not use a list box to display the invoices and a control on the form to enter search criteria when a invoice is then selected you could have a command button to display the invoice. Maybe something like the attached screen shot. Good...

A start would be: http://www.google.co.uk/search?client=firefox-a&rls=org.mozilla%3Aen-GB%3Aofficial&channel=s&hl=en&q=vista+UAC&meta=&btnG=Google+Search But as said this may not be the problem UAC instituted something Linux had done from the outset that in normal login you don't have admin...

Have you tried disabling the UAC (User Account Control) just for testing and has the system got something like solid state disk protection running? (thats what I think its called been a while since I looked) this can prevent changes but other than that full outta ideas...

Ok no probs the afterupdate event in the first combo box is probably what you after in the sample I posted. Good luck :)