I have a database that I am using as a Time clock where employees can
clock in and out. Is there  a way to make it so that when they clock
out a form would open displaying their work day hour by hour with combo
boxes next to each hour that they could select what task they did for

I am running an Access 97 (Office 97 Pro) application on an
older computer, and am about to be upgraded so my computer,
and installed software, matches the rest of the office
That means going to MS Office 2003 Professional, so my A97

In Startup I have all Menus Off.  I created a ShortcutMenu which has
the "InsertObject" option as its only selection. I open a form that has
New/Edit/Del buttons. This form has a linked OLE Picture Control. When
I am in EDIT mode I can Right-Click on the Picture Control and the

I Have a text file that I want to delete using the On Click event of a forms
button, the text file is along the following path:
C:\1.txt
I have managed to create the text file from Access using DoCmd.OutputTo, I

I'm relatively new when using Access so bear with me.
I have an Excel file with 4 spreadsheets, each with multiple columns
Tbl.Schools
SchoolName

Greetings All,
Hope you can help me out here.  I'm trying to import from Excel but the
default date in Excel is in this format:  12/2/2005  12:49:49 AM  (for
example).

I have users on different computers getting the error message "could
not update;currently locked" when trying to leave identical fields
after making a change on the same form but on different records.
MS Access 2002 MDB, front-end split from data. Data stored on network

I am getting the averages of a field LT. When I run it in the query
designer:
SELECT tbl_LTandWait.EngModule, Avg(tbl_LTandWait.LT) AS AvgOfLT,
Avg(tbl_LTandWait.LT_Mfg) AS AvgOfLT_Mfg

Computer Industry Workers May Face Cancer Risks
http://www.studyandjobs.com/Comp_worker_cancer.html
or visit
http://www.studyandjobs.com/Cancer.html

Guys,
this is my problem:-
I have records which are linked by two fields on a left inner join
(there may be 0,1 or more records in the right hand table)

Hi All.  I think that if I explain the database layout first it may be
easier to ask my question.
Table Name    Field Name
Test        TestCode

Ciao a tutti
devo distribuire un'applicazionde fatta in accessxp con relativo runtime.
Nei computer dove è presente Office 2000 completo quando un utente tenta di
aprire i propri db fatti con access2000, questi vengono aperti con il

I have a date field which when i enter the date in some places, works
fine, however, when trying to enter dates on certain rows i get the
message:
"The value you entered isn't valid for this field. For example you

I have written an application (CW.mde) with a seperate data (Data.mda)
file. My Data tables are linked to CW.
I want my user to be able to re-link the data.mda when they change
location/path of the data.mda. Hence, I have an button with the

I have a table with MgmtRevID and MgmtRevDate
I have another table that requires the MgmtRevID to be selected each time a
record is created.
Access 97 database