Search results

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 :)

^^^^ And what DCrake said :)

I've looked at your sample and to be honest your table structures need work you have no unique identification fields for your hospitals (Autonumber or similar) and no foriegn key to relate the tables. You also need form/s to input your details as entering directly into tables is never a good...

Not from me sorry had a play but no progress was hoping someone else would have a suggestion.... If I do find/work something out will let you know straight away. Sorry John :(

Don't quite understand what you mean but all you do is keep a "master copy" of the FE you have developed and distribute "copies" of this. Then just keep a developement copy of the BE which you need with any split database this can have dummy data in it all you are using is the table structures...

Why does the form have to be based on the table? If your query is based on the table in question you can include all the fields you require for your form in it (in fact all of the fields in your table if required) You could do the calculation on the form through VBA and an unbound control but...