How can I populate a worksheet from an access database and update a

Hello to all,

I am hoping someone can help and/or lead me in the right direction. I have a vehicle database created with basic info (unit no, make, model, license, etc..) I have a created a query within the database that when asked for a specific unit number [enter unit number] the query returns the unit number and other relevant data from that record. I have an inspection worksheet that I want all the information generated in the query to populate the worksheet cells from the results of the queried data. Ideally I wanted to input a unit number on the worksheet and have it hit the query in the Access database or just query the database and return the needed info into the defined cells in the worksheet. For example I would put 701 in the unit number cell of the worksheet, then ask the worksheet to do something...... import data, query, ?? and would then get the unit number and populate the other cells on the worksheet with the model, make, year, license, etc...


This is a two part question. The second task would be once the worksheet data was populated I would use the worksheet for the inspection which then after wanted to update a table within the same database. For example once the worksheet was populated with vehicle information in the previous step I would now use the worksheet to complete the inspection. I would then have the current inspection date, mileage, and inspection type information that I would want to add back into a PM Inspection table in Access. This table would continually be updated from the results of an inspection.

I do not have a lot of experience in Access but conceptually know what I want to happen. Hoping somewhere here could me.

Thanks
Todaychris

Not sure how to do that. Was thinking I needed to learn some VBA and first bring my data into another worksheet SheetX then compare my entry on Sheet1(A1) to data in column A of SheetX. The idea I was considering since I am limited in knowledge in the other area was hopefully I could understand how to create a macro that will compare a value I entered in Sheet1(A1) to the data in column(A)in SheetX. Once the correct data was found I would want the data in the next several cells to the right of it on SheetX copied to Sheet1(A2:A4).

Hopefully my rambling makes sense.

Is there a way to share the sheet and database?

The zip file includes the excel workbook and mdb database. I highlighted in blue the cells I wanted data from the database to populate. I planned to manually enter a vehicle no. in the merged cell B1 on the system sheet and use a macro to find the matching unit number in the database or worksheet table from the database and complete the remainder of the vehicle information in the highlighted cells.

The main table lists all of the vehicles. The other two table I planned to populate them with data following my inpsections. I guess the uploading back to the database I will learn after this test is figured out. The plan there was once I completed the inspection the new mileage and date will update the tables with current PM inspection mileage and date. Thanks

Hi David,

The inspection date and mileage are what we will be entered on the form during the inspection process. The two tables MV_PMI and BusPMI are what I wanted to update. The BusPMI would update from the worksheet. The MV_PMI will be receiving input from another data source. Yes your right the date, mileage, and location should probably be only merged into F:H. Think that was just done for appearance.

Hi David,

I got the project back. What can you explain on what I will need to know to run it.