I have a query that returns [TheDate],[Number of Bookings] and [The Day] :
12/05/04    3    Wednesday
13/05/04    0    Thursday
and so on

I would like to capture time with hh:mm:ss only without a PM/AM designation.
When I create a custom date format specifying  hh:mm:ss with a 00:00:00
input mask
the system automatically fills in a AM/PM designation and converts my time

My code below will loop through all the records in the table, and when
the if statement is true it goes to the
***Me.ContainerNumberProductsTable = GETContainerNumber.Value*** bit
like should but it does not make the change/update in the table.  Any

I have a database that I need to connect with that resides on my personal
intranet server.  I'm on a different subnet than this server (running
through two different gateways).  When I try to open the database from my
laptop, I get the warning

I have created a purchase order database that has a PO form with PO
Details in the subform.  I need to assign each PO a job number and the
PO details subform also has a job number field (for easy of tracking
elsewhere).  I have a problem where if I change the job number on the

I need to Total the amounts for each Property ID in a table.
All the amounts are stored as positive in the database.
Based on a transaction code, the amount should be added or subtracted.
There are about 14 transaction codes, but here is an example:

I created a report with the wizard. Horazontal lines spanned 5 pages
so I made them smaller...to fit a single page.
Now I have 1 good page of my report followed by 4 blank pages and then
another page of my report followed by another 4 blank pages...on and

Does anyone know where I can find a sample database with a calendar where
activities can be added to any day on the calendar?
Alternatively, how would one create such a calendar?
Thanks for all help!

(warning - long post ahead)
I have been tasked with designing a database for my company which will
store trade information (it is a financial firm). It will need to
export this info into an excel file while converting some of the data

I've got a tabbed form with the 2nd tab containing a subform.  I'm
trying to avoid the need to use the mouse to set focus to the first
field on the subform.  I can use <CTRL><TAB> to open the 2nd tab, but
I can't get the first field to receive focus until I click in it.

I have a Access database application that sends email through Outlook.
A few years ago we started having a problem where it would ask for
each and every email being sent whether you want to give access to
your email addresses in outlook and then something about sending mail

I'm putting a lot of time and energy these days into making sure my code is
well strucutred, easy to read, and easy to maintain.  I find that it saves
vast amounts of time later to restructure the code during and right after
writing it, when the code design premise is well ...

What is the best (correct?) way to do:
  Me.txtCustID.SetFocus
   in the OnLoad or in the OnOpen or... of the form?

As you can see I have worked with my code and done some changes. Now
the code will execute, because of this, and because I took away some
code in the OnCurrent event that was probably causing a clash. It does
in fact copy the new Invoice number and the data from tblOrderDetails,

Using A2K.  I've developed a survey form with a number of questions
that have  6 possible responses each.  The possible values are 5
(Strongly Agree) down to zero (No Response).  I want to develop a
report that looks like this: