I have a calculated field qoh = sum(Units*type) in my main form. I have
combobox on my mainform which has the ID and Itemno. When i click the Itemno
the corresponding values are displayed in the childform. I am able to receive
or issue that item and the QOH gets calculated.

We have an application which, by storing the paths and filenames in a table,
can cause them to be displayed in image boxes on various forms.  While most
of the photo files we receive are.jpg's, some are .pdf's.  Image boxes will
accept a broad range of formats but, evidently, not  ...

I have a list of multiple check boxes on a form, how do I make to where only
one check box can be checked?

I need code to close a form "frmName" (if it exists) in the current db.
Similar to:
  IsObject(CurrentDb.FormDefs("frmName"))
-Brad

I have a form that has a combo box, which has the list of project names in
the Project table and when the user chooses one of them, the fields that are
related to the project gets populated.
The problem is that it was working fine until couple of days ago, and the

A piece of code that has been working OK for some time has suddenly fallen
over with a Type Mismatch error.  The line in question is :
Set rs = CurrentDb.OpenRecordset(strTableName, dbOpenDynaset)
I resolved the issue by removing the "Dim rs as Recordset" declaration and

I have a unbound text field. I want to add a find button that when the
user clicks, take the value typed in the unbound text field and
searches all my forms. When it locates this unique ID in one of the
forms, it opens up the form and displays that specific record.

I am trying to code a submit button on my form that will export the data
entered and then send it in email format. Any suggestions would help.

Can I load a web browser in a for using the 'Application.FollowHyperlink'
command. I have looked at the help page for this command, but can't see any
syntax that suggest using a form.

I would require some inputs and direction as to how to proceed.
I have 3 tables tblprojects, tblitems, tbltransactions
tblprojects : ProjectID,pno,pname,pselected
(pselected - yes / no ) checkbox

Kinda like Suspicious SQL but this is DELETE...
DeleteSql = "DELETE * FROM tblPay IN '" & C:\RED\Reddy.mdb & "' " & _
"WHERE     (((tblPay.PayNameID)=[Forms]![frmBSCouponNames]![TxtID]));"
DoCmd.RunSQL (DeleteSql)

I'm not so expert in coding, but I try to find this question in newgroup but
i cant find it. I use the code below but it didn't work, it only uncheck the
first checkbox only, i want to make it uncheck all the checkbox while the
form load, thanks for the help.

I have two main forms (one used by supervisors & the other used by machine
operators). From both of those forms I open a subform which allows me to
input data for query sort paramaters & generate a report. That all works.
What I would like to do is utilize the OnClose Event of the ...

I have report that I need to have the number of pages counted and then the
number placed in a text box on a form.  I am able to do this using the below
code in the report.  The problem is first the report has be previewed or
printed before it performs this operation.  

When using a form I wish to call up the record of an instrument by it's asset
number - which is a unique identifier and, thus, my record key - from a combo
box.  Once I scan in this asset number (it's barcoded onto an instrument), I
wish to AUTO FILL into this form the following ...