We have a database which was designed and created for us by someone outside of our firm. We were updating the information by doing a cleanup within it. Someone opened up MS Access and went to Tools/Database Utilities and selected Compact/Repair and then selected the database. Since then one side of the database isn't working properly. The forms (which is what we pretty much use) has several buttons on it where you can enter information on a show ( what we do) and then print the contract by clicking a button. We can no longer enter additional information here nor can we print a contract. when i try to click the information it says "You've enetered an expression that has no value" It seems as if a connection to 2 different tables have been disconnected. Can anyone help? Any information will help out I am new to access so if I can provide you with any additional information please let me know.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HELP!!!!! MS ACCESS 2000 database trouble
- Thread starter Judy5305
- Start date
- Thread starter
- #3
Like I said i am new to access so I need you to walk me through it. I am in design view so if you talk me through it I could give you the correct information.
I can tell you this in design view we have several tabs at the bottom of the page. The tab where the problem is, is called Show when I am in there there is a breakdown
form header
detail
form footer
within the form header are the 2 buttons that no longer work and when I click on one of them and go to properties it says SfrmExhBooth. Within Detail section is where boxes should appear to enter info when you have a new person added to the database. These boxes don't appear either. When I right click on this and go to properties the first box says combo Box combo 24 the each text box afterwards has it's own name such as location, conference etc.
Is there a way I can upload a picture of it?
I can tell you this in design view we have several tabs at the bottom of the page. The tab where the problem is, is called Show when I am in there there is a breakdown
form header
detail
form footer
within the form header are the 2 buttons that no longer work and when I click on one of them and go to properties it says SfrmExhBooth. Within Detail section is where boxes should appear to enter info when you have a new person added to the database. These boxes don't appear either. When I right click on this and go to properties the first box says combo Box combo 24 the each text box afterwards has it's own name such as location, conference etc.
Is there a way I can upload a picture of it?
To determine if your form is still linked to the underlying table or query:
With your form in design view go to the menubar above and click on View. Look for properties and click on it. This will bring up the form properties - you'll see (4) tabs;
Format, Data, Event, Other, All. Click on Data and see the recordsource. To the far right you'll see a button with 3 little dots, click on it. We need to see if there is a table or query behind this form.
Whats the name of the recordsource
If it asks you to build a query - just click no. If not you should be able to view the recordsource.
With your form in design view go to the menubar above and click on View. Look for properties and click on it. This will bring up the form properties - you'll see (4) tabs;
Format, Data, Event, Other, All. Click on Data and see the recordsource. To the far right you'll see a button with 3 little dots, click on it. We need to see if there is a table or query behind this form.
Whats the name of the recordsource
If it asks you to build a query - just click no. If not you should be able to view the recordsource.
- Thread starter
- #5
ok. i did as you said it's just a little confusing for me so bear with me. the name of the record source is qryExhBooth and it didn't ask me to build a query but it brought me into the query buiklder for qryExhBooth and that is where i am now
On the menubar above - click on the red exclamation point. Will just see if this query runs and you are still linked to to the table behind this form.
If so, then your problem is not the table or connection to the tables, but the code behind your button.
If so, then your problem is not the table or connection to the tables, but the code behind your button.
- Thread starter
- #7
I can tell you this in design view we have several tabs at the bottom of the page. The tab where the problem is, is called Show when I am in there there is a breakdown
form header
detail
form footer"
It looks like you have a subform called: SfrmExhBooth
Put the arrow of your mouse on the border of this subform, right-click and bring up the properties, go to Data and see if you see:
Link Childs Fields...... ?
Link Master Field....... ?
Is there anything where question marks are at?
form header
detail
form footer"
It looks like you have a subform called: SfrmExhBooth
Put the arrow of your mouse on the border of this subform, right-click and bring up the properties, go to Data and see if you see:
Link Childs Fields...... ?
Link Master Field....... ?
Is there anything where question marks are at?
- Thread starter
- #9
Right, so the linked between the form and the subform is still there. Close the form and don't save!Go to the Database container - thats the window that should be visible at the back of this form with all the database objects; Tables, Queries, Forms, Reports etc. Go to the Form window and find this subform called SfrmExhBooth.Open the form and see if there is any data in it..
"The forms (which is what we pretty much use) has several buttons on it where you can enter information on a show ( what we do) and then print the contract by clicking a button." What do you mean buttons? Do you mean Tabs? and one of these tabs is named "Show"?
"The forms (which is what we pretty much use) has several buttons on it where you can enter information on a show ( what we do) and then print the contract by clicking a button." What do you mean buttons? Do you mean Tabs? and one of these tabs is named "Show"?
- Thread starter
- #11
Yes all of our data is there. Just to give you a little bit more info there is a print contract button on this form and when i click that it says "The command or action Save record is not available now"
All of the fields that are here is what should be appearing in the subform so that we can enter new information. currently if the entry has information entered in it. It will appear but you cannot add any new information
All of the fields that are here is what should be appearing in the subform so that we can enter new information. currently if the entry has information entered in it. It will appear but you cannot add any new information
Before we start messing around with this Database. Make a copy of it on your desktop.
It seems that maybe there is a table relationship problem.
Right-click on the Database Window and click Relationships.
Can you see a whole bunch of tables that are connected to each other?
Its difficult to tell how your database is set up. I need to see how the recordsource:qryExhBooth of your main form relates to your subform SfrmExhBooth recordsource.
Perhaps one of the MVP's on this forum could bring some light into this problem.
It seems that maybe there is a table relationship problem.
Right-click on the Database Window and click Relationships.
Can you see a whole bunch of tables that are connected to each other?
Its difficult to tell how your database is set up. I need to see how the recordsource:qryExhBooth of your main form relates to your subform SfrmExhBooth recordsource.
Perhaps one of the MVP's on this forum could bring some light into this problem.
- Thread starter
- #13
i am already working on a copy of the database. i am viewing the relationships tables and I see there is a bunch of them in there. Ok I know this is going to get touchy since you can't see it but here goes. I see in the relationships screen all tables I don't see anything alled qry exh booth I do see tblexhbooth which I am assuming is the same thing. I don't see any sfrnexhbooth but looking through all these tables I don't see any subforms and I know we have plenty
Lets find out what table or tables is behind this subform.
Find the subform SfrmExhBooth in the Forms container and go to design view, properies, data and the recordsource.
Does have a table or a query? If a table - whats the name?
If a query - open it and see if is based on (1)table or two. Click on the ...button on far right to check.
Find the subform SfrmExhBooth in the Forms container and go to design view, properies, data and the recordsource.
Does have a table or a query? If a table - whats the name?
If a query - open it and see if is based on (1)table or two. Click on the ...button on far right to check.
- Thread starter
- #15
Is there an expression in any of the criteria (****) in any of the fields?
Field:
Table:
Sort:
Show:
Criteria: ****
Can you run the query? - Go to the menubar, click Query and Run. Does the query run and show data in a table format? or does it bring up some error?
Field:
Table:
Sort:
Show:
Criteria: ****
Can you run the query? - Go to the menubar, click Query and Run. Does the query run and show data in a table format? or does it bring up some error?
- Thread starter
- #17
O.K.
Tables O.K.
Relationships O.K.
Links O.K.
But you cannot enter new data, CORRECT?
"We can no longer enter additional information here nor can we print a contract. when i try to click the information it says "You've enetered an expression that has no value"
What do you mean by "click the information"?
"there is a print contract button on this form and when i click that it says "The command or action Save record is not available now"
Can you paste the code behind this contract button. Go to design view and right-click on contract button, properties, event - OnClick....Event Procedure. Put your mouse pointer there and click on the ...button far right.
Copy and paste this code on your reply..
Tables O.K.
Relationships O.K.
Links O.K.
But you cannot enter new data, CORRECT?
"We can no longer enter additional information here nor can we print a contract. when i try to click the information it says "You've enetered an expression that has no value"
What do you mean by "click the information"?
"there is a print contract button on this form and when i click that it says "The command or action Save record is not available now"
Can you paste the code behind this contract button. Go to design view and right-click on contract button, properties, event - OnClick....Event Procedure. Put your mouse pointer there and click on the ...button far right.
Copy and paste this code on your reply..
- Thread starter
- #19
Right you can't enter any new data. In this subform there is a button that says print contract that button basicaly gets the information from the lines in the detail section and prints a contract which is in the database. I was able flipping through there to actually see the contract it is set up as a report
the code for this button is as follows:
ivate Sub cmdPrintContract_Click()
On Error GoTo Err_cmdPrintContract_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "rptExhBoothContract"
stLinkCriteria = "[BoothID]=" & Me![BoothId]
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
Exit_cmdPrintContract_Click:
Exit Sub
Err_cmdPrintContract_Click:
MsgBox Err.Description
Resume Exit_cmdPrintContract_Click
End Sub
the code for this button is as follows:
ivate Sub cmdPrintContract_Click()
On Error GoTo Err_cmdPrintContract_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "rptExhBoothContract"
stLinkCriteria = "[BoothID]=" & Me![BoothId]
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
Exit_cmdPrintContract_Click:
Exit Sub
Err_cmdPrintContract_Click:
MsgBox Err.Description
Resume Exit_cmdPrintContract_Click
End Sub
The forms (which is what we pretty much use) has several buttons on it where you can enter information on a show ( what we do)"
What about the other buttons/ or Tab forms. Can you enter data on them?
The Tab form with problem - you could see data, Correct? But when you start a new record do you still have the problem of entering data in this subform?
What about the other buttons/ or Tab forms. Can you enter data on them?
The Tab form with problem - you could see data, Correct? But when you start a new record do you still have the problem of entering data in this subform?
- Status
Similar threads
- Locked
- Question