Hello there, I'm using Access 2000 on windows xp
Is there a way to
1) Table: Cancel the default value for number (I never want to default to zero
2) Form: printing to set it to default on "Select record

Have a form based on a query to calculate an expiration date.  WarrantyMonths is a number field.  InvoiceDate is a date field.  I’ve written the following expression to the query
ExpiresDate: IIf(IsNull(VehicleServiceDetails!WarrantyMonths),"",DateAdd("m",[WarrantyMonths] ...

What is the advantages of using a option group over a
combo box?  My example is this:  I have clients with
vision loss.  I want to record their main cause of vision
loss.  Should I use a combo box that has the different

I have recently purchased a book ("Using Microsoft Access
2000" by Roger Jennings), and have begun studying it, but
it is a big book, and if possible I would like to get
something on track fairly soon.

Hi al
I am developing a client management database and I have several command buttons set to open word. What I need is for the buttons to open word directly to the specific word document template that relates to each command button. Any help in figuring out how do this would be ...

How would you delete all the info in the same column going down? In excess you can highlight down the colum and just hit delete, how would you do that in access 97, without..arrowdown, delete, arrowdown delete ect..fingers get tired after doing 1000 some odd cells..

trying to get my head around one particular problem ....
in access2k a form for entering order details - with a subform for
seperate lines of the same order. how do i make each new line start at
say 1 and autonumber itself when another new line is created but then on

Error accessing file.  Network connection May have been
lost.  
PLEASE help me!  Is there a solution so that this error
will go away?

I have a form that is working well for continous improvement ideas i
our department.  Is there a way to generate an email or othe
notification to the supervisor letting him know when a new record ha
been added?  This would be useful as there are sometimes several day

I have a table that is the item master (code,desc,desc2,)
Then I have a table that's a list of ingredients (code, rm#,
desc,desc2,amount,units).
On a form the user enters a code and a batch size. The query brings up the

I am new to access. I have created a set of tables and a query. Very basic stuff and it all works fine.
I would like to progress to where the user (someone other than me) types in the criteria of the query and then the query selects the matches and returns only the matches that ...

I thought I would be able to create Mailing Labels in Access, but I don't see it anywhere.  Could someone please help me?  Thanks for your time and help.
Michele

I've been good and done some of my own research & found out how to set this
up (reference to MS Kb Article 325234.
However! Whilst it works beautifully in Excel, I can't get it to work in
Word (which is the example that the guys from MS give!)

I need to hide some fields on a form when a selection is made from a combo box.  I defined the If statement to run from the Change Event.  The fields do hide when you pick the combo box selection to hide, but when you come back to the record the fields aren't hidden any more. It ...

I have a form which displays records and has custom
navigation command buttons on it.  I would like the 'Next'
button to disappear when I get to the end of a record set
and before I get the standard warning message.  How can I