Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mail merge - change parameter in query

Status
Not open for further replies.

696796

Programmer
Aug 3, 2004
218
GB
Hi experts,

i have set up a mail merge in ms word, and have linked it to a query in my access 97 database. Now i want to be able to change a parameter in the query, i.e. CarNo(a number which is unique to each record). How is it best to send this to the query/word document - at the moment it is a query stored in the access database the document is linked to, but how can i get the different CarNo into that query each time?

I can also build the query in vb.net if that would be easier to control the document with?

Any help much apreciated guys and gals,

Al

 



Hi,

You can build a Parameter Query by using ? in place of the criteria value.

You will be prompted for a value at run time.

Skip,

[glasses] [red][/red]
[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top