Ok, so after googling every possible keyword, I reached this site and so hopefully, someone can help me with my problem.
I am trying to convert an excel workbook, with 4 spreadsheets within it, to a MS Access 07 database. The first sheet contains a site name in the 1st column, and the following columns contain cross-sectional information, length, county, state, and other miscellaneous information.
The other 3 spreadsheets have the same first column with the site name, but the columns that follow it are the dates and names of the people involved with the project.
So far I have taken the first spreadsheet and made a basic form in which I use DLookup to show all the relevant information related to that site once I choose a location from the dropdown. (For example, I choose Elizabeth, NJ and it displays all the relevant information across multiple text boxes with the "OnUpdate" event)
What I want to accomplish is this:
I want a form that will reference the first table with the site names via a combo box, this should be easy enough since I did this already with DLookup. But when I reference that sitename X, I want the other textboxes (the date of the project and who is involved) to record whatever input I enter into the second, third, and fourth table respectively. Now, I wouldn't mind doing this for the 2nd table and then just making duplicate forms that emulate the same function for the 3rd and 4th table, but it's just getting this first one done that is really troubling me. I haven't used Access in years, and I don't think that what I'm asking for help with is a big feat. I actually think this is fairly simple, but I don't know enough about this program to do it on my own.
I hope that made sense. Sorry if that was too wordy. I can elaborate further if need be.
Edit: Well it appears that the form's default behavior does exactly what I need it to do(when I use the Record navigation at the bottom NOT when I use the combo box), but the caveat about using the dropdown is that if you navigate to the next row down using the record navigation controls at the bottom (i.e. Record 1 of 50), the entry is duplicated on another ID # and overrides the selected cell. For example, if I choose Elizabeth, NJ from the dropdown, and it is normally given an autonumber of 5. If I am on the record for 1 of 37, then if I navigate to 2 of 37, then the 1 of 37 record will now also show Elizabeth, NJ in addition to record of 5/37. Is there anyway to prevent this user error from happening besides not using a dropdown/combo box?
I am trying to convert an excel workbook, with 4 spreadsheets within it, to a MS Access 07 database. The first sheet contains a site name in the 1st column, and the following columns contain cross-sectional information, length, county, state, and other miscellaneous information.
The other 3 spreadsheets have the same first column with the site name, but the columns that follow it are the dates and names of the people involved with the project.
So far I have taken the first spreadsheet and made a basic form in which I use DLookup to show all the relevant information related to that site once I choose a location from the dropdown. (For example, I choose Elizabeth, NJ and it displays all the relevant information across multiple text boxes with the "OnUpdate" event)
What I want to accomplish is this:
I want a form that will reference the first table with the site names via a combo box, this should be easy enough since I did this already with DLookup. But when I reference that sitename X, I want the other textboxes (the date of the project and who is involved) to record whatever input I enter into the second, third, and fourth table respectively. Now, I wouldn't mind doing this for the 2nd table and then just making duplicate forms that emulate the same function for the 3rd and 4th table, but it's just getting this first one done that is really troubling me. I haven't used Access in years, and I don't think that what I'm asking for help with is a big feat. I actually think this is fairly simple, but I don't know enough about this program to do it on my own.
I hope that made sense. Sorry if that was too wordy. I can elaborate further if need be.
Edit: Well it appears that the form's default behavior does exactly what I need it to do(when I use the Record navigation at the bottom NOT when I use the combo box), but the caveat about using the dropdown is that if you navigate to the next row down using the record navigation controls at the bottom (i.e. Record 1 of 50), the entry is duplicated on another ID # and overrides the selected cell. For example, if I choose Elizabeth, NJ from the dropdown, and it is normally given an autonumber of 5. If I am on the record for 1 of 37, then if I navigate to 2 of 37, then the 1 of 37 record will now also show Elizabeth, NJ in addition to record of 5/37. Is there anyway to prevent this user error from happening besides not using a dropdown/combo box?
