Recent content by jimster68

Export subform results to Excel - solution Well I discovered something that works. DoCmd.OutputTo acOutputForm, "frm_Server_Data", acFormatXLS, _ strPath & "\ServerData.xls" ', AutoStart:=-1 This outputs the filtered results from the subform to the spreadsheet. :)

I have built a main form that includes controls to filter/search records from a subform based on a query. The query pulls data from multiple tables. I want to create another command button in the main form to export the filtered results from the subform to an excel spreadsheet. I have the...

thanks for the response. I guess I failed to mention that this subform is based on a query that pulls from multiple tables. I assume I would substitute the query name for the table name in your example? I did manage to find an VBA example of what I was looking for and implemented that code...

I'm trying to filter a subform with multiple combo boxes and eventually some text fields tied to one command button to execute the search/filter. I want the user to determine which filter or combination of filters to use. I started with the combo boxes and can get one to work, however, when I...

Thanks for the feedback! I restrucutred the tables like you suggested and now I'm getting good results. I can now update the main table without the other data, return to the record later and add data for the satallite tables. When it updates it automatically adds the key value to the...

I have three tables setup in a 1 to 1 relationship using a Autonumber field as their primary keys. I created the seperate tables to group related data together and reduce the tables sizes in general. So think of it as one main table and two tables of extended data. I need to be able to add a...