I use Access and have a table with books entered for our library. I
have another database with the ID number of each student.  I have a
third database which is called Book Status.  When a student takes out
a book, I scan the barcode of the book in and the barcode from the

what reference do i need to check to make this work?
Dim WSH As New WSHNetwork

Am I able to change the criterion in a query under program control?
I would like to use the same query in different circumstances and search by
different criterion based on different fields. Is this possible and, if so,
how would the code structure look?

I am a newbie to access, but have written in filemaker for years
now...finally deciding to make the change. Nedless to say, its very
different!. I have one major problem to get past.
I have a form with information from a contact table on it. In addition to

Helo, I have a report that has a text box with this formula as the Control
Source =Sum(Abs([Shift]=1)*[DT REGULAR]/[EMPLOYEE TIME]) it is giving me the
right percent but the decimal place is in the wrong spot. its goving me for
example (400.5%) instead of 40.05%. I se the text ...

I am more familiar with Filemaker, in that I could export my database records
into an excel document and match the fields.  Can't find that in Access or is
there a way to merge the information from two tables?

I have created a report called Labels.  How can I modify it so that the name
is on one line, the company on the next and so on?

I'm trying to figure out where I need to go to test my typing speed. Please
help!

When an asset is assigned to an employee, that employee's information is
filled out on the form.  When the asset is no longer assigned to an
employee, I would like to check a checkbox name Unassigned, which would
clear all the fields pertaining to the employee.

How, or what is the simplest method of backing up and restoring a back end
database file?  It must be done via an Access form, perferrably a one-button
click. One button to backup, one button to restore. (Backup location is not a
critical element at the moment, just the "how to".)

I have a table "current students" which lists all my current students
(Student Id, Name etc) and then I have another table "Staff" which lists the
names of staff (Staff Id, Staff name etc)
Now each member of staff is responsible for one or many students.

i have about 10 excel spread sheets some with 1000 contacts others up to 200.
If i want to create a generic database for them in acess would i put them
all into one table or should each spreadsheet have it's own table. Also they
all have the same fields in them except for which ...

Can anyone tell me is there a cheaper alternative to buying the "Visual
Studio 2005 Tools for MS Office Systems" @ around $1,400.00 AUD so I can put
my developed Access 2003 database on 15 PC's outside my company.
The PC's have not got Access 2003 on them, so the DB will run as a ...

I have an Unbound Text Box called "Find_SerialNo" for the user to enter the
Serial No of the equipment they want to find in the table. Because some
serial numbers are Numeric and Some Serial Numbers at Alpha numeric, I have
designated the Serial Number field in the Table to be a ...