Just wondering how would I construct this SQL string to use inside VBA code:
F_PUPILS.PU_SEQ, tblAcadGrade.AcadYear, tblAcadGrade.FS_Set_Code,
tblAcadGrade.FS_Subject, tblAcadGrade.Autumn, tblAcadGrade.Spring,
tblAcadGrade.Summer, tblPastoralAcad.WiTutor, tblPastoralAcad.SuTutor,

Losing what's left of my hair over this one, cannot get this to work. Access
2003
-----------------------------------------------------------------------------
FUNCTION dbo.mbtest

How can I take a look at the code behind a report that I have created using
the Access wizard? (using the Report as a code generator)
Looking forward to here from you

I've created a 4 generation pedigree form. With a loop, I'm trying to Null
several fields on Form4 but my code is wrong.  My code is using 'stTemp'
instead of the value of variable stTemp. The names go from H01...H31
Dim stFieldName As Integer

My client changed computers and I can no longer start Access 2003 in desing
mode by holding down the shift key.  Just want to start access without the
app runing.
Thanks for your help.

Hello to everybody,
In a form I have a text box "Niche". For each "Niche" I can associate a max
of 50 Cells (or number).
How may I obtain an alert message if I type twice the same number for the

I'm looking at the SBS marketing pieces and so forth, and they keep talking
about setting up the company website and I'm a bit confused:
Are they suggesting hosting our www website on the domain controller (we're
a one server shop) or they talking about an internal intranet site?  ...

I have two forms, the first is a login form, usual username and password, I
want to remember the username and use it as a parameter in a query that loads
a list box in another form.
Unfortunately it fails, as the Login Form closes as the alternate form loads

I have tried every combination of joins and definitions in the use of the
Auto-Fill select query without complete success.  The query Auto-Fills fields
properly, but when it closes, the primary (imported) fields are not updated
while the other new data inputed  is.

Does anyone knows how to erase the value of a FormField in Word with Office
2003?
When I am using the code as membered (sending an empty string) below I get
an error and the FormField is still having it's value.

I have some code written for a combo box On Change event on a form.  I would
like to have the result of that code returned to a control on the current
record (the one that triggered the On Change event).  
Here are the last two lines of my code:

I am using SendObjects in an app that runs on a Win2K server (member of
SBS2000 domain, but not DC). Downloaded Express Click Yes, which gets me past
the Outlook security nuisance, but I still get a prompt to choose the mail
profile every time this runs (before it gets to the ...

Up to now, I was working with a SQL Server 7 and VBSQL. It was easy to call
a stored procedure with  (usually) a SELECT parameter and retrieve a cursor
from the stored procedure.
As I am in the process to migrating to a SQL 2005 Server, I can't use VBSQL

Hi I have a number of currency data types that when being used in IF
comparisons are not getting what I want for instance...
a user enters a value in a text box....I then use thsi value to compare
against the currency data type...

I am getting ERR 3326 "This recordset is not updatable" when trying to
manipulate data in controls on a form with VBA. The code is in a form module,
examples:
Forms!frmMembership!DateJoined = Date