Search results

I need to be able to copy a series of records from a set of related tables.Tables are related as below: 1 EventSeries (tblEventSeries - Primary key SeriesID) -> 1 to Many Events for each EventSeries ( tblEvents - Related key SeriesID, Primary key EventID) -> The event details can be different...

I have created a replicated split database. Only the backend is replicated. I have used the code below to manage the synchronization of the backend tables with the DesingMaster backend. The database is secured by a workgroup and users run the database via a shortcut with a command line pointing...

Spinbutton Thanks for your message. And Thanks yes I found (eventually) where you suggested and works fine.:) I would also like to browes for a file and select its pathname and place it in a text box. I have used the activex browse button. I cannont find any obvious commands that provide...

On clicking up or down on spinbutton control the On Update action does not not run. Trying to inc/dec text box from spinbutton. I set a code break to check values but code is not being called, and I don't know why. Any help please alathwell

On Open Error Thanks for the message. How do I actually check the references. I am not sure how to do this. Regards alathwell

On Open Error 2007 Hi, just to let you know I tried your suggestion and unfortunately I am getting the same error, but nthis time related to the On Load action. The errror message is identical. Let me know if you have any other ideas to try. Thanks again Regards alathwell

On Open Error 2007 Hi thanks for your meaasge. I will try what you suggest and see if it cures the problem. I will let you know. Thanks again Regards alathwell

On Open Error 2007 Thanks for the message. Sorry I may have mislead you. I focused on the Switchboard as it is the first form that opens automatically on startup, and is always where the error first occurs simply becasuse it is the first form that opens and runs an event at On Open. But the...

Hi Thanks for your message. There is no specific code as it applies to any form that has code activated in the On Open event property in the form. This can be imbedded code or public. It seems to be the On Open action itself that is the issue. The reason it fails when the database starts up is...

On Open Error in 2007 Hello thank you for your reply. The database compiles perfectly fine in either 2003 or 2007. The error occurs when the database first runs and the Switchboard menu opens, and runs built in default code on the On Open event to popoulate the switchboard with the correct...

:(I would to provide the usr the ability to lock records on a form/subform. The database is distributed as a set of replicated databases some running in 2003 and others in 2007. It seems that I can use the Setproperty statement in 2007, but it is not recognised in 2003. The benefit of this...

Hi Thanks for your reply and the link. I haven't really found anything that deals with my immediate problem. I can run the databse no problem in Access 2003 (a replicated version), and it will run for a variable period in 2007 (the same replicated version) then for no apparent reason when...

:confused:I have a replicated databse that is used in both 2003 and 2007. Most development is done in 2003. I have stability problems with replicated/synchronised databases when running in 2007. The database normally opens with a switchboard menu, but on occassions the following error occurs:-...