Home |
Search |
Today's Posts |
#7
Posted to microsoft.public.mac.office.word,microsoft.public.word.mailmerge.fields
|
|||
|
|||
fields queries and utter disaster
Aside from the issues that have been raised by Peter, does anyone understand
what the OP means by: I have a data source that contains two tables - table one has an id1 and some other fields and id1 is the primary key, table2 has as its primary key id2 but also contains id1 from table1 for linking. I want my word document to ask for a value for id2. And the select id1 and id2 if and only if table1.id1 equals table2.id1 and table2.id2 contains the value that i was asked for intially. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Paul Berkowitz" wrote in message ... I suggest pinging JE McGimpsey. If anyone knows, he will. -- Paul Berkowitz MVP MacOffice Entourage FAQ Page: http://www.entourage.mvps.org/faq/index.html AppleScripts for Entourage: http://macscripter.net/scriptbuilders/ Please "Reply To Newsgroup" to reply to this message. Emails will be ignored. PLEASE always state which version of Microsoft Office you are using - **2004**, X or 2001. It's often impossible to answer your questions otherwise. From: Peter Jamieson Newsgroups: microsoft.public.mac.office.word,microsoft.public. word.mailmerge.fields Date: Sat, 29 Apr 2006 17:54:19 +0100 Subject: fields queries and utter disaster Still no obvious way to do it here - it's possible to get the data via Excel and the Excel VBA Help gives an example of how to do it programmatically, but I haven't been able to get it to work so far (again, on Office 2004). Next opportunity to look is in a couple of days' time, but I'd have thought someone on the Mac side had had a thorough go at this and knows what's feasible. Peter jamieson "John McGhie [MVP - Word and Word Macintosh]" wrote in message ... My Bad... The OP did specify Office X... In which case the following link may help: http://www.microsoft.com/mac/otherpr...pid=usingoffic ex&type=howto&article=/mac/LIBRARY/feature_articles/officex/xl_ODBC.xml On 29/4/06 7:38 PM, in article , "Peter Jamieson" wrote: Hi John etc., I'm going to spit this off to the group that specialises in this kind of thing, however, my first question is "How did you get a connection to mysql from Microsoft Office in the first place?" The people in the mailmergefields group need to know that you are doing this in Macintosh OS 10.4.5 (Unix) using Microsoft Office 2004. I had the impression that it was using Office X, but unfortunately I am much more ignorant on Mac issues and can only experiment with Office 2004, i.e. (a) do not know whether it is possible to connect directly using ODBC with Office X and (b) what the appropriate syntax for OpenDataSource (or a { DATABASE } field, if that is what the questioner wants) would be on Mac. On the Windows version this is doable partly because it's possible to specify "" as the Name in the OpenDataSource call when the ODBC DSN is a machine DSN (i.e. in the registry), or use a file DSN. If someone on the Mac side knows the answer to the general ODBC connectivity questions maybe we could get a little bit further. Peter Jamieson John McGhie [MVP - Word and Word Macintosh]" wrote in message ... I'm going to spit this off to the group that specialises in this kind of thing, however, my first question is "How did you get a connection to mysql from Microsoft Office in the first place?" The people in the mailmergefields group need to know that you are doing this in Macintosh OS 10.4.5 (Unix) using Microsoft Office 2004. This is a specialist area, and I am by no means a specialist. However, I think your answer will be something along the lines of "You need to use the Database toolbar to insert the database into your data source as a Word table." Once you have done that, you can then query the fields in that table. Hope this helps On 28/4/06 8:37 PM, in article , " wrote: Hi I'm trying to solve the following. I have a data source that contains two tables - table one has an id1 and some other fields and id1 is the primary key, table2 has as its primary key id2 but also contains id1 from table1 for linking. I want my word document to ask for a value for id2. And the select id1 and id2 if and only if table1.id1 equals table2.id1 and table2.id2 contains the value that i was asked for intially. or to put it in mysql language SELECT Table1.ID1, Table2.ID1 FROM TABLE1, TABLE2 WHERE Table1.ID1 = TABLE2.ID1 AND TABLE2.ID2 = ? I can access the table, my problem is that I cannot figure out the proper syntax for MSWords fields As far as I can tell I should be able to do this using IF combined with ASK but I've spent the better part of my day not getting any closer att all. I would really appreciate any help. I might add i would like this to be don on saving or printing but only once for each document .. so if its opened again it will not ask .. in other words if the fields are filled in dont ask. But I'll settle for just getting the first part! -- Please reply to the newsgroup to maintain the thread. Please do not me unless I ask you to. John McGhie Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer Sydney, Australia +61 (0) 4 1209 1410 -- Please reply to the newsgroup to maintain the thread. Please do not me unless I ask you to. John McGhie Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer Sydney, Australia +61 (0) 4 1209 1410 |