I know that I am not an idiot and I have done it before, but I can't remember
and it is driving me crazy!!  I have a subform where I am trying to make a
combo box that looks up something from another table.  It has 4 columns to
it, ID, first name, last name and rate.  How in the ...

I have a procedure to set the RecordSource of a form in the AfterUpdate
event of a ComboBox.  Using the Change event of the came Combobox I want the
AfterUpdate event to run when the user hits the delete key to clear the
ComboBox value.  Here is the method.  I moved the code to a ...

I'm new to access  -  sorry, will you help ?
I want to exclude a form field from the SQL query, if it is left blank.
I do NOT want to set the field as 'Required' ,  just ignore it as a filter,
in case it left blank.

when i am using access 2002, by default my system would not filtered the
records. But today using the 2007, by default my order form will be filtered.
How do i unfiltered them by default?
Thanks

I would like to add a field in a form to type in the first 3 letters of a
name and display the information for that name,.
Thanks
Charles

I normally use access like VB and use unbound forms, however I am in a
situation where it would be real quick and dirty to create a bound form for
my application.  I need someone to explain something to me.  I don't
understand the use of the command button for saving a record ...

I have created a link from one form to a specific record on another using the
following macro;
Action: Open Form
Where Condition: [ID]=[Forms]![Newspaper Query]![ID]

I need help with the following issue.
In the form, i have a listbox whose row source made up of two different
tables.
In one of the field i set it up as follows

I have a user input form which opens in in dialog mode in the AfterUpdate
event of a control.  The user's selection sets the value of an option field
and the form's visible property to false.  When the code resumes to evaluate
the response, I'm getting the error "Microsoft Access ...

I am a newer user of Access and inherited a database from a person no longer
with the company.
I am using a form to input invoice amounts into an invoice table.  The form
uses a parameter query to ask for invoice number.  When the form opens, I

I have downloaded and installed Chaos Pro and when I go to the e-mail I
recieved for a form, The message I get states that the computer needs to
search the internet to find the program that is needed to down load form?
I have been having this problem for a while.

Hi I have a case select code on my listbox. The listbox is called
ReportID, I have an event procedure on dbl click. But when I dbl click
the selection nothing happens. I have 2 columes of information that is
shown in the list box, column 1 has report name, column 2 has report

I have a form which is tied to a table.  To get to the form the user does a
look-up.  Once on the form the user can edit the fields on the table.  I
would like the only option the user has then to be to save and close.  Right
now, if they tab around they will eventually move to a ...

I was hoping someone could help me.  Today I opened one of my forms that my
department uses on a  daily basis and there seems to be some glitch with it.
I have a lookup from one of my tables in my form.  Today when I try to type
in it, the primary key column is gone.  It is a combo ...

I created my form in the wizard, but can not figure out how to make the
background a color instead of the set background. Is it possible to change
this? I am using 2000.