Probably bnot a good description but I'm finding it hard to put into words
what my requirements are.
I have a form with many labels and one free text field users can key into.  
Rather than having a button to 'Update' after completing the comments I was

I'm trying to copy fields from a current form to a table not associated with
the form.
All the fields are Text and i'm getting a syntax error on UPDATE command
My code is as follows fired on a onClick button:

I'm building a customized payroll report in Access in which some of the
headings have a vertical orientation. The problem is, I haven't found a way
to change the direction of the vertical text. I'd like this text to be read
from bottom to top. So far, I can only produce vertical ...

Hi all, i have a number of text boxes on a sub form and one of the fields is
a Yes/No field for request rejected. What i would like to hapen is; if this
field id flagged for rejected (Yes) then i want that row or a field in that
row to be red.

Could someone please show me how to extract the last 7 records from the code
below
SELECT Table1.A, Table1.B
FROM Table1

Is there a problem with the gotorecord command in access 2007 ?
I have this code
stTEst = IsNull(Forms(scrF)!ScriptID)
If stTEst Then

I've been at this way too long to have this problem, but here it is anyway:
Continuous form.
Combo box, column 1 bound to field in table that is the form's RecordSource.
Field is not part of PK in table.

Hi
Im writing RS on Query to update records to new table but it gives me error,
can some one help me to write this recrod set pls.
dim db as DAO.Database

I am using Access 2007 and have the following problems:-
1) I cannot see any available activeX controls when I go to the add-in
manager in visual basic.
2) My wizards for combo boxes, etc have disappeared

I created a botton that enrols a student into a class. when I pressed the
botton, it works properly in data insert and delete level.
But Requery statement at the end of the code is not working properly.
Therefore, I need to manually requery the subform (manually requerying also

I would like to set tabbed documents to false programmatically. How can I do?
Also, I would like to know how can I set all options for access 2007
programmatically.
Thanks for your help,

I hope the title makes sense, i'm still getting to grips with programming
terminology :)
Basically i have a combobox which will sometimes contain
DataDate...... or LoginDate..... or DateModified.... etc

I am using the following code....
Public Sub sSendEmail(ByVal strMailTo, _
ByVal strSubject, _
ByVal strMsg, _

I need to be able to use PIA's to invoke Access 2003 OR Access 2007 from the
same .NET 3.0 application.
But I would rather not have to include a reference to BOTH the 2003 and the
2007 PIA in my app (if that's even possible).  Instead, I plan to implement

How can I detect if any recordset is open and then close it?
Is it possible to do this procedure?
I appreciate any suggestions.
Thanks