I have a form called frmacq which has a sub for called
frmtbleacqdetailssubform on the subform I have a combo box where the user
types in an itemcode if the itemcode if the itemcode the user types in does
not exist I have setup a macro to display a message advising the user the

So I have been working on this form to try and calculate an age from a
birthdate.  Everything I have tried has not worked.  So I finally came
up with this formula and now it rounds everything up or down.  I need
it to round down and I can't figure out for anything.  The formula I

I've created several Queries with a paramter [Date]. In the criteria line of
this field, I put "Is Not Null And Between [Forms]![Reporting Dialog]!
[MonthBeginning] And [Forms]![Reporting Dialog]![MonthEnding]" so that it
will open a form called Reporting Dialog that already has the ...

This is my first post.  Thanks for all the good information everyone.
I have a question about using unregistered custom DLLs inside Access.  Is
this possible?
This all started in an effort to isolate the source code as I rolled the

I have a subform attached to a query which includes some variables defined
inside the query (i.e TotVAT: [Qty]*[Price]).
In my subform I have a boolean variable for VAT. When the checkbox is
checked, I want the value of VAT to be calculated. If not, VAT must be 0. To

I have what I think is an easy one, but yet the solution fails me.  I
have three textboxes, 1, 2, 3.  Textbox3 is set in the propteries as
visible = false.  The code I wrote is quite basic:
if textbox2.value < textbox1.value then

I use this code to email the salary report to my colleague,
   DoCmd.SendObject acReport, "salary", "HTML(*.html)",
Forms![main]![email], "", "", "Salary Record", "Please reply!!", False, ""
   DoCmd.GoToRecord acForm, "main", acNext, 1

I have a form with data concerning companies:
SELECT CompName, adress
FROM tblCompanies
I have a subform that shows all the employees of these companies:

I have a drop down list which I'd like to use to filter the records within
the form. The drop down list contains a list of managers who are responsible
for certain buildings.
I'd like to select a managers name, then the records shown within the form

I have a report "OpenPosReport" that uses a query "OpenPos":
I would like to send the report to a recipient from a field
"RequestorEmail" using Do.CmdSendObject.
I have sent reports using Access Macros before, but never using the

I need strategic advice re: my form design.
I am building a Contact form where users can enter basic contact information
for an Entity.
To make it easier to account for the fact that people have multiple email

I'm working with a table that looks like this:
model         category       level
----------     ------------     -------
model 1      category 1    A

I have the following behind a list box on a subform but it does not see to be working the vbNo section, if I select No the itemcode which the user typed in should be undone but nothing is happening any ideas anyone??
Private Sub itemcode_NotInList(NewData As String, Response As ...

One of the Controls on my "Purchase Order Form" is the "Total:" field.
It gets its data from a calculation coming from the "Purchase Order
Form_subform". My question is, how do I display the calculated result
from the form to the Table "LedgerEntries"? (Keep in mind that the text

Hi, is there a way to double click an email address in a contacts form
that opens up Outlook Web Access and fills in the email address?
Thanks,
Eric