I am not a programmer but I have had to learn to wrote simple code to
calculate an amount due based upon entries in several fields.  It works but
now I'm concerned about the need for the same code to work in all queries and
reports that utilize those fields and the resulting ...

Is it possible to code a command button that is like the find/replace button
but with out the "replace"?  Basically, I want the user to click on the
button and have it prompt to enter the ID# of the record.  I created the
find/replace command button through the wizard, however I ...

I have a single form for entering and editing contacts, in which I have a
search subform.  
The subform is continuous, and has a search box at the top which, when
either the last name, company name, or phone number are entered, it filters

I'm sure I'm just tired, but I can't get this.
I have a table, "sale_information"
containing field "sale_dateID" as number
and "sale_current" as Yes/No

I'm storing a date in a text field.  I want to insert it into a date field.  
What is the proper syntaxt?

System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAM¬S
dbParams, Object& executeResult)
I have an application that is in production and being used by many
people.  I received a support email a couple of days ago, and I have

I'm hoping I can even explain my problem!
I have a table of SubTasks and a table of ESLOCS.  I have a query
qryLatest_SubTasks (based on the latest SubTask date) and a query
qryLatest_ESLOCS (based on the latest date the ESLOCS were entered).  The

am trying to clarify the subform 's status....
If I change the MainForm (already open) to another existing record - its
related subform will go to a related existing record.  I can force the
subform to a new record by adding a button/button wizard...... but haven't

Until recently Lebans solution for disabling the mouse scroll wheel has
worked perfectly.  Lately some departments have done upgrades - new computers
and peripherals.  The OS and software remains the same.  The mousehook.dll
also remains in the proper directory.  However, the mouse ...

I'm real new at this and hope someone can help. I've made a form using
Form Wizard, then changed the format to suit myself. The form controls
come from one main table which is linked to several others. Trouble is
that the form won't accept any information or even show its fields in

Hello.  I have a form with a command button on it. This form is linked
to a query with a field called "ID".  What I am trying to do is make
it so that when the user clicks on the command button, a separate form
(frm_Image)pops up with the corresponding picture to field ID.  I have

I have a simple request, which involves 3 fields only to help me iwth
my main job as a fire inspector.
I am writing a simple database that requires a date of last fire
inspection, frequency for reinspection and future inspection date

I want the background color of field last_name to change to gray if the value
of the field deceased? is true

The following string worked fine when the date argument in the DateAdd
function was Date(). Please could someone tell me how I should represent the
variable datDate in this string? I've tried using '#' & datDate & '#'. Any
help much appreciated.

WHEN YOU CREATE A USER IN ACCESS, WHILE WORKING ON A PARTICULATR FORM, HOW
CAN ONE FIELD HAVE THE SAME USER'S NAME INUPT BY DEFAULT?