Hello, I have a form in datasheet view, these records are filtered to display
only the records (personnel) that pertain to a particular department. These
filtered records have a Check box, indicating if the personnel is available
or not.

I have a form based upon a table.
In the table I created a field: E_mail (hyperlink)
When I open a previuously created form, the related field shows the e-mail
adress as blue, underlined characters.

Help!
I have written a database that uses one table whichcontains details
for each pupil at each school and one table that shows a list of the
schools and their unique identifier.  At the moment, I have one report

Hi to everybody,
I am using Access 2003 and I would like to create a fully expanded datasheet
form. The default datasheet forms with no records yet, only display one blank
line for the new record to be entered, and after data entry a new blank line

I'm trying to make a form that has two combo-boxes.  One displays the field
list from my table, and the other is supposed to requery to show only values
from that field.  However, I can't figure out what code to use.
I want it to be something such as:

By "indirect interactive sorting" I mean a situation when a form's
field shows values of one DB column, but is sorted using values of
another column. I believe this is a typical requirement when dealing
with ordinal categorical concepts (such as named ranks, months, days

I am starting to work with Access 07 SP1 on Vista and trying to figure out
the right way to set the TempVars in an On_Click event.   I followed what the
current help says where:
Dim myWorld As String

Hi, stupid question time but how do I determine if a field has focus as there
doesn't seem to be a focus property for fields?
What I want to do is this:
If me.txtEnterCode {doesn't have focus} then

I'm creating a document imaging part of the MS Access database that is
linked to MySql database via ODBC. I was hoping to have one or more tables
that will house images within MySql and then serve them back to MS Access app
per request. I'm using ActiveX from

This is a split database where each user has their own copy of the front end.
I have a need to do the following:
Create a local copy of the structure of a linked table, empty of data.
Move (read then delete) a single record from the linked table into the local

Is it possible to get a count of the records in a table without opening a
recordset? Thanks.

Trying to display  date and time in the following format:
Sunday, April 20 2008 - 2:38 AM
Not sure what the format should be.
Not sure if I should use a label and use the OnTimer.

I have a form containing a command button. When this button is clicked, I
display a popup form which collects some information that is written to a
table.
When the close button on the popup form is clicked, I return to the original

i have 2 tables that are in a one to one relationship. the main table is the
product table with a ProductID and a ProductTypeID. these 2 fields are the
primary key on the tblProductList. i have another set of tables that stores
the configuration of each type of product. the other ...

I have a timesheet form in which I have the date name and other headings such
as layout and sawing on it. It is a continuous form. What I am looking to do
is that as I am working in the text box I want the label above to highlight
so I know that I am in the correct field.