Recent content by DSquared65

I have a report that has one field in the return. The field is an Adobe Acrobat Document. When the PDF document is one page there is no problem, it opens great. When the PDF document is more than one page the report will not allow more than the first page to display, it is a one page report...

I have a database with several hundred PDF documents embedded in an OLE field in a table. Using a query to find a document or using a field in a form to display results is not an issue when there is one document in the result. With one document in the response the doc can be opened, viewed...

I have several forms that open in datasheet view. In this view the field with embedded PDF documents shows only the words "Adobe Acrobat Document". This is what I wanted to happen, so that part is good. The problem comes in when opening any one of the embedded documents. One document will...

I posted this on the query forum also as it crosses both I have a table with PDF documents embedded into one field. Using that query to drive a form the field on the form will show a thumbnail image. Doubleclicking on the image opens the document. This is a good thing. BUT if I close one...

If the idea is just to display the data from form1 into a field in form2 then just reference the field from form 1 into a text box in form2 In the text box in form2 type =[Forms]![AddPurchaseOrder]![RequisitionNumber] Whenever the form opens it will display the contents of the field from form1...

If I understand the question correctly, the simple answer is to create a form with all the optional fields, then use the OR criteria statements in the query using the inputs from the form.

I've been working with Access for close to 20 years and it never ceases to amaze me the things I don't know. And the things that I once did know that have been forgotten through lack of use. I live in the U.S. and work for a large corporation. The day I stop asking questions will be my last day...