#1   Report Post  
Michel
 
Posts: n/a
Default why char(96)

Hi
I've word 2002 sp3 win xp pro sp2 and access 2002 sp3 all in french and just
installed.
I'm doing mailMerge from word in vba
When I submit an sql statment to ActiveDocument.MailMerge.OpenDataSource
I've to put the name of the table between ` (char 96) (for all the string in
the query I can use a single quote)
Without this char 96 word pops up an window asking me to choose a table...

ActiveDocument.MailMerge.OpenDataSource
Name:="C:\myDb.mdb",
Connection:="Provider=Microsoft.Jet.OLEDB.4.0;User
ID=Admin;Mode=Read;Jet OLEDB:Engine Type=5;Jet OLEDBatab;Data
Source=C:\myDb.mdb",
SQLStatement:="select * from `myTable` where no = '0003-2001'"


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 11:59 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"