Create Table with empty OLE Object

[TOPSie]

I am creating some small tables from my main database which will be passed to a separate application running on a tablet computer.
I have found the following simple code works for all my requirements except one:

wOrderInvoice = "tblOrdHead" & strTabletId
DoCmd.RunSQL "SELECT qryKEFDOrdHead.* INTO [" & wOrderInvoice & "]  FROM qryKEFDOrdHead;"
DoCmd.CopyObject "N:\DB4Tablet.mdb", wOrderInvoice, acTable, wOrderInvoice

The query is

SELECT DISTINCT tblTempOrders.InvoiceNumber, tblTempOrders.CustomerName, tblTempOrders.Vehicle, DSum("outstanding","qryCustomerAccountBalance","Customerid=" & [CustomerID]) AS OutstandingBalance, getCDec(0) AS InvoiceTotal, 0 AS OrderStatus, getCDec(0) AS PaymentCash, getCDec(0) AS PaymentCheque, getCDec(0) AS PaymentCard, cdate(0) AS RecDate, getdriver() AS Driver, "" AS CusNotes, "" AS Signature, "" AS signedname
FROM tblTempOrders
GROUP BY tblTempOrders.InvoiceNumber, tblTempOrders.CustomerName, tblTempOrders.Vehicle, tblTempOrders.CustomerID;

Many of the fields are blank as they will be filled in by the tablet application.
The problem field is Signature - which is curently declared as empty Short Text
The Signature field needs to be declared as an (emoty) OLE object as the tablet will be used to collect a drawing of a signature.

So the question I have is how to replace the current -- "" AS Signature -- in this query to create an empty OLE Object??

[Gicu]

I don't think you can, you should leave the Signature field out of the first query then use an Alter Table statement to add it once you have the table. See this link (towards the bottom) for help:
https://microsoft.public.vb.general....e-in-ms-access

https://learn.microsoft.com/en-us/of...oft-access-sql

Cheers,

[TOPSie]

THANK YOU - worked like a charm :-)

[Gicu]