I'm sure this has been answered, and I've looked but can't quite find
what I'm looking for.
I have
Path = "I:/voucher.txt"

I have a table of around 1000 rows; patient records. Each row is
individually defined by a Patient ID number which is my primary key.
I have made a simple form to display patient information for the
secretaries working in the office. I would like them to be able to

I'm thinking this is easy but can't get it.  I have a table with
following:
Table1
Date 1/1/2007

We have an Access 95 database which holds a lot of our customer data.
We are running the database in Access 2007 and in the main it's fine.
However the time has come to move on and we're trying to extract the
data from the .mdb file. When we open the database in Access 2007 all

I have been reading the posts regarding the CompactDatabase method and
would like to say Thanks to everyone, especially Mr.Steele. I have
taken his advice and make a backup from the Backend before compacting
and use his code

Is there a way to specify different field names in a temporary table
created using VBA? I just inherited a program and now the users want to
export results to Excel. The original programmer only provided printed
reports, so field names did not matter. The temp table is created using

Hey all,
Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.
Thanks!!

Is there an event that triggers as a form is loading?  I want to
display a "loading form" event as the form is loading since it tends to
take 20 second or so to open.
TIA

This is the first time I use a database program.  I am trying to build a
product database.  Each product will have an ID number, a description, and a
photograph.  I need the table to display the photographs of the items, so
that I can visually spot the item that I am looking for. ...

I have a column chart with two series:
1) Number Of Applications
2) Number of Completed Applications.
These are in a column format, so it looks like one bar, but colors

I have a large database (for me) containing about 23,000 records and I
need to add a single digit (the number 8) to all data currently in a
specific field.. This field contains numbers already that are 8
characters and I need to change them to nine by adding a #8 to the

I've got an access97 reporting mdb that pulls data (77,000 rows) from a
sql server table into a local table to run reports
if the local table is part of the reporting MDB, the insert statement
(16 fields) takes less than 30secs, but because of db-bloat, I moved

When I am linking tables from an Oracle database to an Access database
(ODBC
Data Sources) which Oracle driver must I choose?
I was informed to use "Oracle in OraClient10g_home"...and that I may

I have a simple requirement to turn a query results into a pivot table
The query results are:
EID            Name   Service
1               Terry    Books

i want to maintain a hidden column in datasheet.
Anybody can show the hidden column how drag column heading with mouse.
i want to prohibit the method from anybody.