I have form with 12 buttons that are calling 12 queries. I'm trying to have
only one query instead of 12 as all queries are the same except some of the
field names (column names) in the SELECT statement.
I was trying to create a function with SELECT Case statement in VBA that

Looking for help with this issue. I have an invoice form with a field
[invoice_num] and want, on save, to create a sequential number. If  user
cancels the record any point before save I do not want to save the number to
ensure sequence for invoices is consistent.

Hello installed Windows NT and my mouse not recognized whether serial or ps2
as I can repair the problem?
Brain_X ;-)

Can any one tell me what does Space(512) do?
' Get the Caption of the SQL Design window
sCaption = Space(512)
lngRet = GetWindowText(hWndOQry, sCaption, 256)

Are there an examples out there of billing statements in access, perhaps with
multiple invoices, credits, payments and calculations?

Greetings all
I've developed an application with MS Access 2002 and distributed it with a
Setup program generated with Packaging Wizard. The setup works fine with
Windows 98 and 2000. But when I try to install the software in a computer