I'm using Access 2003 and have a form that has both text and memo fields.  
The text fields have character limitations.  I've tried a couple of variants
that I've found on the subject (see below) , but I get a control not found
error on the "caption" control.  There was ...

I have 2 fields plus a image in the my form's "Detail" section.
My Question:
How do I get the form to change the image path, based on some criteria (ie
one of the 2 field's value) for THAT RECORD ONLY?

Is there any way to force single and double datatypes to display 2 decimals
even if there is only one? or none?
for ex:
1    => 1.00

There is a date field (mm/dd/yyyy) that the users fill in with their desired
due date for the tasks. What I need to accomplish is this:
1.  Have a flag field (check box) checked when the due date is passed...
2.  Change the flag color to red (jumps at you when you open the record)

My form has a combobox (cmbLE) and a listbox (lstREffDate).  The listbox is
populated with a single item via a query based on the combobox selection.  I
need to pass the resulting listbox item to other queries.  So I select the
item using VBA (see below).  On the form, the item ...

I need to be able to choose between addresses for my clients based on a date
range such as Nov 1 - Feb 28. I understand how to do it for the full date,
but then I have to redo the filters for each year or I get bogus results.  Is
there a way to consider only the month and day ...

2 combo boxes. the second lists items dependent on the choice in the first box.
When both combo boxes are populated and the selection in the first box is
changed, I need to blank out the selection in the second box.
Question, how do I detect when the seelction in the first box has ...

I have a form to display records based on a flag in database table.
All users should be able to view records flagged 'N' and
only those users with some particular userid should be able to view
records flagged 'Y'.

I need to generate a replicationID value in code (not in a table). In MS
T-SQL I can use the NEWID() function to get something like
"0323E5D3-D54D-4842-86B0-47CE25D0EFDB"
How can I do this in MS Access 2k?

I am attempting to edit the criteria of a query via code. The user will
provide the name of the query to edit. The query will contain a common
field called CtyNum. On command button click event I want to change the
criteria for the CtyNum field to reference a textbox value on my ...

I need to sort a huge mailing list by zip code and then be able to see how
many entries there are for each zip code.  Can Excel do this for me?

I have written code for a cancel button that I have on my form - when I close
VB and press the cancel button I receive the error message "Module Not Found"
Here is the code that i have for the cancel button
Private Sub cmdCancel_Click()

Scenario.
Initially I had a form with 23 combo boxes.
Based on a suggestion, I decided to have one combo box and listbox.
This way I can populate the listbox with values based on my combo box

I have a query on the fly already that works perfect.  I can select
what i want to sort and it works great.  Here is the problem.  The
master table that stores my information is for company contacts.  Each
contact has up to 20 tags.  I need my tag filter to search in all 20

I have got a very simple piece of code which runs on the "On Click" event of
a command button.  Here it is:
Private Sub Yes_proceed_combut_Click()
x = MsgBox("We are obliged to advise you that Anchorman is authorised and