Hope someone can help me out.
I have a form with an underlying subform. Here's the code I've written to
take care of this in the Delete Record command button event procedure.
strSQL = "DELETE * FROM tblWeighting WHERE resourceID=" & Me.resourceID

I am unable to get the syntax correct for defining a variable with an AND
statement.  Both of the values are strings.
Dim stWhere As String
stWhere = ("[GrantProgram] = '" & [txtGrantProgram] & "'")

I would like to test for a value in one text box if another text box is
empty.  This is the code I have tried to place in the On Close event for the
form:
   If IsNull(Me.cboResponsePerson) And Not IsNull(Me.txtResponse) Then

Option Compare Database
This pulls data from tables and attempts to reformat it to display mor
like a spreadsheet in the subform of this main form.  The linked field
pass the name of the project for which the data needs to be displayed.

I want to be able to lock a record based on a condition. For example I have a
field called "Ordered" that tells me if the item has been ordered or not. I
want to prevent users from modifying this record if this field has a value
(date). I am trying to use the allow property for ...

I created a form in access by creating my textboxes and naming them as I
created the form instead of creating the database first and then bounding
them to the form. Right now I can't scroll through my records on the form
even though I can enter new records and save them to the ...

Hi,
 I have a form in datasheet view, it was built from a query.  it has 3
fields: Item#, Item Name and Qty.  Item# is a hidden column - not shown in
the Datasheet (although there is a value - 'cz it's pulled from select query

On XP SP2 machine, I'm trying to get an Access DB to open automatically every
day at a set time.  Here's the syntax I got from:
http://support.microsoft.com/?id=210111
myTest.bat is the following:

In a recent applicaton update, several dialog boxes appeared that displayed
information about the progress of the application install.  These were not
typical dialog boxes that I am accustomed to with my Access development,
clicking OK was not a requirement to acknowledge them ...

I have a question about a program I am creating for my work.
I am not very skilled at Access and I basicly need to know if I am going
about this right. I have created a Form with a Tab Control that has 6
Pages. I have 8 subforms Total on this Tab Control. Average 2 per page, one

I have a couple of apps that use a filesystemwatcher to scan folders for
file activity.  These generally work fine but occasionally just stop - no
errors, but they just stop picking up the activity.
Any ideas on how to avoid this happening?

I have a combo box on a form that contains vendor names.  I then have a
second combo box that contains products offered by that particular vendor.
The first combo box dictates what appears in the second combo box via a
query.

I have a table of known points. We have a course we send out managers
through. They pick several of the known points any any random order. I
would like to figure out how to get access to calculate the direction
from one point to the next.

Trying to create an array of check boxes to read by way of a loop. Vba won't
let me create an array of the same control on mt form ? Anyone know how I can
create this array on mt access 2003 form ?

I have two form called frmA and frmB.
In frmA, I have a sub procedure called cboPeriod_AfterUpdate.
frmA and frmB is loaded and I want to called the sub procedure
cboPeriod_AfterUpdate from frmB.