Using 2003.  I've got a simple 1:M relationship for employees and
classifications.  A classification can be assigned to many employees/an
employee can only have one classification.  I created a form for adding
employees/classifications.  The classification can be left blank if not

When using OutputTo with a query, the 'File name' window in the 'Output To'
dialog gets populated with the name of the query by default.  This makes the
exported file self-describing if the query is named on the fly.
The benefit is consistent file naming, and users don't have to ...

I have the following which works okay...
Dim arrayTable As Variant
Dim varTable As Variant
arrayTable = Array("SG", "Oakland", "Los Angeles", "Server")

Kind of...
A new customer has just called and asked if I could achieve the following:
A front end screen with four buttons:
Button 1 launches an Access DB

I need to define a field so that when a lowercase letter is put in the
field it turns to an uppercase letter. What would the expression for
the field be? My field name is site_id.

I'm having trouble with links and hyperlinks in MS Access 2003 - any
help would be great!
Question 1!
The "insert hyperlink" icon opens a browser window, allows the user to

I need to produce a report based on a query.
Cost is a calculated field and its value is dependent  on another field, in
the query, called Session.
There are 5 different Session codes each generating  a different Cost.

I have created a data base that is linked to contacts in personA's
outlook contacts, I need personB and PersonC to be able to also edit
the data base which include a dropdown for personA's contacts, but when
PersonB & C go into the database with there login(i.e from there pc,

I have the following which works okay...
Dim arrayTable As Variant
Dim varTable As Variant
arrayTable = Array("SG", "Oakland", "Los Angeles", "Server")

Anyone encountered that? Am using PCL5e printer.

In Access97 I have a form setup as a continuous form several of the
bound controls have calculations that are done in the 'after update'
event via VBA code and all works fine.
My problem/question is if a user needs to go back to a previous line to

Does anyone know how to setup a defaul survey in form "Survey response Entry"
of AT YOUR SURVEY  (Duane Hookom). I have tried to put " [cboSrvID].ItemData
(0)" on default but it seem doesn't work well.
Very big thank!!

I use the Now expression to use the date and time of my sustem. I want
that info to add itself to my table. How do I do that?

We have a payroll application that runs with MS Access. It is comprised
of several different database files and one ms access mdb file for each
client. This means there can be from 10-1000 different MDB files. We
have a web application that we designed to do various things with this

I have an MS Access 2000 form whose fields I need to read and
write from VBA. The fields are data-bound, using a query that has
been defined and saved in my Access database. The query uses
local data only (no external references.)