My question is how to filter a access column with the
next task: I want to have listed all fields from a column
that have in their fields (The field is a text field)
a "*" asterix. Also the criteria is that field contains

I created a database in Access 97 to print barcoded labels.  (I plan on converting it to Access XP as soon as all systems in the company are upgraded.)  I used the barcode fonts that came with the printer (Datamax) to print Code 39 barcodes.  I now need to add the 2-D barcode and ...

We have several clinics and we take patient appointments
from a central location. I have created a database with
a main form and users input the patient appoint date and
time in one section of it. There is a hyperlink button to

Does anyone know if it is possible to create a subform on
a form such that the ONE TO MANY relationship checks on
two sets of related fields.eg where you have families
with children and the father is the related link and

For Tony Toews (or anyone else who can help)...
I've just deployed my front-end MDE using the Auto FE Updater.  It worked fine for me (the developer, using Access 2002), however the users are getting an error message that "Access 2002 and Access 2003 were not found on this system" ...

Is there a way to password protect a table?  I protected
the form using an event procedure... but I would like to
protect the table too.

I have several tables that use Autonumber as the PK
ContractNum Table
Autonumber PK
ContractNum

I have 2 tables in my Access 2000 database which I gave
a "Hidden" attribute so taht users would not tample with
them. Now, I want to edit these tables, but I can't seem
to make these hidden tables visible. What to do?

A friend of mine runs a business that sells panoramic pictures. A number of
galleries/shops stock these pictures on a sale or return basis. My friend
requires a system that will track the items that a gallery should have in
stock together with what they have sold. i.e. each month ...

I am working on an educational database where there
is "base" course information in a table. Another table
holds semester-specific information, which can either be
pulled from the base table or can be entered manually if

how do i get a table to become editable when it is alreay
a read only table?

I have a linked table that has a field from three other tables.  
The tables are:
Mag:  MagID (PK), Title
Month:  MonthID (PK), Month

I was trying to compact my dbase and went on auto pilot and clicked the compact button again while it was in the middle of compacting the first time.  I can't get the dbase to compact now.  It gets to a certain point and seems to stall at a certain point.  I have tried to copy ...

Just new to access and asp and would like to know if an idea I have would
work.
What I'd like to do is set up a sign in / password / one week to access
time.

Access 2002.  I want to renumber a key (field) in one
table that is related to a key in another table.  That is,
I want to renumber the key in my primary table and have
the change made in the table to which it is related.  How