RE: Troubleshoot Select Table - Mail Merge in Word from Access Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I remember an issue where the Select Table list would not show the first
table in the database. The work-around was to create a bogus table named
something like AA.

Of course you probably need to make sure that you have the latest service
pack installed. On the flip side, possibly something was installed recently
and it is causing this new problem.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Smayer" wrote:

I have created numerous queries in Access 2003. When using the mail merge
function in Word I have always been able to click on the browse button, find
the location of my Access database which prompts a box "select table".
However, the last several times I have created a new query the table or query
doesn't appear in the "select table" list. I am using an export work around,
but it takes more time. Is anyone familiar with an issue like this? Thank you
.



Relevant Pages

  • Re: Help! Error - the object is locked, any changes will be discar
    ... Dave Hargis, Microsoft Access MVP ... I will split the database when it's complete to ... Is the query updateable? ... When you say each table is on a separate tab have you just placed the fields ...
    (microsoft.public.access.gettingstarted)
  • Re: Seriously Numpty Query Question
    ... INTO) query is IMHO seldom the best way to proceed, ... We are looking to link an Access database to Great Plains, ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.gettingstarted)
  • RE: Weird issue
    ... to be a NIC using the database; ... corruption problems is to split your database between a Front End ... Jerry Whittle, Microsoft Access MVP ... importing everything (except the query of course) into a new database will ...
    (microsoft.public.access.queries)
  • RE: Strange result from query, > gives same result as >=
    ... Using your query there are differences between the table working and the ... As the dates work after importing, I'm wondering if your database is ... Jerry Whittle, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Delete an Access query using VB code
    ... Our whole project is based on ADO. ... > using DAO and that I'm not deleting the query if it exists, ... > Doug Steele, Microsoft Access MVP ... >> go out to the database, find the query if it exists, delete it and create ...
    (microsoft.public.vb.database)