I'm using the following code to set the report name of a snapshot file
on save and it works perfectly.
*************************
Private Sub cmd_save_report_Click()

I can use dlookup to a search for 1 item in a record, but how would you
compare a second item to the same record?
I used
If DLookup("date1", "repairlog", "date1 = #" & Me!dateset1 & "#") Then

I have multiple tables and I want fields on each to be filled by a single box
on the form.
This is for an animal shelter.  1 table is surrender information
1 table is mailing list.

I am trying to build a data entry form for my associates to use but I want to
have a check box function that is tied to our corporate TERMS and CONDITIONS
that will lock all record sources unless the user Checks the box in
agreement.  What would be the best way to go about this?

I have a form with two textboxes. I want to be able to copy and paste
the text in the first textbox to the the second textbox  by using a
command button which is placed on the same form. Is this possible?
Any help is very much appreciated

I have created a collection as a staging area. I would like to sort the
collection. Is there a way to sort the collection>
Thank you,
--------------------------------------------

I've never understood the exact distinction between the
use of "." versus "!" in object references. E.g., Me.Fieldname
versus Me!Fieldname. Can anyone point me to a tutorial
that explains the difference? VBA HELP returns nothing

How do I I.D. or color code a file folder?

I have a simple text box that might not always be big enough to display all
of it's data.  What I'd like to do is use the ControlTip text to display all
the data in the text box.  This isn't hard to do by using the Mouse move
event to set the ControlTip text to the desired value, ...

Hi to all,
I am encountering a very strange problem  and I need to fix it.
I am using the Access auto wizard to insert a command button on a form to
open a form ans show a specific recordset. after it is done with matching

I have a main form with a subform.  I want to open another form when an item
is selected from the combo box on the subform.  The new form looks up and
displays a record based on the combo box selection in the subform (i.e the
combo box displays product descriptions, but the ...

The followingcode works fine:
MsgBox Me![test unterformular].Form.AUFPOSID & "show the aufposid"
ct = Nz(DCount("*", "serial_number", "[aufpposid]= 15205"), 0)
MsgBox ct & "record count"

I am having trouble with the code to gray out fields if my total is less than
$5000.  The graying out part works, but for some reason the number doesn't.  
I've tried it a dozen different ways.  Also, would I place this in On
current, On Open or what?  The field is a calculated ...

      Thanx for a positive help.
I am building a Form based on some queries. There are
prices displayed in 'textboxes' of the form.These take
theior value from a query.

Access 2000, Win2000
I have created a HTML help file through Windows HTML Help Workshop.
How can I call it from Access to open a specific topic?
The HTML Help documentation, is for C language. Trying to translate it for