I have a form that includes a tab control. I want to check that the total in
a control on page 3 of the tab control agrees with the total of another
control on page 2 when the form is closed. I have the following code in the
Before Update event of the total on page 3

I have two tables: Institutions and Banks. Banks are a type of
Institution and the primary key of Institutions shows up a foreign key
in Banks.
I want to create an AddBank form which allows the user to enter data

Help,
Need a button on main form  to simulate clicking of a hyperlink field on the
subform
Button name is open the hyperlink field is FilenamePath

The more I learn, the more I trouble I get into...
I have a table ATTENDANCE_HDR that has a one to many ralationship with table
TESTRESULTS. PK on ATTENDANCE_HDR is event_dat,event_id,location_id and on
TESTRESULTS it is event_dat,event_id,location_id, and student_id. I have

I have a close button that runs docmd.close.
I also have the form close (X) option enabled.
The form is bound.  When I type something into the form and press the close
button, the one I created, the form closes with no issue.  When I use the

Hi, I am trying to output a report from MS Access to PDF. Below are my
codes but i want the pdf file name to be strFileName but its not giving
me the file name that i want as a default.
Can someone tell me what i am doing wrong?

Can someone tell me how to add a calendar to a comboBox that appears when
user clicks on a the drop down arrow.  Thank you,  Edward Keith

Has anyone found a way to have a button on a form allowing a simple way to
insert a hyperlink in a field?
I am looking to have a form of all documents for an asset i.e. receipt,
manual, purchase order.

I have a field called “Markup” which exists in the table “ItemDetail”.  The
default value is 1.25.  Users access this and can make changes to it in a
subform called “BidLineItem subform2”.  They can either change the value in
each record in that subform, or change the value by ...

is it possible to nest IIf statements?
should this code work?
=IIF([sales])<=500,([sales])*.0375,IIF([sales])>500 and
([sales]),=1000,([sales])*.055,iif([sales])>1500,([sales])*.075,([sales])*.10)

I'm trying to use the code below to set the Modal property of all forms in
an Access 2002 database to "No."
The code compiles, and runs completely through both loops, and the
Debug.Print frm.Modal command confirms that as the code is running, the

I have a field which has age as 4 years 8 months, how will I know the age in
dd/mm/yyyy
any help will be appreciated
thanks

I have two databases:
db1.mdb and db2.mdb
in my first db i have a form with a tabcontrol
in my first db i have also a reference to the second db, the db2

I am using the following SQL statement to combine the data from 2 fields
Select [company id], [company name] from [company table]
UNION
Select [company id], [old name] from [history table]

Is it possible to check for the character * in strings? Im currently using
this but it doesnt seem to be working. I tried 2 approaches so far but both
doesnt seem to be working. Whats the correct way of coding it?
If (InStr(1, Me.NominalValue, Asc("*"), vbBinaryCompare) > 0) Then  ...