RayRider
asked on
Looking for Microsoft Access 2010 Macro Example
I am familiar with Access 2010 except have no experience with Macros. If I could get a sample explanation for what I wish to do, I believe I could manage getting it done. Here is what I wish to do:
I have a table in a database that is quite large, 600K+ records. I wish to create a "query form" that will allow me to enter the search key, for example, the "last name". Then populate the form with the query results of selected fields from this rather large table, such as last name, first name, address, state, zip, etc. Once the data is examined on the form, I wish to have a "button" with a macro attached to it that would allow only these fields on the query form to be inserted into a separate table.
The overall objective is to take paper sheets with names that I wish to find in the database table, if found, I wish to write out these fields to another table. This is a huge table with about a hundred fields, all I want are the fields I mentioned, and once found, create an entry of this limited data to another table.
This should be easy. I have never done this in access.
I have a table in a database that is quite large, 600K+ records. I wish to create a "query form" that will allow me to enter the search key, for example, the "last name". Then populate the form with the query results of selected fields from this rather large table, such as last name, first name, address, state, zip, etc. Once the data is examined on the form, I wish to have a "button" with a macro attached to it that would allow only these fields on the query form to be inserted into a separate table.
The overall objective is to take paper sheets with names that I wish to find in the database table, if found, I wish to write out these fields to another table. This is a huge table with about a hundred fields, all I want are the fields I mentioned, and once found, create an entry of this limited data to another table.
This should be easy. I have never done this in access.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I really appreciate the time you spent on this question. I will use your help a bit later. At the moment, I realized how important it was to know VBA. I am in progress of taking a course on VBA. When finished, I will use your advice and the knowledge from the course to complete this task at hand.