I have written a function that takes a record ID, two field names and the
document name to determine the interval between two dates and print and
invoice reminder if more than 28 days have passed.
The code is called with:

I have a subform that contains data listed in datasheet view.  I would like
to select certain records and make those records availble for further action
(eg append, update, etc after a button is pressed).
I need to keep this in a datasheet view and not a list box so I can allow

I have the code to open a form and add a name if the name does not appear in
combo box, but when I close the data input form the combo box does not pick
up the fact that the
name has beeen added.

I would like to know good resources for learning about how to create
comboboxes where I can choose items for output (like in the Northwinds
Database, where you can choose different options for your report) I also need
resources for writing code so I can be a more powerful user.

I have Error 3075 (missing operator on [NumProspect]) in the following code
put on a form After Update Event :
If Not IsNull(Me!NomClient) Then
       CurrentDb.Execute "UPDATE tblSecteurProspects SET " _

I have a combo box on my main for to pick clients and bring up all the
records for that client.  Some of the client names are in the combo box,
but do NOT have associated records yet.  I'm getting a invalid "NULL" error.
Does anyone have code to prevent this NULL error is no records ...

I have 2 sub forms.  Subform A is a datasheet.  SubformB is a form with 2
fields, CaseNo and Notes.  Both subforms are fed off of the same query.  When
I am on the current record of subformA, I need the notes for that current
record to display in subformB.  I have tried doing a ...

I want to renumber footnotes in each chapter beginning with footnote number
1. I may be stupid, but I do not know how to avoid getting the numbers for
chapter 2 in sequence with 1, etc.
John in Aiken

I have an Access 2002 database with forms and reports showing the data from
the database in graphic and tabular format.  I then preview the report and
can print it to Adobe Acrobat and get great professional looking output.
Now I need to know how to create the same stuff in ...

I want to restrict an "Accept" button to a Tracking note on the same form
until it has at least 5 characters in it.  I thought the code below would
work in the KeyDown or Keypress event of the textbox (Me.TrackingNote).  But
I'm still missing something. What is it?

On a form, I am trying to move the cursor based on the value a user selects
in a Yes/No combo box. If the user selects Yes, I want to move the cursor to
field1. If the user selects No, I want to move to field2.
Thanks

I have a continuous form which is the result of a query, giving a list of
results between two dates.  This works fine.
What I want to do is add (or change) data to one of the fields in the list.
e.g. the user will enter a value in an unbound textbox, click the button

I'm using Access 2000.  I'm trying to emulate the running sum of a text box
control property that exists if you are designing a report on a form.  For
example,
   Items IN       Items OUT           Running Sum

Any advice on the following issue please
Using MkDir D:\Data\Test the folder is made OK, however trying MkDir
\\192.168.2.2\Data\Test Access stops responding.
192.168.2.2 is the UNC address of the same pc and Data is the shared folder

I am interested to learn if anyone has a solution to open multiple instances
of a form that returns a value when closed.
I understand the fundamentals of opening multiple instances with the New
keyword.  Pausing the code while waiting for the form to close is another