I'm looking for input into my decision to switch to ADO and unbound
forms.  I get tired of having to block all of the ways a user can
unknowingly save a record, like using the PageUp, PageDown keys and the
scroll wheel on the mouse. Also, I think that as the database grows in

All,
I have not visited Access for a while, and I am drawing a blank on how
to search/sort a column of data (integer) for/on a particular bit
pattern. Actually, a SQL example would be great.

Hello and thank you in advance to anyone who can help.  I have searched
and cannot locate an answer to my problem...
My colleague has a database and queries what are built and running fine
for her (she uses Access 2002 and the DB is stored on the H: drive).  I

I have two tables
tblROVW
tblROMR
Both contain 2 identical fields; NUMBER CODE

Does the ! work with Date/Time fields. I have a fields that is set as a
Date/Time fields - Short Time and I want it to fill in from right to left as
Access claims it will. I tried the example that MS gives (the phone number)
and it works great, but when I try to use it in this ...

I am looking for help using recordset.  I currenty have a form which
uses recordset.add to add records to a table.  the form is designed to
add multiple records at once by auto incrementing.  It stores
information about T1's so when one T1 is added it adds 24 records one

I'm stumped and I'm hoping someone could help me figure out the best
way to track daily attendance for the next 6-4 months.
I have a list of 80 or so participants who should be attended training
on a daily basis and am tracking if they attended, have an unexcused

I'm formatting a report based on an existing controlled document.  The
document that I'm duplicating has a number of lines that the user fills our
manually, but the database version of this document will fill the fields
with data rather than the user hand writing entries.  The ...

For maintenance reasons I would like to split my DB in an Frontend and
a Backend. The frontend is an MDE. The backend contains all the tables.
Nothing special. But I will also have my reports in the backend or even
in a second backend database. I that case I can easily spread new

In Access 97, in the Form_Current routine of a form, I call another
routine that repopulates and recomputes everything. However, a SQL
Select statement that I initiate from DAO that refers to a function of
mine errors out, claiming that the function does not exist. However, if

Does anyone know of a problem - and the solution - about source safe not
recreating queries properly when creating a new db from source safe?  We had
one that was renamed a few times and it also has a HUGE where clause.  Every
time we build a new db for production, the query isn't ...

While adding data to a record set, I use something like
rst![Plot1] = some variable
rst![Plot2] = some variable
.....

I understand why I am getting this error, I just need to find a work
around for it.  Here is what I'm trying to do:  There is a textbox on
my form that OnClick will ask the user for a new value, I want to take
this value and update the textbox with this value.  I can't use the

Probably not the best way to do this, but I'd appreciate it if someone
could tell me why the following DOESN'T work;
I have a function (code below) which returns a string based upon a
supplied integer value.

   here is what I am trying to achieve. I have a memo field on a form which
users will need to add to as and when. I do not want them to be able to edit
information which already exists within this field.
My idea was to have the memo field locked on the form to stop edits.