If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record 1 contains too few data fields
I've got Office 2003 Pro - trying to merge a query into word - I've had
not problems with it before (with other querys) but now - I keep getting this error message - I've loaded all the hotfix files and patches and attempted to follow one web site that had me change some of the registry items - but nothing works - does anyone know if there is any way around this - I can't even set up my mail merge doc with the query fields. Thanks Keith |
#2
|
|||
|
|||
Record 1 contains too few data fields
What is the data source? (by "query", do you mean "Access Query" or
something else?) Peter Jamieson "KingKaos" wrote in message ... I've got Office 2003 Pro - trying to merge a query into word - I've had not problems with it before (with other querys) but now - I keep getting this error message - I've loaded all the hotfix files and patches and attempted to follow one web site that had me change some of the registry items - but nothing works - does anyone know if there is any way around this - I can't even set up my mail merge doc with the query fields. Thanks Keith |
#3
|
|||
|
|||
Record 1 contains too few data fields
Yes - by a query in Access
This is really strange - but it I added a field to my Query that was spaced - eg. If I used Client Name, instead of ClientName - Word would give me the "Record 1 contains too few data field" message and not let me use mail merge - I would still like to fix this problems - I have several table and a few querys that I would completely have to redo to make this work correnctly (without the spaces) does any of this make any sense? Thanks Keith Peter Jamieson wrote: What is the data source? (by "query", do you mean "Access Query" or something else?) Peter Jamieson "KingKaos" wrote in message ... I've got Office 2003 Pro - trying to merge a query into word - I've had not problems with it before (with other querys) but now - I keep getting this error message - I've loaded all the hotfix files and patches and attempted to follow one web site that had me change some of the registry items - but nothing works - does anyone know if there is any way around this - I can't even set up my mail merge doc with the query fields. Thanks Keith |
#4
|
|||
|
|||
Record 1 contains too few data fields
If you have a field in the Access query with the name Client Name as two
words, Word is seeing that as two fields when in fact the data for is containined in just one field. -- 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 "KingKaos" wrote in message ... Yes - by a query in Access This is really strange - but it I added a field to my Query that was spaced - eg. If I used Client Name, instead of ClientName - Word would give me the "Record 1 contains too few data field" message and not let me use mail merge - I would still like to fix this problems - I have several table and a few querys that I would completely have to redo to make this work correnctly (without the spaces) does any of this make any sense? Thanks Keith Peter Jamieson wrote: What is the data source? (by "query", do you mean "Access Query" or something else?) Peter Jamieson "KingKaos" wrote in message ... I've got Office 2003 Pro - trying to merge a query into word - I've had not problems with it before (with other querys) but now - I keep getting this error message - I've loaded all the hotfix files and patches and attempted to follow one web site that had me change some of the registry items - but nothing works - does anyone know if there is any way around this - I can't even set up my mail merge doc with the query fields. Thanks Keith |
#5
|
|||
|
|||
Record 1 contains too few data fields
Can you post the SQL version of the query here please?
Peter Jamieson "KingKaos" wrote in message ... Yes - by a query in Access This is really strange - but it I added a field to my Query that was spaced - eg. If I used Client Name, instead of ClientName - Word would give me the "Record 1 contains too few data field" message and not let me use mail merge - I would still like to fix this problems - I have several table and a few querys that I would completely have to redo to make this work correnctly (without the spaces) does any of this make any sense? Thanks Keith Peter Jamieson wrote: What is the data source? (by "query", do you mean "Access Query" or something else?) Peter Jamieson "KingKaos" wrote in message ... I've got Office 2003 Pro - trying to merge a query into word - I've had not problems with it before (with other querys) but now - I keep getting this error message - I've loaded all the hotfix files and patches and attempted to follow one web site that had me change some of the registry items - but nothing works - does anyone know if there is any way around this - I can't even set up my mail merge doc with the query fields. Thanks Keith |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fields inside footer -- Last record showing field instead of data | Benjamin Bryan | Mailmerge | 3 | October 26th, 2005 04:02 PM |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Repost: Record 1 contained too few data fields | HJ | Mailmerge | 0 | May 20th, 2005 01:27 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |