Recent content by colezpapa

I'm getting a syntax error on this sql code.... can anyone see what I am doing incorrectly.. StringSQL = "SELECT Doc_Account.Account_ID,Doc_Account.SubmitDate, Doc_Account.CompleteDate,Doc_Account.Status, Doc_Account.AccountName, Lookup_TypeOfWOrk.TypeOfWork_Desc StringSQL = StringSQL & " FROM...

thank you....thank you

How can I loop thru a listbox and display the contents of column(1). Dim item As Integer Dim x As String For Each item In Me.list_FieldsFrom.ItemsSelected index = Me.list_FieldsFrom.ItemData(item) MsgBox Me.list_FieldsFrom.Column(1)...

I have an adhoc query where they select a value from a combobox. Is there a way to select ALL. They want the ability to select all the items in the list. How would I link that to the query that get built.

I am trying to retrieve an embedded document that is stored in an OLE field. Its primarily a word doc. I am using an unbound recordset. How do I get the value into the OLEBound field on the form. Does anyone have a code sample. THank you.

I'm having trouble with this. Does anyone know the magic trick. I am using an unbound recordset for the form. I have a button with this code behind it... But how do I bind the OLE field in the table to the OLEBound391 control on the form? Me.OLEBound391.Visible = True Me.OLEBound391.Verb =...

I am storing a word doc and a PDF doc in an OLE field. I have an unbound form and I would like the user to clik a button to view the document on file. What do I have to do to get the document to load. I created a bound object frame OLEBound391....and am OLE field in a table named DOCUMENT. How...

I am storing a document in an OLE Object field named "DOCUMENT". I can see the document by clicking on that field with the table open....Now, I would like the same behavior on a form, typically when I have the account record, I would like to click a button and see the document.... How would I go...

Thanks for the info.... I saved a document to the table, creating an OLE object field. How can I automate opening up the document.... I can see it by right clicking -->then clicking on document open.... Is there a way to do that in code?

Well, this has come back. I built a way to link a document to the database. However, they (users) want to store the document in the database because of security concerns. They are uncomfortable with storing the docs in a folder where it can be seen, They tell me its only 1 doc per account...

Sorry I meant EXCEL macro....

I am trying to automate a process which has an excel macro as part of the process. The issue is the macro prompts for enabling macros or disable macros -- so its sitting there waiting for user input. How can I default this to "enable macros" or click the enable button.

yep, you are correct. Thats what I am going to do as I have a routine in another system that I can use.

My users of one of the access databases I support would like to store 1 pdf/word document for each account record in the database. First...how would I even go about doing this.

Someone in my organization created an Infopath form. That person has left the company. I have been left with supporting his work....When I try to open the Infopath form, I receive the following message. INSUFFICIENT SECURITY PRIVILEDGE. THE FORM CANNOT BE OPENED BECAUSE IT REQUESTS DOMAIN...