Hi, please help me with my project. I Want to make a dropdown menu listed
below:
Product Code >>makes a dropdown menu
(whenever one is selected, it will provide a product description)

On an order details subform sfrOrderDetails I have a combo box
cboSetRebateID. The combo box works fine, but I want it to have (and display)
a default value (which can then be overridden if necessary) that is picked up
from a different control, txtDefaultRebateID on the same form ...

I have set up a basic dbase containing a list of subscribers to a news letter.
I have the date of subscription as a field name and would like to set up a
reminder one month before the subscription is up (working on a 12 month basis)
.  I would also like to email the subscribers ...

I recently converted an Access 97 Application to Access 2003.
When I use this forms combo box, I get the f ollowing error in a dialog box
"RUN TIME ERROR 2501 the save action was cancelled",
when I update the combo box for which the beforeUpdate Code is below, the

What is the best of way of inputting new data into an exiting table. I have
setup a form that links to the table with a save record command button, but
each time I open the form, it displays the data from the first record in the
table. I want all of the fields to be blank - I ...

Hi!  I am new at Access 2003.  I would like to create a Combo or List Box
(that's my first question - which do I want?) called "Custody" where the
choices would be "Mom". "Dad", "Both", "Grandparent", or "Other".  However,
only the "M", "D", "B", "G", or "O".would get stored in ...

I have some experience with SQL Server but not with Access and I find the
two to feel very different so I apologize for my ignorance.
I have a table called Pastry and I made a form with a bunch of drop down
lists that are populated by queries from that table. I want the user to go ...

Another one ...
I have three date fields in a table and I want to return an
Approved/Unapproved in another field within the table based on these dates.
I'm not really sure how to do this.

I have a membership database which records date of joining.
I need to mention anniversaries in a weekly bulletin and therefore
need to sort my report by day and month.
How do I do that? I do not know where to start.

What are they really for?
Why not use one long form with different sections?
What is the advantage of using a sub form?

I'm needing a query to display all records created After a certian Time on a
specific DATE.
The table contains fields for the Date and Time seperately.
Currently, it will prompt the user for the date, then the time.

I am building a new database (and am a new Access user) and I have run into a
problem. I am working with part numbers. One list is my company's numbers,
three other lists are competitors numbers. I need to use my database to look
up part numbers using any of these numbers. My ...

This drives me crazy.  I have a new table and I like the form already done
for the other table, so I copy the form and rename it to match the tabel and
then go to design view and even though I try to delink the form from the old
table, Access 07 just blitely matches all changes ...

Need to find a factor in a table. Example: Find the distance between towns
like in a road map book.

Each record in my database is numbered consecutively using the autonumber
feature. I needed to delete one of the files, however, and now want to assign
the deleted number to another record. Is this possible?