Search results for query: *

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...

I had a file restored from back up by my systems group... when I try to run it I get the following message... The Microsoft database engine could not find the object MSysDb. Make sure the object exists and that you spell the name correctly.... Can anyone shed some light here?

Good idea...its for a business analyst programmer spot.

Is there a source on the web where I can get a list of interview questions for Access. We are interviewing a prospect next week, and I would like to look at some sample questions. Thanks

I have inherited a form that someone in my organization created in InfoPath. There are several places where the user enters an account id and account name. I want to change that so that once they enter the account id, they can click a button and have a query run and get that name. I did it...

I have been thrust into the InfoPath/Sharepoint world. I will be using InfoPath 2003 for now. For right now, they want me to re-do all our business forms from .PDF to InfoPath. If you design a form first without binding it to a database, is it difficult to go back and try to bind it at a later...