97 to 2003 -- help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm sorry this is so long! I admit I'm totally lost in Access anyway ... I know (or knew) enough to accomplish the one task I need it for and that is it. Now I can't even do this one task anymore! Previously using Access 97 and Word 97 to merge. Use Query to pull out all of the specific month's birthdays and then merge the query data with word to print that month's birthday envelopes. This has worked great for me for the past five years
Recently upgraded to 2003 and I can't get my merge to work at all. Here is what happens
I click on the main merge doc in Word. It says: "Opening this document will run the following SQL command: SELECT*FROM [November 2003]. Data from your database will be placed in the document. Do you want to continue?"
I click yes. It then says
"(file name) is a mail merge document" and Word can't find the data source, etc. I select the data source, select the query. My document opens. I click on "merge to new document." I get this message
"Word could not merge the main document with the data source because the data records were empty or no records matched your query options.
I have also tried exporting from Access and running the merge from Access. I get the same message. Nothing has changed in the merge document in Word or the query in Access. I even tried other queries that were set up and they don't work either. I CAN merge records from the table, but not the query.
Aside from telling me to take an Access class (yes, I know I need to), any ideas from anyone? Thank you and I appreciate your help
 
<snip>
etc. I select the data source, select the query. My document opens. I
click on "merge to new document." I get this message:

If you open the query in Access and click the red exclamation point do you
get a result?
If not - then there are no records.
HTH
Marc
 
Lee said:
I'm not sure I know what you mean, but this is what I did. I opened the
Click to expand...
query in Access. All data is there. I searched the toolbars until I found
the red exclamation point (called "Run") and put it on my toolbar. I
clicked on the red exclamation point. Nothing happened. All my data is
still there. The merge in word still does the same thing.


Hi
Ok, if the data is there and when you click run no records are returned you
then need to check your criteria:
Highlight the field your criteria works on.
Go ctrl-F.
In the find box enter your criteria - just the text - March 2004 (if I
remember)
Hit enter - does it find any data?
If it does not - then the date does not exist in the field, and your query
is working correctly.
If it does - then the way the criteria is being specified is incorrect.
Go to your query - change the design view to the sql view and post the sql
here.
Marc
 
I'm sorry -- I don't follow what I'm supposed to do here. It's been a few days and I've done some more reading. Here's what I've done
Started all over again and transferred database to new computer -- updated Access97 to Access 2000.
Got conversion errors message
Opened a module, clicked Compile (file name) on the Debug menu
Cleared the DAO 2.5 compatibility box, checked the DAO 3.6 box

When I try to merge the April 2004 Query contents with the Word document, the Query still shows as blank. The Word document was a Word 97 (now Word 2003) mail merge document with fields already set up that match the fields in the Query -- FirstName, LastName, etc.

I can merge the whole Table, just not the Query.
 
When I try to merge the April 2004 Query contents with the Word document,
Click to expand...
the Query still shows as blank. The Word document was a Word 97 (now Word
2003) mail merge document with fields already set up that match the fields
in the Query -- FirstName, LastName, etc.
I can merge the whole Table, just not the Query.
Click to expand...

Hi,
I'll repeat it here
Open the query
Run it without any parameters
Highlight the birthday date column
Go ctrl-F.
In the find box enter your criteria - just the text - March 2004 (if I
remember) - in the same format as the word doc would send it.
Hit enter - does it find any data?
If it does not - then the date does not exist in the field, and your query
is working correctly.
If it does - then the way the criteria is being specified is incorrect.
Go to your query - change the design view to the sql view and post the sql
here.

Marc
 
Thank you Marc, for your help. Again, I don't think I'm following you -- I apologize. I am extremely lost in this program. Here is what I did

Opened Access, opened the query named "April 2004." Switched to design view
Removed the criteria in the birthdate column, which is "Like 4/*"
Query now shows the entire database of 1700+ entries
Highlighted the birthdate column of the query, and type a date I know is in the April 2004 query - 4/01/61 - and hit enter
I am taken to that date in the list

Here is the sql
SELECT [Mailing List].Code, [Mailing List].Holiday, [Mailing List].Birthdate, [Mailing List].LastName, [Mailing List].FirstName, [Mailing List].Address, [Mailing List].City, [Mailing List].State, [Mailing List].PostalCode, [Mailing List].Note, DatePart("d",[Birthdate]) AS Expr1, [Mailing List].LastNam
FROM [Mailing List
ORDER BY DatePart("d",[Birthdate]), [Mailing List].LastName

Thank you again for your time and assistance.
 
Lee said:
Thank you Marc, for your help. Again, I don't think I'm following you --
Click to expand...
I apologize. I am extremely lost in this program. Here is what I did:
Opened Access, opened the query named "April 2004." Switched to design view.
Removed the criteria in the birthdate column, which is "Like 4/*".
Query now shows the entire database of 1700+ entries.
Highlighted the birthdate column of the query, and type a date I know is
Click to expand...
in the April 2004 query - 4/01/61 - and hit enter.
I am taken to that date in the list.

Here is the sql:
SELECT [Mailing List].Code, [Mailing List].Holiday, [Mailing
Click to expand...
List].Birthdate, [Mailing List].LastName, [Mailing List].FirstName, [Mailing
List].Address, [Mailing List].City, [Mailing List].State, [Mailing
List].PostalCode, [Mailing List].Note, DatePart("d",[Birthdate]) AS Expr1,
[Mailing List].LastName
FROM [Mailing List]
ORDER BY DatePart("d",[Birthdate]), [Mailing List].LastName;

Thank you again for your time and assistance.
Click to expand...
Hi,
3 questions -
Do you have queries April, May, June, July, etc?
When you do the merge setup in Word do you select the April 2004 query?
If birthdate on the Mailing list table in date format or text?
Thanx
Marc
 
Hi Marc
I have two "month" queries that I use, then change the birthdate criteria each time and rename the query. I also will change the code criteria to pull out the specific clients that receive the mailing
Yes, I do select the April 2004 query when I do the merge setup in Word
The birthdate field is in text format
 
Lee said:
Hi Marc,
I have two "month" queries that I use, then change the birthdate criteria
Click to expand...
each time and rename the query. I also will change the code criteria to
pull out the specific clients that receive the mailing.
Yes, I do select the April 2004 query when I do the merge setup in Word.
The birthdate field is in text format.
Click to expand...
Hi
Sorry for the delay, a bit busy.
I tried your query using Office 2000 but it didn't work either. But what did
work was

Between '04/01/2004' And '05/01/2004'

I know it doesn't answer the whys, but is solves your problem.
Marc
 
It Works!
I used -- Between "4/01/*" And "5/01/*" -- and they all merged perfectly in Word
I will still wonder why ... but at this point I am just happy to be able to use my new computer to do what I need for my client.

A thousand thanks for your help and patience!!
 
Back
Top