I am new to Access and hopefully the answer to my question could be very
simple. Bascially, our clinic has a software program that creates aging files
in .dbf format. For example, Jun0.dbf, Jun30.dbf, Jun60.dbf, Jun90.dbf and
Jun120.dbf, that I import into Access, create one ...

How can I have a combo box list values based on the value selected in a
previous form field?  For example, I have a list of activities which could
grow to a large number, say 200.  I don't want the user to have to scroll
through all of them each time, so when they select the area ...

I have a combo box field that also people can input to - I would like the
info they input to be saved and included in the combo box in the next record -
is this possible?  and if so, how?

After people click the submit button on my form the form closes.  How do I
get Access to open the next, blank record (i.e. they submit form 3 and form 4
would then open) when they reopen the form the next time instead of going to
form 1?

I have been thinking a lot about Access and what it has meant to me over the
years, and how it has "evolved".  Not only Access but all Microsoft
Products.  Most of my experience is with Access so I will use it in an
analogy.  I don't want to offend anyone here who lives and breaths ...

Can someone tell me how to create a "zebra form" (?) based on a field value.
Thanks.
Paulo Ferreira

I am using the following code.  Everything works EXCEPT after th
message I put in the code, I get the system generated message: "Th
item you selected is not in the list - Please select...."  How do
eliminate that message??

I have a very long subform on a main form. My user wants to keep the focus on
the same field in this long form as he navigates back and forth between
records. By default, when he navigates to a different record, the focus goes
to the 1st field in the form header. It is a relatively ...

I would like to include an "IF" statement on a command
button so the user will be prompted if they click the
button to delete the record.  I would like to ask "Are you
sure you want to delete this record?" with a yes/no.  If

I have seen other posts addressing this same issue but I still cannot get it
to work.
I have a table with a list of approvers and their corresponding areas. The
combo box chooses the area and I want the approver to automatically appear in

i face the same problem like Susan L. after i look through the solution, i
still facing the same problem. i have create the primary key to all tables.
but it doesn't work

CAN anyone tell me how to display a status bar text message in code when
running a form?
Any help is highly appreciated.
Thank you.

I have a combo box - the user doesn't want to have to take her keys off the
keyboard to click the drop-down arrow. She wants to be able to just enter the
box & have it open & be able to use the arrow down keys to make her
selection.  Is there a way to do this?

I have a subform within a main form. When I try to put data into the subform
I get the error: "The LinkMasterFields property setting has produced this
error: 'The object doesn't contain the automation object
'Transactions_Utilized'.

I have a form with 4 subforms in my Tab Control.    Is there a way to not
show the first subform (AdditionalContacts)?  As when I view the mainform now
and I scroll down the 1st subform shows it's info.  I would rather have the
user click on the tab if they need to see that ...