ACCESS FEED: Re: [MS_AccessPros] "Insert into" query with an attachment field

Jumat, 20 Mei 2011

Re: [MS_AccessPros] "Insert into" query with an attachment field

John;
a couple of the reports gather data from more than one table and this was the format of the "template" that I am modifying
ie: build a table from all the tables used then use that table to populate the report. However I have found that if I use an embedded query on the report and not build an interim table it works fine.
So I probably bugged you all for no real reason, figured it out just before nite-nite and didn't withdraw my question. My bad. I am going to pull that pdf and stash it in my access need to know stuff.
Thanx
Walter

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Walter-
>
> One "feature" of multi-valued fields (Attachment data type is multi-valued) is
> that they cannot be used AT ALL in an INSERT query. Why are you loading report
> records into a table? Can you use a query that includes the Attachment field as
> the Record Source instead?
>
> It is possible to copy multi-valued fields in code, but it involves opening up a
> second Recordset on the "hidden" table in the multi-valued field.
>
> See:
>
> Manipulating Complex Data Types using DAO.pdf
>
> .. that I just uploaded to the Files / Articles_Excerpts section.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
> Sent: Friday, May 20, 2011 2:25 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] "Insert into" query with an attachment field
>
> Hello group,
> Back with one more thing, I have several queries that build reports and some
> have photos attached. when the query runs it builds the datasheet correctly but
> will not build the table used to make the report. I get a "an INSERT INTO query
> cannot contain a multi-valued field" As is an Attachment field. How do I make
> this work?
> We spent several messages back and forth a couple of months ago, about OLE
> fields because I could not get them to display at all in 2007/2010 (works fine
> in 2K)
> Walter Griffin
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>