AccessChap
Registered User.
- Local time
- Today, 05:37
- Joined
- Apr 14, 2009
- Messages
- 32
Hi guys, me again...
Help! It seems that I've managed to break another Access command in splitting my database. Essentially I have a form with several subforms and a button that fires off a command from VBA along the lines of OpenCall_OnHold.Requery etc for each of the subforms. The idea is that clicking this button triggers a refresh of the data in each of the subforms called OpenCall_OnHold etc
This worked fine but I have now created a front end database for the users and this option no longer works. I get no error message either so I've no error number to quote I'm afraid. The only thing I have noticed is that if I right-click on the VBA line and select Definition I get the error:
"Cannot jump to 'OpenCall_OnHold' because it is in the library 'C:\Documents and Settings\path\dbname.mdb' which is not currently referenced"
I'm not sure what this means but I can say that the front end copy of the database is indeed held in the path and filename quoted in the error message. If I go back to the original consolidated database then this error does not occur. Any ideas? It's obviously something I've broken by splitting the database but frankly I've no clue how to resolve the problem
I created the front end part of the database by copying sideways the back end, deleting the data tables and linking them back to the back end tables. What I mean is that from the perspective of the front end database the tables being accessed are now remote
All hints and suggestions most welcome!
TIA,
Andy
Help! It seems that I've managed to break another Access command in splitting my database. Essentially I have a form with several subforms and a button that fires off a command from VBA along the lines of OpenCall_OnHold.Requery etc for each of the subforms. The idea is that clicking this button triggers a refresh of the data in each of the subforms called OpenCall_OnHold etc
This worked fine but I have now created a front end database for the users and this option no longer works. I get no error message either so I've no error number to quote I'm afraid. The only thing I have noticed is that if I right-click on the VBA line and select Definition I get the error:
"Cannot jump to 'OpenCall_OnHold' because it is in the library 'C:\Documents and Settings\path\dbname.mdb' which is not currently referenced"
I'm not sure what this means but I can say that the front end copy of the database is indeed held in the path and filename quoted in the error message. If I go back to the original consolidated database then this error does not occur. Any ideas? It's obviously something I've broken by splitting the database but frankly I've no clue how to resolve the problem
I created the front end part of the database by copying sideways the back end, deleting the data tables and linking them back to the back end tables. What I mean is that from the perspective of the front end database the tables being accessed are now remote
All hints and suggestions most welcome!
TIA,
Andy