Where does one put the IN part for this SQL statement.
Right after the INSERT or where it is now?
It doesn't look right to me.
Also the  ending doesn't look good either.

Hi to everyone in the newsgroups,
I am using on my form, a Lebans's code, to auto size the dimensions of
text box to fit its content.
I find this example at, http://www.lebans.com/autosize_textbox.htm

I have a main form that contains 2 subforms:  Main, sub01, sub02
The main form is just a holding place for the 2 subforms.  The forms are not
bound to each other.
Sub01’s source is Query1 and is a continuous form.

I am trying to have an automatic "dsum" for the year prior to a year that is
calculated in field called "Selectedyear" so if selectedyear = 2008 then I
want the dsum to calculate field "2007" in table "BuildingDetails".
BuildingDetails table has fields (2007,2008,2009,2010,2011 ...

The If/then below was developed in Access03 and works on machines with
Access03 but is throwing an error on the one machine with Access2007:
If Me.TollLotSubRpt.Report!CATtype2 = "n/a" Then
Me.TollLotSubRpt.Report!CATtype2.Visible = False

I'm pretty new at this so please be patient. I am a Mechanical
contractor, putting together a database of boiler rooms for my client.
Here's my issue:
I would like to use a combo box selection to call on an option group.

I'm working on a program to categorize my wifes digital photographs.  As part
of that process, I want her to be able to select and view an image in an
image control (fine so far).  The problem is that I want her to be able to
rotate the image 90 degrees left or right, and save it ...

Sorry, this one seems like it should be easy, but I cannot figure it out...  
I am wanting to capture an amount when a specific check box is selected -
similar to how if you are using a query and place the [] around some title in
the criteria section, that will be the header for ...

Suppose that there are two related tables by just one field. Relation
type is  one-to-many relation: enforce referantial integrity enabled,
Cascade Update disabled, Cascade Delete disabled.
Say that Table1 has ONE, Table2 has MANY side of the relation.

This is my Class Module
Public Function REDACTIVE(strPath As String) As String
Dim strPath As String
strPath = Nz(DLookup("BackPath", "tblBackPath", "BackID =1 AND

I have a complex 'filter by form' Form with 20+ fields, which having filtered
the records provides the User with a button that opens a switchboard form on
which they choose a Report they wish to see based on the filtered records.
How do I pass the names (not the contents) of the ...

I am trying to move between records with the following code (in the AFTERT
Update event of a listbox):
Set rstMe = Me.RecordsetClone
rstMe.FindFirst "[Pupil ID] = " & Me!LstReqdPupil.ItemData(0)

Can I set a variable on the OnOpen event of a form.
And then use the value as long as the form is open?
Any special tricks to this?
Thanks

Here's what I want to do and it would seem that Main Form / Subform would be
the way to go.
I have a table that contains information about a customer.  I would like to
be able to select the Customer in the main form.  Then on the subform have

I have a form with an unbound text box for entering a date. The text
box's format property is set to Short Date. Here's the problem, based
on today (09/14/07):
If a user enters 01/15 into the text box, Access will expand that date