I have set up a form which has a 'date on hire' and 'date off hire' field.  I
want to be able to say to the form, look at this record (hire no) if the date
of hire is blank, then calculate the no of weeks between now and the date on
hire and flag is 5 weeks or more.

I have just for fun developed 3 systems in ACCESS 2002
- Hushåll = keep track of all your incomes and expenses
- Liga = registration and statistics for Swedish Bowling series
- Korp = registration and statistics for Swedish Amateur Bowling

I would like to add a command button on my switchboard that will preview and
or print all 7 of my database reports as a group.  As it is now, I have to
select each report separately.  How do I do this?  Thanks for any help.

How do I locate and activate Label Wizard? I cant find it anywhere.

You can't get there from here. Or so it seems.
I got my DVD catalog and form working fine for display on the Jewel cases.
square box on one side, DVD round image cover on other.
The form isn't really the problem. For future reference I would like to search

I have developed a Visual Basic program that uses the Snapshot Viewer Control
(SNAPVIEW.OCX).  The data was exported from an Access report into a .snp
file.  I have two questions:
1)  I am using the PrintSnapshot method to print the reports.  Is the some

Actually i don't know how to set up a mail merge using my database?????

Hi group,
Access 2000 win xppro
I can create a command button that will open a file based on the data in a
textbox. The textbox displays 1234 and clicking on the button will open the

Hi, heres what I would like to do but am having trouble getting info
on it.
I have a database that records bookings for 5 rooms, my plan is to
keep the relevant table on my web host server so that i can check the

I would like to turn off all fields when a check box is checked so no more
data can be entered into a record.
Suggestions?
Thank you.

In a table I have a column with numbers from 1-1000. I need to sort them by
odds and evens. For example 1,3,5,7,9,11.....999 and after 999 the next
number should be 2,4,6,8,10....1000. Is it possible? and how?
Thanks

I am trying to design a db for technical analysis results.  i need to be able
to multiply the values in a regularly updated record and show the results in
a graph.  can anybody help me please?

We have a split database Access 2000 and one of the users has managed to add
a record displaying Chinese characters!
The problem is that the record cannot be deleted.
The other anomaly is that the fields displaying the chinese characters are

I have a table named 'invoices' with a field named 'invoice#'. I am creating
a form which a person fills out different fields. The form is named
'FInvoices'. One text box is named 'Invoicebox'. What I am needing to do is
when a number is entered, and when the focus to that text ...

I am taking a records and management course in college and have worked with
access, excel, powerpoint, and word. My instructor keeps wanting me to index
the database when im done with it and I really don't understand what she is
wanting. All information would be greatly ...