Here is a silly question.
Is there an easy way to enter a single search term in a text box and have
Access search every field (control, etc.) for matching results
"automagically" as the saying goes? Some sort of wildcard, maybe?

Array question:
I want to match an account number entered in a form to the same account
number in a transaction table by looping through the transaction table and
for every match (the number of matches can vary) extract the date and amount

I retrieve data from MS Access and fill Excel spreadsheet.
After data filled on the spreadseet, The border of spreadsheet does
not change accordingly.
For example, the spreadsheet has a bold border on the result area for

I have a form that gathers a job type.  If the job type is one category the
date format is mm/dd/yyyy but it is not format is m/yyyy.  
Code
if type_of_job.text = "TE" then

I'm not sure what's happening here, but a break is occuring with no
break point in sight.  I'm using Access 2003.  The database is used by
one person.  I was asked this morning to make a couple of cosmetic
changes to a spreadsheet which is the output of a macro.  I did so and

I have a form consist of several fields include 2 hiden fileds; Owner and
DateUpdate. Is there a way to change the DateUpdate and Owner to Now() and
Currentuser() respectively before moving to the next record if user is
editing the record?

I have a routine in a module that I use to pass and order number and set the
focus to a form, change the contents of a control, then fire its after
update event to update the form.  Normally I call the form and controls
specifically, but I want to change the form name to a ...

Hi All,
I can't seem to reset some the caption of some labels when the form closes
or unloads.  I have tried the following codes on both the form's Unloading
and Closing event but neither works:

I have a form which acquires info from the user, including a date.  I would
like to put another spot on the form, invisible to the user, which would be
two work days prior to that day.  later on i use this date in tables which
are auto-linked to the form.  i'm trying to use ...

Is it possible to require certain fields to be populated based on the choice
in a combo box?  
I have a combo box on a form that populates a field called [Reason] in a
table.  If the user chooses, for example, "Left Early" for the reason I want

Two years or so ago I saw an article that showed you how
to change all the Subdatasheet settings from Auto to None
at the same time. Does anybody know how to do that? I am
using 2003 at present.

I have three fields on a form named:
‘Status’ <combo box>
‘Resolved Date’ <linked to ‘Resolved Date’ in ‘Cases1’ table>
‘Closed Date’ < linked to ‘Closed Date’ in ‘Cases1’ table>

I'm looping through an ADO recordset and creating a text string using string
variables set from recordset values. My recordset is about 35 records.
Everything works fine until I get to record 15 where it crashes and I get the
error 13 type mismatch error and I'm completely at a ...

I am having a problem with a form setup. I imported an Excel worksheet
and created new forms. I cut and paste text from Excel worksheet because
import fields were not like. I am now trying to create a combo box for one
of the input forms, but I am afraid I will lose some data if I ...

I'm using this to Round Up.
Public Function UP(MyField)
   UP = Int(-100 * [MyField]) / -100
End Function