I am currently doing a project and once of the criteria that I must include
is a "find button for users to select the records to update based on user
entered criteria". I find the description a little vague but I'm thinking
that they want me to click on a name (in my example it ...

i would like to create an array of commandbutton ( for example 20
commandbutons)   in a form with VBA . How i do it

Hi,
I am trying to use a subform for entering order details, the master form
(sales order)
has 5 control boxes, (account index, sales order Number, order date,

I've designed a form that contains some unbound controls (text box). The
controls are populated from the vba code (using sql). When I export the
information (“OfficeLinks" button), of the form, to excel, it’s displayed in
a single row. Is there any way to break this row?

Have a text box that I use to display a log of activity after it is finished.
At the end of the processing, I set the text box to the value of a string
variable, and set focus on the text box control.  
Problem:  When I do this, (1) all of the text is highlighted and (2) the

Can anyone tell me whether it is possible to apply more than one search
character to the Instr function.  To give an example of what I mean, I want
to find either an 'A' or a '2'.  Can this be done in the one instr
statement.

Is there a method for opening this dialog window using programming code
within an Access DB?  I have a form that I want to allow a user to open this
dialog window to permit users to build a query.  If there is a better way of
accomplishing something like this, I am open to that also ...

I get this warning with a long file name that ends with line:825 breakiinto
the debugger?  If I say Yes it closes outlook if I say no I can go on with
what ever I am doing.
How do I get rid of the warning?

I can't think any more at the moment, can any one tell me how i can generate
the following report please
I have a table with StudentID, StudentName, StudentSurname,.......
I have another table ParentID, ParentName, ParentSurname,.......

Trying to export a query to excel and am getting an error (Compile Error:
Expected Expression).  Can anyone pinpoint the problem
Private Sub CmdRunExcel_Click()
DoCmd.TransferSpreadsheet(acExport,acSpreadsheetTypeExcel9,"QryExportPriority", "C:\Documents and ...

I have what I believe is a simple problem but have not figured it out.
I have a main form and subform. I need to restrict the number of records on
the subform to a maximum of 3. The relationship between the Main Form and
Subform is through a field called DMIID. I set an Add Record ...

I've tried either Access builtin dateTime picker and Lebans', the first
being unflexible, the latter (IMHO) not so reliable and not so usable,
cause:
- not working properly in all conditions (hungs if used in modal windows or

I have a form that I am building programmatically with a group of
command buttons. and some labels. I have set the Command Buttons to
have no TabStop, but the first one on the form always has the Focus. I
don't want anything on the form to really have Focus. Can I do this? I

My question is: I have a form (form1) which has a field that is a look up
wizard to another form (form2). Table normalization has dictated what
information is in each form. When the user is filling out form1 it is very
useful to see the info from form2. For this reason I put a ...

I need help using this.  My current code is:
   Dim str As String
   CommonDialog3.ShowOpen
   imgquest.Picture = CommonDialog3.FileName