Hi gurus
I've designed several autoforms in MS Word for our organisation. The question has been posed as to whether client info entered into the forms can be recorded in our case-noting system, which is housed in a MySQL database on a remote server.
The logic of it seems simple:
1. Compile an 'INSERT INTO' SQL string from the various formfields on the document; and then
2. At the point the document is saved, have VBA execute the SQL via the MySQL ODBC connector.
I've achieved 1. easily but most of my VBA experience is in Access, and I'm a little lost without being able to use the same VBA in Word. Needless to say, Docmd.RunSQL and the like do not work in Word VBA.
In the casenote system I used the code provided by MS at to write to MySQL from Access.
Can anyone offer a solution to write to MySQL from MS Word?
Cheers
I've designed several autoforms in MS Word for our organisation. The question has been posed as to whether client info entered into the forms can be recorded in our case-noting system, which is housed in a MySQL database on a remote server.
The logic of it seems simple:
1. Compile an 'INSERT INTO' SQL string from the various formfields on the document; and then
2. At the point the document is saved, have VBA execute the SQL via the MySQL ODBC connector.
I've achieved 1. easily but most of my VBA experience is in Access, and I'm a little lost without being able to use the same VBA in Word. Needless to say, Docmd.RunSQL and the like do not work in Word VBA.
In the casenote system I used the code provided by MS at to write to MySQL from Access.
Can anyone offer a solution to write to MySQL from MS Word?
Cheers