I need some info on this or advice
How would you setup the frontend to look for a dbf over a simple network,
like a mapped drive or an ip address ?
We need to share a dbf from another pc on our local network that is not on a

I have an Access 97.  On one form, the user can scan or enter a number into a
control.  The KeyDown event (with keycode 13) is used to check (through an IF
statement) whether a function has returned True or False.  The function
itself does a lot of things like check for a valid ...

I am running Access 2002.
I regularly use a number of different databases for different clients, and
want to set up a seperate database from which I can open each individually,
regularly compact each database etc.

I have an Access database running on Windows XP which seems to have a
corrupted VBA environment, but I can't seem to get a handle on what's
gone wrong.  Any pointers would be appreciated.
The system has Office XP (2002) with Office SP3 installed running on a

In one of my forms, I have associates enter in a resolution and the form
calculates a currency value based on other info entered in.  What I am
looking for, is to have my form not allow a certain resolution to be selected
when the dollar amount is below a certain level in another ...

Scenario: I am using the code below to verify that particular fields in my
form are completed. This works fine but I want more. I have 2.5 questions
about this.
If IsNull(Field1) Or IsNull(Field2) Or IsNull(Field3) Or IsNull(Field4) Then

MS Access 2K, Windows XP
----------------------------
Hi All:
I have a form with a tab-control with multiple tab pages. On one of the

I have an access 97 application, I'm trying to turn the hourglass on when a
label's click event is fired.  I use the following code (DoCmd.Hourglass
True).  When in runtime it doesn't change the hourglass, if I debug and step
though the code the hourglass turns on.  Any ...

I'm using a single table with a primary key field Account_ no dupes, on a new
record in a form (Form name = "CaseData"), how can I get the message which
pops up after the record is complete that the Account_ you are your entering
is a duplicate, to come up after the field is ...

Hi;
I'm trying to update an MS Access database with the following code which is
in a Javascript portion of my code for this page created in FrontPage:
var sqlstr = "UPDATE UserInfo SET

an unbound contact form with an update command button, which is not updating
records in my contact table, when i select the contact name on the form it
shows the name with all  the  data (City, email, phone, floor, etc..)
but not updating,

I have to break down a string into some more convenient parts... but the
string should be cut where a <space> is
               If numLetters > fixedLen Then
                   strTemp = Left(strToComp, fixedLen)

Ive been able to create forms that has a menu which looks up values from one
field and displays the list of possible/closest matching entries.
However, i cant seem to create one which uses multiple attributes:
basically where i would have 4 different fields :

How would you do this:
You have a form that when loaded, the background colors of all the empty
controls (e.g. textboxes and comboboxes) are yellow (to alert the user that
they are empty).  After entering data into a control, it turns white (this I

Scenario: I am trying to create a multi-select list box that will add records
to one of my tables. I used the code created by Roger Carlson (suggested to
me by one of the helpful folk here). I changed the field and table references
in the code to fit my database.