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
|
|||
|
|||
A dialog box pops up when I start my application
I did not write the application (Access 2007), but am trying to modify it.
I have a dialog box that pops up when the home form (page) of the application opens automatically when the application begins. The Home form is set to open automatically in the Microsoft Office Button \Access Options \ Current Database. The dialog box also pops up if I reopen the home form by double clicking on it. The dialog box says "Enter Parameter Value... OK or Cancel" and lists "Forms!home!Text 40". Text Box 40 is on one of the other menu pages and is used is the expression fields of the 'criteria' in 3 of the queries. This error began occurring after I deleted another a tab (called 'changes that was on another menu tab along with it's associated form and table and menu tab. I compacted & repaired the application to NO AVAIL. I was thinking that an AUTOEXEC Macro might be the culprit; but I do not know how to find it if there is? Help Please? Bob |
#2
|
|||
|
|||
A dialog box pops up when I start my application
The problem is in the home form.
Access can't find any value for "Forms!home!Text 40". Because it can't find the value of "Forms!home!Text 40", it can't open properly. Most probably, "Forms!home!Text 40" was on the now deleted tab. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "BobC" wrote in message ... I did not write the application (Access 2007), but am trying to modify it. I have a dialog box that pops up when the home form (page) of the application opens automatically when the application begins. The Home form is set to open automatically in the Microsoft Office Button \Access Options \ Current Database. The dialog box also pops up if I reopen the home form by double clicking on it. The dialog box says "Enter Parameter Value... OK or Cancel" and lists "Forms!home!Text 40". Text Box 40 is on one of the other menu pages and is used is the expression fields of the 'criteria' in 3 of the queries. This error began occurring after I deleted another a tab (called 'changes that was on another menu tab along with it's associated form and table and menu tab. I compacted & repaired the application to NO AVAIL. I was thinking that an AUTOEXEC Macro might be the culprit; but I do not know how to find it if there is? Help Please? Bob |
#3
|
|||
|
|||
A dialog box pops up when I start my application
Bob:
My guess would be that the name of the control is Text40 but one or more of the references to the control incorrectly includes a space, Text 40. Another, less likely, possibility is that the control name does include the space, but one or more of the references does not include the name in square brackets [Text 40], which is necessary when object names include a space or other special character. Ken Sheridan Stafford, England BobC wrote: I did not write the application (Access 2007), but am trying to modify it. I have a dialog box that pops up when the home form (page) of the application opens automatically when the application begins. The Home form is set to open automatically in the Microsoft Office Button \Access Options \ Current Database. The dialog box also pops up if I reopen the home form by double clicking on it. The dialog box says "Enter Parameter Value... OK or Cancel" and lists "Forms!home!Text 40". Text Box 40 is on one of the other menu pages and is used is the expression fields of the 'criteria' in 3 of the queries. This error began occurring after I deleted another a tab (called 'changes that was on another menu tab along with it's associated form and table and menu tab. I compacted & repaired the application to NO AVAIL. I was thinking that an AUTOEXEC Macro might be the culprit; but I do not know how to find it if there is? Help Please? Bob -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
A dialog box pops up when I start my application
All I have on the Home page is a Logo and 3 Label Boxes showing
Application Name & Revision Number. Text 40 is combo box on the 3rd Tab (Orders)used to select categories of orders. I am trying to delete the 5th Tab (Changes) which has a Form and a Table assotiated only to the change function (AS FAR AS I KNOW!) One thing that is somewhat confusing is the Logo on the Home page shows through the 4th Tab which only has 2 Commond buttons on it. The Labels (Application Name and Version Numbers do not show though on other tabs? Bob Jeanette Cunningham wrote: The problem is in the home form. Access can't find any value for "Forms!home!Text 40". Because it can't find the value of "Forms!home!Text 40", it can't open properly. Most probably, "Forms!home!Text 40" was on the now deleted tab. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia wrote in message ... I did not write the application (Access 2007), but am trying to modify it. I have a dialog box that pops up when the home form (page) of the application opens automatically when the application begins. The Home form is set to open automatically in the Microsoft Office Button \Access Options \ Current Database. The dialog box also pops up if I reopen the home form by double clicking on it. The dialog box says "Enter Parameter Value... OK or Cancel" and lists "Forms!home!Text 40". Text Box 40 is on one of the other menu pages and is used is the expression fields of the 'criteria' in 3 of the queries. This error began occurring after I deleted another a tab (called 'changes that was on another menu tab along with it's associated form and table and menu tab. I compacted& repaired the application to NO AVAIL. I was thinking that an AUTOEXEC Macro might be the culprit; but I do not know how to find it if there is? Help Please? Bob |
#5
|
|||
|
|||
A dialog box pops up when I start my application
I may have misled you!
I was in error in my initial post. The error message does not have a space in Text40... should be: "Forms!home!Text40" The 3rd Tab (Orders) has a combo box Text40. I am trying to delete the 5th Tab (Changes) which (to my knowledge) only had a Table and a Form associated with it? KenSheridan via AccessMonster.com wrote: Bob: My guess would be that the name of the control is Text40 but one or more of the references to the control incorrectly includes a space, Text 40. Another, less likely, possibility is that the control name does include the space, but one or more of the references does not include the name in square brackets [Text 40], which is necessary when object names include a space or other special character. Ken Sheridan Stafford, England BobC wrote: I did not write the application (Access 2007), but am trying to modify it. I have a dialog box that pops up when the home form (page) of the application opens automatically when the application begins. The Home form is set to open automatically in the Microsoft Office Button \Access Options \ Current Database. The dialog box also pops up if I reopen the home form by double clicking on it. The dialog box says "Enter Parameter Value... OK or Cancel" and lists "Forms!home!Text 40". Text Box 40 is on one of the other menu pages and is used is the expression fields of the 'criteria' in 3 of the queries. This error began occurring after I deleted another a tab (called 'changes that was on another menu tab along with it's associated form and table and menu tab. I compacted& repaired the application to NO AVAIL. I was thinking that an AUTOEXEC Macro might be the culprit; but I do not know how to find it if there is? Help Please? Bob |
#6
|
|||
|
|||
A dialog box pops up when I start my application
Bob:
I assume that the Text40 control is in the parent form's Controls collection, not in that of a subform on the page of the tab control. Assuming that to be the case try opening the form and then referencing the control form the debug window with: ? Forms!home!Text40.Name If you find it cannot be referenced in this way try deleting the control and then recreating it. Ken Sheridan Stafford, England BobC wrote: I may have misled you! I was in error in my initial post. The error message does not have a space in Text40... should be: "Forms!home!Text40" The 3rd Tab (Orders) has a combo box Text40. I am trying to delete the 5th Tab (Changes) which (to my knowledge) only had a Table and a Form associated with it? Bob: [quoted text clipped - 29 lines] Help Please? Bob -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200911/1 |
#7
|
|||
|
|||
A dialog box pops up when I start my application
Ken
The Text40 control is on a subform of a page of another Tab Control (not the one that I want to delete. Bob KenSheridan via AccessMonster.com wrote: Bob: I assume that the Text40 control is in the parent form's Controls collection, not in that of a subform on the page of the tab control. Assuming that to be the case try opening the form and then referencing the control form the debug window with: ? Forms!home!Text40.Name If you find it cannot be referenced in this way try deleting the control and then recreating it. Ken Sheridan Stafford, England BobC wrote: I may have misled you! I was in error in my initial post. The error message does not have a space in Text40... should be: "Forms!home!Text40" The 3rd Tab (Orders) has a combo box Text40. I am trying to delete the 5th Tab (Changes) which (to my knowledge) only had a Table and a Form associated with it? Bob: [quoted text clipped - 29 lines] Help Please? Bob |
#8
|
|||
|
|||
A dialog box pops up when I start my application
Bob:
If its on a subform then, as a subform is not a member of the Forms collection, you can't reference it as: Forms!home!Text40 It has to be referenced via the Form property of the subform control in the parent form (i.e. the control which houses the subform). The syntax is: Forms!ParentFormName!SubformControlName.Form!Text4 0 Ken Sheridan Stafford, England BobC wrote: Ken The Text40 control is on a subform of a page of another Tab Control (not the one that I want to delete. Bob Bob: [quoted text clipped - 24 lines] Help Please? Bob -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200911/1 |
Thread Tools | |
Display Modes | |
|
|