I have a filter form that I am using to filter a report in print
preview. On the form I have several list boxes for different
categories.  I first had combo boxes, but then I was asked if the user
could filter by more than one selection for a particular category. I

I have a database form which should contain numeric data in a currency
format. However in a few cases we receive a text response such as 90% of fund
instead of £1,234.56.
So i have had to change the field to text, however my users now have to

I have a table with two fields: [AssignedTo] and [Number]. The [Number] field
is full, [AssignedTo] is primarily empty. (I query where [AssignedTo] IsNull
to find available [Number].)
I have an unbound form with a combobox that will fill the [AssignedTo] field

monthly I schedule 6-8 people to work m-sat with various start and stop
times, by hand!  There has to be a calendar template to make this easier!  
Help! BB

I am making a form that is for personnel issues.  The field list for it is
completely different from the form.  How do I change that??

All,
   Is it possible to display alt text on a label on an Access form so that
when my users pass their curser over the label, the text displays (like alt
text on an html form?)

I have created a field in Table as Date_of_Birth and Age and the same has
been created in form also.
I am entering date of birth in Form as example 14/01/1986 and in Age in
Control Source as like this =DateDiff("yyyy",[Date_of_Birth],Date()). Now the

I'm making a database for a book store and I have created the invoice...
However, when I want to add a new record, i.e. make a new invoice for a
different customer, the old one gets lost, I have no idea how to make this
work

Have a form that works right now using a autonumber.
When the user enters the date then it generates a text string for the
primary object.
The primary field is not the autonumber field (indx) in the table is gets

How can I export the table name in a mdb to an excel file? Thanks.

i have to created dynamic List Box
Where one listbox is connected to table1
and  another listbox is connected to table2,table3,table4
if i select first value of table1 ...the second list box should be

Good Morning all,
I have been trying to create a sequence number with a unique last three
digits.  The number has a total of 14 digits.  I can concatenate the first 11
numbers with no problem but its the last three that I can't figure out.  The

I have a simple question thats about to drive me crazy.
I'm trying to get the content of a textbox to be displayed
on another form in a textbox, but I keep get this message
in the destination textbox #name?

Iam trying to do calcualtions in a report. The calcualtion i want to do
is same as on i have in excel, which is done in the Colour Bad filed (I
have text box in my report called txtcolband)
=IF(H5>=15,"Red",IF(H5>=10,"Red/Amber",IF(H5>=5,"Amber",IF(H5>=2.5,"Green",IF(H5>=0.01,"Blue" ...

I have created a field in Table as Date_of_Birth and Age and the same has
been created in form also.
I am entering date of birth in Form as example 14/01/1986 and in Age in
Control Source as like this =DateDiff("yyyy",[Date_of_Birth],Date()). Now the