Access07  In the frontend, a table (linked from backend) will not open when
double clicked.  It presents a parameter prompt for the one field of that
table that is indeed defined as a lookup field - as if it were a query that I
was opening.  However in the frontend the subform ...

I have a report with a GroupHeader called Title Header.  The header has two
fields on it.  It works fine, showing the two fields at the top of each
group.
What I want to do is put the two fields in the Page Header so when the

I need to assign new records a [FieldValue] something like Max[FieldValue]
+1; Except, the next step must begin with the nearest new series. For
example, if Max[FieldValue]=589, then new records should take on values like
[FieldValue]=601, then 602, and so on. The new records are ...

I have preprinted forms that I need to address. My members data is in Excel,
but I can convert it to Access if needed.  I want to address the forms in the
proper spot, then fold and insert to window envelopes.  I want to avoid
printing labels and then havign to stick them on the ...

I have created a form with an embedded subform that will be used to add/edit
records into 2 tables.  One is a table of categories that is used as a look
up table.  The other table is a set of steps that are used in a drop down
menu.  In my form, I am able to add new records to ...

I have a mdb working fine on the PC having Windows XP and Ms Offfice 2000
installed
The same mdb when I am using on PC having Windows Vista with MS Office 2003
installed and I am getting the following warning dailog :

How do I change the starting value of autonumber ie other than 1(Access 2007)?

I changed my email address because of the scam going around. Please start
sending me stuff to this one. diane_tigue_1979@microsoft.com let me know if
you get this.

Hi,
Is there a code which i can put into a command button's click event which
will setfocus to the next item in my tab index??
Thanks

Using Access 2000
Skill level - new
I'm trying to create a simple database to catalog DVDs.  I have most
everything set up the way that I want.  However, I would like to make a

3Q and you'd better tell me it's Chinese meaning.

2 questions...
Is there a way to choose what color the command buttons are?
How do I make a form open up (the main menu) when the database is opened?
Thanks!

Is it possible to spell check any text entered into a form to be sure it will
print out correctly on the report?  The field type it is entered into is text
or memo.
Thanks.

FileNum = FreeFile()
N = "C:\SelfAud\ROMStL.mdb"
Open "C:\SelfAud\ROMStL.mdb" For Input As #FileNum
FileLength = LOF(FileNum)

In Access 2003, I could sort on memo fields.  But in Access 2007, when I'm in
a memo field, the sort buttons are disabled.  Is there anything I can do
about this?