A
Andy
Hi;
Using code created by Albert D. Kallal to merge an Access qry to Word.
(A2K)
Thank You Albert.
All works well except for one qry. With that particular Qry getting an
"OverFlow" error when opening the "frmWordTemplateList".
Checked Microsoft KB, found:
SYMPTOMS
When you attempt to use the Input Mask Wizard in Microsoft Access, you
receive the following error message:
Overflow
RESOLUTION
To resolve this issue, rename Acwzusr.mdt, and then restart Microsoft
Access. To do this, follow these steps:
1. Quit Access if it is open.
2. Click Start, point to Search, and then click For Files or Folders.
3. Search for files named Acwzusr.mdt.
4. In the Search Results list, right-click Acwzusr.mdt, and then click
Rename. Type Acwzusr.old, and then press ENTER.
5. Start Access.
The qry does have one input mask for the phone number. But so do all of the
others.
Found "Acwzusr.mdt" in two locations on the machine: One was 1,756KB dated
10/16/2006 6:34PM, the other 1,700KB 01/13/2000 4:30AM.
Renamed both and restarted Access. Now there isn't a single "Acwzusr.mdt"
on the machine and still getting "OverFlow" error.
The qry works correctly in Access, (both in rpts and when opened by itself).
The odd thing is that it had worked previously.
Not sure if its pertinent; this is the only qry that includes an image
field.
Any suggestions?
Thank You for taking the time to read this post.
Andy
Using code created by Albert D. Kallal to merge an Access qry to Word.
(A2K)
Thank You Albert.
All works well except for one qry. With that particular Qry getting an
"OverFlow" error when opening the "frmWordTemplateList".
Checked Microsoft KB, found:
SYMPTOMS
When you attempt to use the Input Mask Wizard in Microsoft Access, you
receive the following error message:
Overflow
RESOLUTION
To resolve this issue, rename Acwzusr.mdt, and then restart Microsoft
Access. To do this, follow these steps:
1. Quit Access if it is open.
2. Click Start, point to Search, and then click For Files or Folders.
3. Search for files named Acwzusr.mdt.
4. In the Search Results list, right-click Acwzusr.mdt, and then click
Rename. Type Acwzusr.old, and then press ENTER.
5. Start Access.
The qry does have one input mask for the phone number. But so do all of the
others.
Found "Acwzusr.mdt" in two locations on the machine: One was 1,756KB dated
10/16/2006 6:34PM, the other 1,700KB 01/13/2000 4:30AM.
Renamed both and restarted Access. Now there isn't a single "Acwzusr.mdt"
on the machine and still getting "OverFlow" error.
The qry works correctly in Access, (both in rpts and when opened by itself).
The odd thing is that it had worked previously.
Not sure if its pertinent; this is the only qry that includes an image
field.
Any suggestions?
Thank You for taking the time to read this post.
Andy