Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access --> Word

Access --> Word

Access --> Word

Hi all, hope you can help!

This is split in to a couple of questions.

1. I have a normal run of the mill access database what I need to be able to do is enable the users to select what criteria they want to search on and then enter that criteria.

2. Relating to above. Once the user has "filtered" the data on the criteria they selected I want to enable them to import the data on to a word template so I can automate the mail merge function. I would also like to be able to do this for emails so the user selects/enters the criteria and emails all the contacts in the resulting data.

Anyone shed any light?
Replies continue below

Recommended for you

RE: Access --> Word

OK, I need a bit of clarification.

Do you want to allow your users to choose which fields they want to see AND what data within those fields, or do you just want them to be able to set the criteria for certain, pre-defined fields?


RE: Access --> Word

Yes i want the user to choose which fields and the data they want query on.

Eg. one user might want to find all records of all companies in Manchester that have product x.

The user would be able to say "Query on "Town and Product"" and specify the criteria for these fields


RE: Access --> Word

Since you are using this for a mail merge, you know what resulting fields you want to have in your resultset.

So you know that your SQL statement will begin

SELECT Title, First, Last, Company, Add1, Add2, City, State (hmmmm, what is the equivalent in the UK?), PostalCode
FROM tblTableName

and the WHERE is the problem.

If I am with you so far, my next question is, how sophisticated are your users?  Can you give them a form listing every field and a text box next to each field for them to enter criteria?  Will they know about AND and OR?


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close