I am trying to look up a "CWA Number" from tblLabourTransaction using a
unique Reference Number as criteria. "txtAssRefNumber" is an unbound object
where the user enters the reference number to be searched.  
In other words, the user enters the reference number, triggers the event ...

I'm a new Access developer working on my first application.  I have a form
with a command button on it, and when I click on the button, it opens a
second form , setting a WHERE clause and passing OpenArgs to it.  This part
is working.  The second form displays multiple records, ...

I have an Access 2002 database that has a form which contains a subform.  The
subform has two dropdown lists.  The second dropdown list's values will
depend on the selection in the first dropdown list (list one wil lhave a
choice of 'Service' or 'Product'; list two will contain ...

Hello,  I have a list box with fields [empID] and [VisitID] and a query which
uses these two criteria to extract data from a table listing all the visits
an employee is responsible for.  I can and have used the double click event
on list boxes to open a form tied to a query using ...

I need to find the lowest values of a set of dates, I tried using
MinOfList()
Function MinOfList(ParamArray varValues()) As Variant
   Dim i As Integer        'Loop controller.

I have a small pop-up form with a Combo box on it.
This Combo box is based on a totals query and its purpose is to put values
from 2 columns of the combo into two text boxes on the same form. (Later
these text boxes will be used as parameters for a Report based on another

Basically..
I have a text box which is the search data (a part number) & a button that
says start the search (using the info in the text field)
I have a whole bunch of records, and because of my companies semi-adoption

I have a subform, where the user enters the account and the amount. The
amount can be distributed the several jobs. So with the third tab I want the
move the the job number field on the second subform..
How can I do that?

I have a form with a submit button. This button currently writes the form
data to a table, now i want to add the functionality to email a short
message that ticket #xxx was created where the ticket# comes from the form.
Could someone help me get this done? I can send a table but i ...

I'm attempting to assign an image path to an image control, as below:
       imgImage.Picture = Recordset!ImagePath
I keep getting the error "The setting for this property is too long."  At
first, I was using a very long filename, but the error persists even when I

I am develooping an audit trail script in VB for an Access 97 application. Is
there a visual basic 6.0 script that can determine if a table field is a
primary key? I wish to capture the unique primary key for each record that  
is viewed/updated/created. Here is a snippet of  how ...

On a form ( ID field  hidden) I wish to have the second field (ie Ingredient
Name) check and see if it already exists. If it does then display the record
for editing. If not then continue to fill out form. I've tried various things
but fairly new so a few clues would be great! ...

I'm using Access 2002.  How can I check the status of my printer?
Must I use API, if so how?  Or can I use the Printers Collection. and
once again if so how?
Thanks

I would like to startup a MsgBox in Access code, such that, it can display
three option buttons, e.g. Yes, No, and Other.  Is it possible?  If so, how
do I setup the MsgBox and parse the three options?

I have a form that contains a subform displayed in datasheet view. I want to
be able to change several column headings of the subform depending on values
selected by the user on the main form. The column headings appear to be
coming from the .Name property of each object in the ...