Hi.  Are there any good samples of AR databases on the
web?  I need to redesign what I have for AR including a
payments table and would like to have a reference.  Thanks.

I want to enter a booking from 10am to 2pm on let's say, the 17/3/05, for
say a camera (DC1),  but the camera may have already been booked from 9am to
3pm, 17/3/05. I can create a query that establishes the camera is already
booked at 9am and who to and display that result. But ...

I have an input for that has fields such as PatientName,
DoctorName, VisitDate, TestNumber, InvoiceNumber and
InvoiceDate, InvoicePaid, Amount, Type and three or four
more fields..   Right now this form is based on a query

I have a Date and a Date_End I want to know with me I do to calculate the
time of Date and of  Date_End in months and days.

Hi, Everyone,
I have a subform for the user to enter the details.  However, I found that
some user may enter the data without press Tab or Enter and select [Next]
Record.  (Esp why the user come back doing editing).  As a result, the data

I have a main form with 1 combo boxes  StudentID
Student ID comer from tbl_Roster  and the subform displays the records from
tbl_Objectives that match StudentID.
I now want to add a 2nd combo to the main form - year form tbl_Year.

In my form I have calculated a field to show years of service. It is
calculated as follow,
=DateDiff("d",[Hire Date],[Todays Date])
Formated:  yy"Y "mm"M "dd\D

How can I place a calculated value on a form into a tebles field?
I have a form that uses a collected check box and a collected by customer
check box, i then have code that checks the values of these check boxes and
determines a delivery charge value(we charge delivery both ways)

I have a list box for a finance program that shows all records and pertinent
information.  I want the form to pull up only those records in the list box
that are being selected in the combo box.  For example I have several records
tied to "MasterCard."  When the combo box pulls ...

I posted this before but did not get a response
I use the below command to open another database from
another opened database.  The problem is I get the error:
"You cannot open "db name" for exclusive use because

Is there a way to make the vertical scroll bar in a text box (whose data is
big enough to need a scroll bar) to always show, even if it doesn't have the
focus?
Thanks,

What can I do when I get the message there isn't enough memory to perform
this operation when I use the Find/Replace key to find a particular word in
my Access Database form.  I get to a certain record and then the above
message pops up and I cannot search any further.

I've created a database (small) that queries another database (huge)
based
on values looked up by the user.  The first database creates
a DAO recordset based on data in the second, and then loops through

I have a Main Form that has an Amount field in it and also a Subform with an
Amount Filed in it. The main form's amount is the total amount for an
invoice. The Subform amount breaking down the invoice amount to different
cost centers. I would like to be able to do one of two ...

i need a template, can anyone help?