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
|
|||
|
|||
Switchboard won't open, not even in design
I have a simple Access-2003 database that I created.
It was working fine UNTIL I added a control to the Switchboard that would display the user name and computer name using the Environ variable. textbox "User", data control source =environ(UserName) & " on " & environ(ComputerName) Now the Switchboard won't open, not even in design. No errors, just no response. How can I get back in to revise it? |
#2
|
|||
|
|||
Switchboard won't open, not even in design
Hi,
hold down the shift key while you open the database and keep it open until the database is opened. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "MrDavePet" wrote in message ... I have a simple Access-2003 database that I created. It was working fine UNTIL I added a control to the Switchboard that would display the user name and computer name using the Environ variable. textbox "User", data control source =environ(UserName) & " on " & environ(ComputerName) Now the Switchboard won't open, not even in design. No errors, just no response. How can I get back in to revise it? |
#3
|
|||
|
|||
Switchboard won't open, not even in design
On Feb 7, 4:12*pm, MrDavePet wrote:
I have a simple Access-2003 database that I created. It was working fine UNTIL I added a control to the Switchboard that would display the user name and computer name using the Environ variable. textbox "User", data control source =environ(UserName) & " on " & environ(ComputerName) Now the Switchboard won't open, not even in design. No errors, just no response. How can I get back in to revise it? Hm, looks like the form is damages somehow. Try this to make sure am I right or not. Create blank database and try to import that form (Access 2003: File Get External Data Import, Access 2007: somewhere in the ribbon). If it cannot import it, then the form is damaged. In this case, import ALL other objects to new database and re-create switchboard form. Regards, Branislav Mihaljev Microsoft Access MVP |
#4
|
|||
|
|||
Switchboard won't open, not even in design
On Feb 8, 1:10*pm, wrote:
On Feb 7, wrote: I have a simple Access-2003 database that I created. It was working fine UNTIL I added a control to the Switchboard that would display the user name and computer name using the Environ variable. textbox "User", data control source =environ(UserName) & " on " & environ(ComputerName) Now the Switchboard won't open, not even in design. No errors, just no response. How can I get back in to revise it? Hm, looks like the form is damages somehow. Try this to make sure am I right or not. Create blank database and try to import that form (Access 2003: File Get External Data Import, Access 2007: somewhere in the ribbon). If it cannot import it, then the form is damaged. In this case, import ALL other objects to new database and re-create switchboard form. Regards, Branislav Mihaljev Microsoft Access MVP You are right. The form won't export or import. Broken. I wonder how I crashed it? |
#5
|
|||
|
|||
Switchboard won't open, not even in design
On Feb 9, 6:06*am, MrDavePet wrote:
On Feb 8, 1:10*pm, wrote: On Feb 7, wrote: I have a simple Access-2003 database that I created. It was working fine UNTIL I added a control to the Switchboard that would display the user name and computer name using the Environ variable. textbox "User", data control source =environ(UserName) & " on " & environ(ComputerName) Now the Switchboard won't open, not even in design. No errors, just no response. How can I get back in to revise it? Hm, looks like the form is damages somehow. Try this to make sure am I right or not. Create blank database and try to import that form (Access 2003: File Get External Data Import, Access 2007: somewhere in the ribbon). If it cannot import it, then the form is damaged. In this case, import ALL other objects to new database and re-create switchboard form. Regards, Branislav Mihaljev Microsoft Access MVP You are right. *The form won't export or import. Broken. I wonder how I crashed it? Hi, Who knows, there are various ways to damage object or whole database. General advice is to install all the updates for your MS Office and all the latest hotfixes and to make backup copy from time to time, like once in a hour during development, just to make sure you won't loose much of your work if whole db crashes. Also try not to use any of the ActiveX controls if possible. So far you will need to create empty DB and import all the objects and re-create switchboard. Regards, Branislav Mihaljev Microsoft Access MVP |
Thread Tools | |
Display Modes | |
|
|