I have a function designed to provide new values for PupilID field where
there are duplicates. It works fine until I add the Do...Loop.
With the loop I get an object required error for the counter.
Any ideas please on fixing this error.

what is the code in Visual Basic for the Delete Record command?  I am using
Access as the front end.  I used the command button wizzard but the delete
record code that is attached to that command is not working for me. Can
anyone advise?

I have a report that on open it runs a sub so that it displays a cross tab
query. i would like to show this data as if its a stored query. please let me
explain.
in order to have this report show my results, the module must run so that

I sent this question a couple of days ago without any response so I am
trying again.
How can I include a spreadsheet (excel or OWC11 spreadsheet) in a form in
Access 2007? I included OWC11.dll in my computer and my old form having the

maybe my previous post was too difficult to understand
I use a select case to add records to several tables by sequential file import
(open file)
only when a certain condition is true a new record is added to the 'primary'

I am writing a VBA program in Access 2003 that does five tasks:
1. open an Excel workbook
2. copy a worksheet to a temporary worksheet
3. copy data from a recordset to the temporary worksheet

I would like to use VBA to show the Query Design Grid, then after using the
QDG to select Tables, Fields, Criteria, etc., exit the QDG and have the
resulting SQL placed in a TextBox.
Is this possible?

I am very new to Access and VB, but I have had success in creating several
Forms.
This is what I want to do...
I have a combo box on my form that displays a listing of Streets names from

I might be approaching this the wrong way but thought I could use an
imagelist to populate a number of buttons with icons.  I have the imagelist
ActiveX on the form but cannot work out how to put the image from the
imagelist on the button.  I have tried searching for an answer ...

Using a continuous form, I have a date field which indicates an action.  The
next time an action occurs, a new date is entered (on a new line in the
form).  How would I calculate the number of days between the two actions?  
I'd appreciate any help.  Thanks

I'm trying to test a 4 field, 1 row table, on form_open, to determine if
any one of the fields are empty or not.
But using this example, my If (Null or "")test is ignored:
Dim db As Database, RS As Recordset

I use the following code to get the current user for automation purposes in
my main form:
Option Compare Database
Private Declare Function apiGetUserName Lib "advapi32.dll" Alias

Does anyone know whay this:
Select Case RST.Fields(i).Name
  Case "data", "startdate", "endDate"
      RST.Fields(i) =

Hi
please help me in writing the SQL "SELECT Brand, BrandDescription" ,  &
txtLoc & "FROm locationMap"
I hve one table  name LocationMap with the fields  Brand, BrandDescription,

I have a field called A, when somone update the B field, I would like the A
field get updated.
Note:
A is text, B is Date, RequestID is Autonumber