I have a report which basically shows fees charged and fees paid. I use an
OnFormat of the detail to highlight the situation where FeesPaid <
FeesCharged. I also have a field "CountUnderpaid" which I increment. This
value is printed at the end of the report.

I have Access 2000 and 97 installed. I would like to add 2007 without
affecting current operation of 2000 and 97. Is this possible with a
custom install?
Regards,

I have created this query:
INSERT INTO versamenti2 ( codice_iscrizione, riferimento )
SELECT codice_iscrizione, rif
FROM iscrizioni;

I already read a lot of earlier questions on this subject, but the
answers just didn't seem to help in my case. I hope one of you can
help me out:
Several persons will have access to my database. When they have added

Did this once before long ago but forgot how.
I remember that if you place a BMP file with the same name as your
access application in the root directory that picture file will be
displayed as the program loads.

I have no experience with SQL server and have been asked the following
questions:
If the owner of a split Access database (frontend/backend) wants to
upsize to SQL server can it be as simple as migrating the backend

Here's an example of what I'd like to do.  I have four tables which
contain the same items as below.  I would like to combine the four
tables so that the companies in all four tables show up with the
corresponding quantities next to them (including those that do not

I have a form that returns 100 items.  All of the items have have a
different value in their Category field.
EXAMPLE:
----------------

How on access can you set access controls to your users?
If they log in with one username and password they can just read
information and if they log in with another username and password they
can read and write?

I've been trying to figure out how can I see the text in caps in my
report, but til now, nothing works.
Does anyone knows how can I makes the text in caps in my report?
Your help will be very appreciated,

Hello, Dears Access intusiast ;]
I.m have one database, but i dont known how can conect 2 ussers same
time and update in same time...
Thanks wery lot,

Dear Access Group:
This is the most basic and most embarrassing of questions, but I
cannot find where to change the data type of a text field that I have
in Access 2003 to a number field.  I've searched high and low through

I have a user asking if I could put in a code that will open a register
drawer. My understanding is the receipt printer will normally send the code
the cash drawer. Is there a vba function that someone can share that will
open a drawer without printing? Or does it depend on the ...

I do not get why sometimes code does not run "in order".
I open another form within an open form:
DoCmd.openform "frmReservationEntry", , , "[ResieNum] = " & varResID
The form opens with the correct reservation record.  I close that form

I am using MS-Access2000. I can't seem to set the default values for Logical
type fields.  I start with
   Dim dbsTmp As Object  ' I think it's DAO.Database
   Set dbsTmp = DBEngine.OpenDatabase(CurrentProject.path & "\data_be.mdb")