It's my first database, and I have a query that shows me the quantity,
material, length, width and thicknesses of parts, and I'm using these
figures to do some arithmetic on a report to show me how many board
feet of lumber to buy (expression is as follows):

We have an Access 2K application that uses multiple forms.  We
currently hardcode the release number in a label on each form but this
gets tedious to do each time there's a new release.  I thought it would
be easy to put the new release number in one spot (a table) and have

    when I execute the code below I get the usual access message:
SECURITY WARNING----------------------------------
Opening "<filepath & name.mdb>"
The file may not be safe if it contains code that was intended

Again I'm sure this question has been answered somewhere but no luck
from the search results. If someone can point me in the right direction
that would be cool.
I'm trying to build a query where by the user checks what columns they

I have very big problem and I can't continue my Work on my project
until i solve it.
Here is the situation:
TblCalculations

I`m an Access newbie and could use some help here. I`ve made a query
and it works fine. Now I want the query to display the value for a
field only if the value is > 0. I`ve tried inserting

I have a question about a subform as shown at
http://aap.dyndns.org/access.jpg
The problem is, when i select a radio button in the subform, all rows
are getting selected the same radio button. So when I click 'Nee' they

?dcount("[OwnerFName]","qryOwnrsDueITSwMissingAddr")
when run in the immediate window return a number greater
than the number of rows that display when the saved query
is run - opening in the database window?

I have frmVehicleEntryForm and on it is frmAddnlOwnrListSubForm.
The subform is unbound and lists records in a table, allowing the
user to change values in CheckMark controls on the subform as
desired.

I am running an append query using query by example (but included equivalent
SQL code). The query counts the number of bookings and appends this number
to bookings to Tbl_Weekly
INSERT INTO Tbl_Weekly ( NoofBooks, StartDate, EndDate )

I develop my application on my desktop which has Access 2002 (default file
format of A2K).  My client uses A2K so I have installed A2K on my laptop.
Recently when developing in A2002 my front end reached about 22 MB in size.
Even after multiple compacts the size only goes down to ...

Hi,
I have a form with a list box that shows the contents of a table and
managed to create an add record button with the wizard.
(DoCmd.GoToRecord , , acNewRec)

Is there any performance advantage to calling out the SourceDB in a query as
opposed to using the table attachments in a database?
Thanks!

There is no mouseover event for the subform control.  How could I
trigger an event when the mouse is over a subform?

Hope someone can help here,  I'm trying to modify the following code to use
an automation object so I don't have deal with CRAPPY REFERENCES!  The
reason being is that this will be going on a number of machines that have
different email programs.  This is not going to be a ...