I have an app currently in service which runs using the Access97
runtime. Each user has the runtimes installed on their local PC and
the db links to common datafiles on the server.
I have now been asked to expand this to allow use of the db by users

This is for a personal "fun" application I've been toying with for years
first in A97, now in A2003.  It's just for me and my friends who
aprticipate in a weird hobby to use.  My friends have A2000, but none
have A2003.

I have a problem of removing '/' in Access.  I have a field [RegNo]
with this record BD/02/1234.  I want to automatically remove the '/'
and save it in a new field record [StuPicture] for another purpose.
Presently this is done in Excel.  I am using Access 2000. Any Access

I currently have a form in MS Access that has certain combo boxes
which specify criteria in order to run a query based on that criteria.
I want to add to this, a calendar from which a user will be able to
click on a date, where the chosen date will then be used as the

I have rebuilt a govermental formular with a report by putting some 30
textboxes in the page header at the right places for printing. I want
to fill these textboxes with the data from a query, putting each item
of each record into the right textbox.

I would like to know how to turn off the annoying warning about macros
in a database.  
I maintain two databases on my home computer for my own use.  Now that
I am using Microsoft Access 2003, every time that I open either of

HelpBox is a textbox control on a form. When line #254 is processed,
the focus is on HelpBox. However, when line #254 executes, the
error saying 'can't move focus to ButtonG' is returned. I've tried
putting a DoEvents statement after line #253. The same error was

Hi, is there a way to integrate NT Authentication into an MS Access
front end, which uses table links to SQL Server 2000?
currently our frontend has 22 users, and uses full access SQL server
DSN links.

I need to copy the entire directory that my .mdb file is sitting in to another drive and
directory, and am having trouble with the syntax.
The following is intended to  copy the contents of the full directory the mdb is in into a
directory called: C:/pie

My boss is asking me to generate a column mapping report of all the
queries. Basically, we get our data from ORACLE. There's a queary that
create new table  from ORACLE tables. Then, there are reports and
queries that uses the new table.

Putting together a database for network equipment. I want to do one
simple thing and I can't figure it out. I want to make a form with a
Multiselect List box that has a bunch of switches in it. I want to be
able to select multiple switches in the List box. Then I want to have

I want to write a query where one of the two tables in it is variable and
its name is picked up from a text box control on an open form.  The query is
very simple and is only a select query with three fields, but the problem is
that one of its tables varies with the Calendar Year ...

I have a table with 4 fields.  Three are used for criteria.
I can get the DLookup to work with 1 criteria with the following but
can't get it to work with 2 or three.
NumofAppts = DLookup("[luNumofAppts]", "LookUpAppts", "[luNumofPeople]

I have a table that has a list of all orders placed in the last five
years. For simplicity the fields are Year, Customer number, Item
number, Quantity.
A customer may have bought 15 of item A three times through the year

I have 2 fields  called document & Revision which contains the titles for
the documents to be stored in the databse it gets filled up as the user
enters them and the revison numbers associated with them.
1.  What I need to do is to make sure that no duplicate entry is entered for