I just pasted the data you gave me into the sfmexhbooth.
Could you open the subform:SfmExhBooth on its own and see data? Yes I can see data always could. Just cannot enter new data nor can I print a contract from here same error as on main form.
In design view of this new subform, go to properties, Data, AND is the following correct:
Link Childs Fields...... intID
Link Master Field....... ID
No i changed the Link master field to this above. Still the same outlook
- Go to the Forms container and find the subform name SfrmExhBooth...
Ok I tried to add the subform and I had a little bit of a problem. i could not add it in with the rest of the tabs so i just left it floating on the page. I tried to add information to it and there was no change could not add any information. It doesn't even bring up the text boxes for you to...
Here is the main form frmExhibitor code:
Option Compare Database
Private Sub Combo39_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[txtLName] = '" & Me![Combo39] & "'"
Me.Bookmark = rs.Bookmark
End Sub...
Here is the programming code: in the meatime I am going to try to reinsert the subform as you suggested.
Option Compare Database
Private Sub Check36_AfterUpdate()
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "rptExhBoothContract"
stLinkCriteria =...
Yes I receive an error in the event log which says:
The driver detected a controller error on \Device\Tape0.
I haven't tried the dell driver. It's definately not the drive because this is the third drive from dell and all of them act the same way. And I would think that if it was the drive or...
Ok under the table design view:
tblexhibitor
ID Autonumber
tblexhbooth
intID Number
tblconference
conID Autonumber
In the queries view (I hope I make sense here) the three tables are shown as boxes and they are linked via a line to each other with these ids Under this chart is another...
I am running Veritas backup exec 9.1 on a windows 2003 small business server. I run a full backup every night of approx. 16Gb of data. We had a problem where our backups were not running, Dell replaced the travan drive, cable and system board. That seemed to be where the problem was. The backups...
They other tabs yes you can enter new data.You can see data that has been previously entered. If you start a new record you cannot enter data on this tab.
The information you requested below can you tell me where I would get this? i am not sure what info to provide you with.
Give me the field...
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...
Ok In the design view under properties for the subform it says qryExhBooth. When I open that clicking the button on the right it shows a relationship of tblexhibitor to tblexhbooth to tblconference
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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.