Search results for query: *

DOA to the rescue!

Thank you! It works perfectly with DAO!

Thanks for helping with this crazy problem! Both queries work in Access, with or without the Attachments field. qryAgingClosed works in code, with or without the Attachments field. qryVolume works in code without the Attachments field, but fails in code with the Attachments field. It fails at...

Incredibly, in code, prior to that query failing, this query works in VBA (!) I have no idea why this would work while the earlier (and simpler) query fails! xlWB.Sheets("Aging").Select With tmpCmd For i = 1 To 2 .CommandText = "qryAgingClosed"...

Access 2010. The query runs in Access, but this VBA fails with the error "Invalid Operation run-time error -2147467259 (80004005)" if the final table field is an Attachment. It works otherwise. Attached is the Main table from which the query runs. It retrieves records from a Type of inspection...

I have split my data and attachments into 2 tables because my VBA code that runs queries fails when the Attachment field is in the data table [banghead] Unfortunately I can't get the Attachments to display on the form. I assume I need to use a subform, but I can't see the Attachment field in...