I have a subform in datasheet view that I need to copy and paste multiple records into from an excel spreadsheet. The pasted data goes to a table that has an autonumber field as the primary key. I want to change the autonumber field to one that enters values incrementally based on VBA code to...
I have two tables in a one-to-many relationship. In one of the fields on the child table I found that the data in two records was changed to "?/". When I query the data these records are still related to the correct records in the parent table. When I try to change "?/"...
I have two command buttons that I am using to open and close a subform. To open the subform in the main form I am using the code:
Private Sub OpenSubform_Click()
Me![SubformName].Form.Visible = True
End Sub
To close the subform in the main form I am using the code:
Private Sub...
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.