I use a Word Application written in VBA to print stuff with RBase as the
data source.
I use a DSN-Less connection and would eschew any other connection means as
inflexible and difficult to maintain.
The driver is just RBase, but the connection string would be the same
excepting substutute the Oterro driver:
Watch for line wrap..
Const strCnn = "Provider=MSDASQL.1;DRIVER={R:BASE 7.6 Database Driver
(*.rb1)};DBQ=F:\rb76\bar\bar;UID=;PWD=;"
----- Original Message -----
From: "Dan Goldberg" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, December 18, 2009 10:33 AM
Subject: [RBASE-L] - report templates
I would like to create a report template for letters.
The user would create the guts of the letter in MS Word. I would give them
the mail merge field naming so they could put it into their Word doc. Then
they save it as an rtf and e-mail it to me. I then have to go into report
designer and put it into the report so they can print it.
It would be nice if there was a property to grab the rtf and put it into a
field on the report.
I have tried oterro but it does not behave nicely with office. Everytime I
try to connect to the database from Word it gives me an error:
"The Data Connection Wizard cannot obtain a list of databases from the
specified data source."
Any suggestions??
Dan Goldberg
