I have a number of databases in MS Access 97. Some tables in these
databases are linked to ODBC tables in Oracle9/10. We would like to
change the user name and password on the Oracle tables so each
database in MS Access linking to the tables in Oracle will need to be

Hello Newsgroup,
at the moment I am coding an archive database for a bank. Every folder
has an own number, following the sheme
x-x-xxx-yyyy

Could anyone link me to info on this:
I have to print-out an access DB.
Some of the fields have a few characters in them, and some fields in
the same record could have a small paragraph of text in them. It's a

I have a form with 5 buttons, each of them executing code and showing a
different report. I would like to add a 6th button 'total' that opens all 5
reports in a row (next report opens when other is closed).
Should I move the code from the 5 buttons into functions so that I can ...

Table:
Date                  EmplID           Shift             RevHrs
PayHrs
7/15/07                12345              012            7:01               8:

I have a database in a .adp file.  If I work on it using Access 2003
it will crash when I am changing a form or report.  If I go to a
backup and recreate the same series of changes it will crash
everytime.  If I do those same changes in Acess 2007 it's fine.

I have a table with Employees names and dates with 2 sets of  times (Pay
Hours and Revenue Hours). I would like to do a weekly comparison of these
times by listing each day and the 2 set of times under it in 2 separate
fields. this wouod be an ongoing weekly report.

Dears,
I have a table with four main fields (item, price, in_date, out_date),
where in_date and out_date declares the time when the item came to
stock .................

Please Help for InputBox ?
InputBox.InputMask = "*********"
Please for Help
Thanks all.

I believe I am looking for some form of Join Query, but my
understanding of Access logic and my logic do not yet click entirely….
I have a table of ocean buoy data, taken every hour over many days
(hopefully a whole year if it doesn’t slow things down too much):

What is Sharepoint, and should I care?

I'm trying to stop users deleting an existing value in a field. If
they go to an existing record and hit delete, I want to give an error
message and reverse the change. The BeforeUpdate event is firing and
they get the error message. But when they click "OK", the change is

I have a situation where a user needs to clone an existing BE database
(stored on a server) to his local machine.  Assume the followings...
User goes into the database FE which has linked BE.  BE is stroed on a
server.

Does anyone know whether it is possible to roll back MS Access
database without loosing any data? Or can a roll back be undone (kinda
odd).
Any comment would be appreciated.

Good morning everyone,
I have a railway equipment database that producess an Access  printable
report following a successful search.  I have a menu that Prints or Closes
the Report. The menu it is not on the report but in a separate menu bar and