Dear reader,
Do you know where user defined menues from Access 2003 are stored
and how they can be extended/edited?
Thank you,

I have this statement in my order form.
Before insert function:
Private Sub Form_BeforeInsert(Cancel As Integer)
  Me.InvoiceID = Nz(DMax("InvoiceID", "Orders"), 0) + 1

Run-time error '2293'
Access can't send a message for the reason stated in the preceding alert.
Resolve that problem and then send the message again.
There is no previous alert.

Hello everyone.  I am currently making a database for my school and I have
run into a problem with two forms, henceforth known as Form 1 and 2.  Both
forms take First and Last name from one table.  The problem is that Form 2
does not pick up a new record whenever I add a name to ...

I'm having a lot of trouble with this syntax.  It's supposed to return the
termination_date from the current participant_id's most previous match.
DMax("match_terminated", "tbl_match", "participant_id=" & Me.participant_id
& "AND "match_terminated<" & match_date)

I have a main form with two linked subforms (very like the customer order
form in Northwind 2003). In the footer of the main form is a control which
calculates the amounts entered in one of the subforms to provide an overall
total. It reads =dsum("[funding]","Query1","[siteahid] ...

I have a Main Form and want to link it to other 2 Sub forms through a command
button that open this subforms, since I don´t want to visualize both sub
forms all the time. The thing is that when I use the wizard and specify the
target id fields, my sub forms show all records and ...

On my invoice form, i want to do the following. If the when invoice is paid,
I want to lock the invoice that the user should not be able to do any
changes to the invoice.
In the OnCurrent event I can find out if the invoice is paid or not.

I have a form with a subform that it used to enter ECOs (Engineering Change
Orders). On the form, when the user selects the option "Type 5" from a
combobox, a popup form is displayed in which the user will enter information
to run two queries. The first query, a select query, takes ...

I expect this is real easy. I have access 2007 and all was working okay.
Now, when I am designing a form I am unable to view the properties of a form
in any database.
I imagine it is a setting somewhere but I cannot see it.

I have read much of the resource that has been suggested to me in this forum,
but am still having problems.
Amongst other tables I have the following:-
Class table

I have Access 2007 w/Windows Vista. I have created a database and I am having
several problems. When I open my form it opens to a new record only. I set up
command buttons on the new record so that I may hide my toolbar. The command
buttons jobs are to go to the first or last record ...

I have Private sub name1() and Private sub name2() in my vba.
I have Dim X as interger and I give value to X in Private sub name1().
I would like to use X also in Private sub name2(). Do I have to make a
function or how can I use this X-value I gave in Private sub name1()

I have a subform with several fields, one of which is "DateOut".  If this
field is left blank, I would like to set this record as the Current Record.  
Can anyone provide help on how to go about doing this?

I want to create an expression that charges 10% freight on the retail with a
9.50 minimum.  How do I do that?