I have created a form to look up client records in two unrelated tables using
LName and FName fields. If a client is in both tables or only in the second
table, the records pop up after clicking the OK button twice. However, If the
client is only in the first table, after ...

How to execute some code when moving between records in an access 2000 form
without adding new buttons in the form and use the click event????
Thanks in advance
Moony

Is there a limit as to how many combo boxes you can have on a form?   I am
getting the error 'unable to open anymore databases'.   My form has MANY
combo boxes - all the data that is selected is data from maintenance forms
(tables) and I need their id's.

Hello;
I am using Access 2002 with XP.
In Excel you can add the current date into a cell by typing Control semi
colon.  Is there a similar (easy) way to add the current date info an Access

I have a combo box that pick up values from a query. I cannot figure out why
if you type a string in the combo box the maximum length is 50 characters.
The query find values in a table and the combo box store value in a field
that is 255 characters on the NotInList event. So if ...

HI and thanks for helping.
I would like to know if there is a possibility, that my (input)form is empty
each time i open it. Right now i can see the last entry.   I am new to MS
Access.

I have form with a sum on it, I need a way to lookup up a table with the
finale amount, ex- I have amount of $1009.56, this is to lookup a table 1009
and return the $241.00, I have done it in excel but now need it to work in
access, I though this would be the way but I'm getting ...

I have a list box that needs to be populated with a lot of data.  The data
are coming from a table with SQL script that returns the records. When I
tried my own code the application crushes and it displays memory failure
message. Can any suggest a good way to achieve this?

In my form I have a field that is 2 positions long is there a way to move to
the next field when the field is filled without having to press the enter,
tab or some key.  I would just like to have the person enter the two digits
and then be in the next field.  Thanks for any help, ...

hello and thanks for helping me.
I have a Text box in my form for Data Input to my table.
In on textbox i need only Yes or No.  How do i do that?  Thanks
Guenther Schmitt

I am using Access 2002 with XP and I am designing a Sales Tax database. I
have a created a form with a Combo Box. The Combo Box has 3 columns: City
Name, City Code, Sales Tax percentage and this data is pulled from a Tax
Table.

I have a combo box with 200 rows. I try to scroll with my mousewheel in
it but it does not work. Is it possible to scroll with the wheel in a
combo box?
Hannu

I have created a form which runs a query listing all suppliers in our
database, every 6 months we want to go through this list and remove or update
each supplier - is there a way to automatically schedule a msgbox to appear
on a certain date 6 months from now?

Hi there everybody,
First of all, thank you all, especially the MVPs!  I'm pretty new to
access with no formal programming training, but have very gratefully
lurked and used these newsgroups over the past few months to teach

I have a tab control on my form with only 3 pages of fields. Each time I
select the next record from the record selector, the entire page redraws
itself. Why does it do this and is there a way to prevent it so that the only
thing updating on the screen is the data within the ...