Using VB to export query

[phillbaker]

i have a form which uses a calender then runs a query and picks out staff members who are in the next day and you can click a button to open an access report which then shows there jobs for the next day.

This means i then have to put preprinted paper in the printer with logos etc. I have electronic versions on of preprinted paper in word and excel what is the best way to export the information over to these programs so then i can print everything off in one go.

 

[JamesMcS]

Can you add the images from the headed paper into the report?

 

[phillbaker]

the preprinted paper i was on about was actually a table with lots of different columns and cells on it not just graphics. Some of the text i want to import has to go into specific cells etc on the forms.

 

[JamesMcS]

Ah OK - well, you can link a spreadsheet to a database, or use Word's mail merge I expect. In Excel 2003, it's Data > Get Externa Data > Create new query or something, I forget now. In Excel 2007 it's "From Access" on the data tab.

 

[phillbaker]

the data im wanting to import though is queried in access for certain dates etc should that still work with this method.

 

[JamesMcS]

Yes, you can specify criteria in the query builder. Have a look and see how you get on