To some of you experts, it may be small change… but, To me this problem is
complex and is beginning to hurt… I have tried various methods of doing
complex updates using mainly queries and a bit of form code, but just can’t
make the breakthrough required to bring it all together, ...

I have create access query named "ABC". And then I created a form and define
a variable named "work_field" and want to pass to query. But it doesn't work.
The following it my code:
dim work_field as string

Hello,
I need to disable two of my text boxes based on the value of another.
I want to use something like this in the After Update Property for my text
box named Branch Code but am sure I am not using the correct

I have a form 22 inches long. In the header - I have text lines (that look
like hyperlinks) that take the user to one of the subforms on the page.
However, when clicked - all cursor goes to the first record of the subform -
and all the headings are scrolled up so they can't be ...

I had this problem...
My database is about recording cash inflows in a dormitel (Dormitory + Hotel,
hehe). All my tables has a field for Staff, to record the staff that was in
charge of inputting a certain information in the database. What I want is to

I'm really having problems with how to put up my booking system for a
dormitel.
There are 27 rooms in total...and the rooms are classified as either a hotel
or a dorm. There are three types of rooms-Double Twin, Double Matrimonial and

I am looking for VBA code that will work with Access 2003 to enable
dragging and dropping a file/folder name from Windows XP Explorer into
an Access form's text box.  This is a common functionality that most
Windows programs have, so I'm suprised it's not easier to implement in

Is there a way to use a combo box to choose which subform you want to
display?
Basically, I have different information from different queries that I
want a user to be able to display based on their choice from a combo

I was just doing a little cleanup on a single table using a query. The
following has be stuck. SQL#1 and SQL#2 brings up the SISItemCode that
I want but #3 doesn't. Could anyone suggest why?
The code is identical except for the WHERE clause.

Hi FormsCoders:
The code below returns error 490 on this line:
"K:\Customer Service\Quote\Backup\Data\2008\myFile & .txt"
The file opens if I step through the code using the actual file name

All right.  Thanks to Klatuu, i've got a form that opens up a hidden form,
which gets the user's name (which i found needs to exist before applying a
query to it, duh).  The data entry form opens up, filtering all of the
records based on this user name, and another query which ...

I am designing a database to hold employee training information in Microsoft
Access 2003.
I have a form (frmTraining) with a subform (frmTI).  The main form shows the
employee's information: Name, number, shift, etc.  The subform shows all of

I am creating a database and need some input forms.  I have clients who live
in various different types of housing.  I would like to have a dropdown list
to select the type of housing and then display the correct subform with the
right fields for the specified type.  This is a ...

I am looking for some help to finish my access report.
In my access database I got table called tblJobs. There are some
fields - Date, Job, Priority etc. Each Job will have a Priority and it
can be 'A' or 'B' or 'C'. In my date wise report I wanted to summaries

Hi everyone;
First of all, thanks in advance for your time and help. Here is the drill;
On my WL table, one customer can be registered only once per day. But there
are times, we have same customer more than once on paper. What I would like