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

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

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.

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?

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

I am using a calendar control on one of my forms. It defaults to the current date...however in this application I would like it to default to date-1.... But I am not sure where to set it, as it always displays current date.... Any ideas.

Is there a way to select ALL in a listbox. Show ALL and then process all the items in the listbox. I thought I saw this in some Access book... Any ideas.

I am loading a listbox via a recordset loop and an Additem. What's happening is the Amount field is spilling over to several lines in the listbox. It looks like this... JAC First NY Company $14 137 965.73 where the value should read like this....$14,137,965.73 I've enclosed the code I...

How can you disable the edit button on the toolbar for a form. I can't seem to remember.... Thx

I have inherited an InfoPath form that is not bound to a table or database. The users have a text box where they enter the account ID, and they enter the account name. I tried to build a look up for them so they don't have to enter the account name. I receive the following error on this...

When I run my app, its going into debug mode. I cleared the breakpoints and re-booted but it still goes into debug, Whats going on, I never saw this before.

I am interested in learning what Sharepoint is all about and how it can help in my organization. Thanks