I have a question regarding the drop down menus and coding.  I want the code
to be able to tell if the user has entered anything into one of many drop
down menus.  If the user has and has clicked on the comand button it should
run a particular section of code.  I know I probibaly ...

Hi. I have code that I can't get to work so I had the query wizard write it
for me in sql and now I'm trying to convert it to code.
Here's the wizard sql:
UPDATE tblAuctionDonors SET tblAuctionDonors.DateSent = Date()

I need to create a very simple calculator that opens on a KeyPress event, and
that "imports" the current value of a field.
After I calculate upon it, I need to send back the result to the same field.
Anyone?

I want to use this in my Not in List Event of a combo box that is on a Edit
form, so that if a user attempts to enter a product that is not on the list,
they will be warned that it is not a product currently in the database and
then will be asked if they want to add it.  I don't ...

I should preface this be saying I am a relative beginner in Access, so small
words are helpful.  I have linked an Access table to an Excel spreadsheet
where we enter information on how our homebuyers found out about our
communities.  We track 14 different criteria at 13 ...

I have a form based on a query that pulls customer information.  I would like
the users to be able to type a phone number in the phone number text box ,
hit ENTER and have the form go to that record.
Right now they have to click filter by form, type in the number and then

I am using a continuous form to enter a Path&FileName. My form cannot be wide
enough to display the file names with long paths so I have written code to
extract the file name from the path and display the file name in the
ToolTipText.

Hi. Sorry if this post is a bit long…
I seem to have run into a bug in Access 2002, in the SizeToFit method
(important to the front end of the application I am developing). I initially
assumed the bug was in my application, but after I created a separate

I am a true beginner and there maybe a simple solution for my problem. I am
running a form using a query and trying to include sort of a filter on the
open event but in the "Where", but it appears that my query is running
without reviewing checking the "Where". Please see my ...

If I have a series of code I'd like to execute every time a form changes
records (whether by tabbing through to the next/new record or by using the
nav buttons). Can anyone point me to what event I'd use to get this code to
execute at the proper times?

I currently have a database integrated with MapPoint .
It works great for users who have MapPoint installed on their pc's.
But those who don't,  get the error message that a module is missing.
Question:

In Microsoft Access 2000, one of the subforms appears fine when entering the
first record.  However, after the first record is entered and the "Add new"
button is clicked again, the subform is blank.  What could be causing this?

Our database has 3 fields that track amounts within each record. Then we have
a fourth field that we put the average of the 3 amount fields in. We have to
calculate the average by hand on a calculator, then input it. Is there a way
we can have access calculate the average within ...

I have two syncronized drop boxes, one where you select the product type (ie
hard drive or motherboard), and another where you select the actual product
(ie 120BG or Asus), and when you select the actual product i want it to
display the price of it.  the price and product name ...

I have a subform which is in datasheet view showing a,b,c,d,e fields I want
to bring the e to front so that it should now show e,a,b,c,d. This subform is
based on a query I have changed the sequence in query but it dosent change in
subform becoz the last field was picked later ...