|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 25th, 2010, 01:27 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Copied Access Database Issue
I have an Access Database that I have copied to another machine for testing
purposes. I had to create a partition to act as the same drive letter as our server since that is the way some of the code is written and I did not want to have to go through and change the code. I am able to edit everything except for the forms that were created. I have to test some changes and do not want to do it to the actual database. I appreciate any assistance you all can provide. Thank You Volk72 
|
|
#2
January 25th, 2010, 02:21 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Copied Access Database Issue
You can use a Conditional statement, like:
In your Declaration section: Const fDebug As Boolean = 0 Then in your code: If fDebug = True Then If FileExists("S:\Customers\Bid_Crosstab_ByTrade.xls" ) Then '... Else If FileExists("X:\Bid_Crosstab_ByTrade.xls") Then '... End If All you need to do is to change the fDebug constant from false (0) to true (-1), and everything in the database will work the way you want.. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Volk72" wrote in message ... I have an Access Database that I have copied to another machine for testing purposes. I had to create a partition to act as the same drive letter as our server since that is the way some of the code is written and I did not want to have to go through and change the code. I am able to edit everything except for the forms that were created. I have to test some changes and do not want to do it to the actual database. I appreciate any assistance you all can provide. Thank You Volk72
|
|
#3
January 25th, 2010, 02:30 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Copied Access Database Issue
Hi Volk,
Could you describe what happens when you try to edit the forms? Can you not open them in Design view? Volk72 wrote: I have an Access Database that I have copied to another machine for testing purposes. I had to create a partition to act as the same drive letter as our server since that is the way some of the code is written and I did not want to have to go through and change the code. I am able to edit everything except for the forms that were created. I have to test some changes and do not want to do it to the actual database. I appreciate any assistance you all can provide. Thank You Volk72 -- Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
