Hello All!!,
I need some programming help. I have a address search form I have created,
in the header section there are 4 text boxes that include the street
number, direction, street name, and street type, and search button.

Ive been able to create forms that has a menu which looks up values from one
field and displays the list of possible/closest matching entries.
However, i cant seem to create one which uses multiple attributes:
basically where i would have 4 different fields :

Does anyone know how to stop the security warning popup
when starting an access db?  I cant change the security
level setting because I am using run time access but is
there another way?

This works fine for finding the balance of my GL account but I want the
records that are out of balance.  When I put <> 0 into the criteria of
curBalance it promps for curDebitTot instead of running the SQL.
SELECT tblGL.strBatch, tblGL.dtmDate, Sum(tblGL.curCredit) AS ...

I have the following code:
*******************************************
Private Sub cmd_save_report_Click()
On Error GoTo Err_cmd_save_report_Click

Hello, all,
Can anyone show me an example of code that would allow me to print to a
specific printer? I use the button wizard to generate a button that will
print the report, and I see in VB help that I can refer to certain printers

I have created a form with these 5 fields Txtdate, txtname, txtaddress,
txtphone and txtfax. When I enter these fields I want to save it back to the
table i've created called members which have the same names as the field
names on the form. This is what I have done so far

Say I Have A form with three fields,
ID  Date  Status
and in the OnCurrent procedure I have
If Me.Status = "Done" Then

I would like to set the Caption value of form to include a variable from
the form.  The variable name is "full_name".  I would like the Caption
to be:
Application for Employment - "full_name"

I want to make a tab on a tabed form bold (or stand out in another
way) if a field on that page meets certain criteria
Any guidance would be greatly appreciated
Thanks in advance

I am looking for a tool in Access that will allow a user to search for a
file by drive, folder, then filename.  This control would be similar to the
controls that can be built in VB using the DriveList, DirList, and FileList
controls, to create a browser for file system objects.  I ...

does anyone know how i can create a function to select a primary keyID in a
table that cross references or "look up" an item in a deferent column and
returns the primary key value in my form

I am using OutputTo to export data to a series of spreadsheets.  But it is
slow and frequently just causes Access 2002 to crash.
I would prefer to use TransferSpreadsheet because it is much faster and
appears to be more stable.  BUT, it puts those apostrophes in front of text

I have a Form "JobFormA" and a Subform in it "JobFormB"
At certain situation arises (not always) that I have to move to each field
"Status" of the subform and set its value to "Posted". there are sometime 50
records in the subform and some time only few.

I am forced to use Access 97 and do not have access to
conditional formatting. I am using a continous form and
want negative values to be red and positive to be black.
Can I place my code (If xxx < 0 then xxx.forcolor=vbred