Hello
Please excuse me if this is in the wrong area. I am attempting to solve this problem with VBA so I figured this might be the place.
I work on an Access 2007 database that has some pretty complex queries. One of these uses multiple steps in order to ultimately produce query results in a data sheet view.
What one of the users does at this point is to filter on certain columns based on whatever further criteria he may have. Once he is complete with the filter set of rows he would like to edit one of the fields for multiple records.
Now we already have a process in place where the source records can be altered but not directly from the dataset I described. He would normally do a copy and paste of the pertinent fields from Access into Excel, make his changes and save the spreadsheet. He can then import those records into the Access database. We have a macro set up to do the import from the file automatically for him.
My question is can I programmatically have the filtered results copied and sent to a temp table? Once in a table I could have the user make his changes, save it and possibly run another macro that would update the source data. If I can simply do copy of filtered results to a table in Access I can handle the rest. It would also skip the step with Excel which is preferable.
I tried several approaches, but since this is a plain old query any copying of it seems to copy the query object(thus the unfiltered results), not the results. This also doesn't put the results in a place where they are editable.
I even attempted a sendkeys macro but I really don't want to go down that road. I really feel like this is something simple, I just do not know all the in's and out's of VBA syntax.
Thanks for any help you may be able to provide,
Heywood
Please excuse me if this is in the wrong area. I am attempting to solve this problem with VBA so I figured this might be the place.
I work on an Access 2007 database that has some pretty complex queries. One of these uses multiple steps in order to ultimately produce query results in a data sheet view.
What one of the users does at this point is to filter on certain columns based on whatever further criteria he may have. Once he is complete with the filter set of rows he would like to edit one of the fields for multiple records.
Now we already have a process in place where the source records can be altered but not directly from the dataset I described. He would normally do a copy and paste of the pertinent fields from Access into Excel, make his changes and save the spreadsheet. He can then import those records into the Access database. We have a macro set up to do the import from the file automatically for him.
My question is can I programmatically have the filtered results copied and sent to a temp table? Once in a table I could have the user make his changes, save it and possibly run another macro that would update the source data. If I can simply do copy of filtered results to a table in Access I can handle the rest. It would also skip the step with Excel which is preferable.
I tried several approaches, but since this is a plain old query any copying of it seems to copy the query object(thus the unfiltered results), not the results. This also doesn't put the results in a place where they are editable.
I even attempted a sendkeys macro but I really don't want to go down that road. I really feel like this is something simple, I just do not know all the in's and out's of VBA syntax.
Thanks for any help you may be able to provide,
Heywood
