Why would one not want to sort records in a form using Form Properties

It's the fastest way, isn't it?

Hello world;
I have two questions with respect to MSAccess database files
(*.mdb and assorted helper files):
1) Is there documentation (presumably imperfect, achieved by

I'm trying to build a simple report.  It will show debtors, budgeted amounts
and how much was actually paid to those debtors.  I've tried using the
expression builder, though I've never used it before I somehow believe I
know how, apparently not!  I chose the location of where the ...

Question about DoCmd.PrintOut in A97.
I have a form on which all the controls are unbound. There is a large
textbox that the user can type stuff in and a couple labels. I am trying
to code a Print button to simply print out the form.

I tried to add the "Microsoft Common Dialog Control, version 6.0" (also
known as COMDLG32.OCX) to an Access97 application I am developing and
received error "You Don't Have a License to use this ActiveX Control".
I Googled around and the closest thing I could find only applies to

(new to access / databases)
I have just installed MS Access 2000 on an XP Sp2 based PC.
Each time I try to create a new database or project I get a series of error
messages.

I have an access data project (MS-SQL Svr 2000 backend and MS-Access 2003
Front End) that has a sub-form based on a query view. On the sub form I have
several column's in which I have a running total on the sub-form footer.
This part works fine.

I have a field in a table that needs to be automatically incremented
but the number is non-standard.  There is already existing data in the
table but for future records, I need a certain number and it's
increment to appear.

I have 2 fields with Radio button Data Type, and both fields with more
than one options.  On Field1, I want the user to select option1, then
Field2 is shown and able to select.  If the user selects Option2, then
Field2 is not shown.

I have a problem with the date format of one particular date field.
I want it to use the english UK/australian date format ie 26/10/05 and not
the U.S. format of 10/26/05.
For some strange reason, other date fields are fine... I've checked the

I am running a database on a file server from a pc operating Windows XP Pro.
MS Office 2003 is used.  When I open the database, below error message
appears.
The expression On Click you entered as the event property setting produced

Is there a way to programatically retrieve the current .adp file name
from within an Access data project without DAO?  I know if I referenced
DAO I could simply use CurrentDb.Name for this, but is there a way to
get this information using the Application object or some other means?

I am trying to figure out how to use a class with a custom event as a
wrapper for a subform so that I can automatically trigger things to
happen on the parent form when the custom event is raised.  I am new to
custom events, so please bear with me...

For example:    Nz([LaborCost],0) returns "300" if the value in
[LaborCost] field is 300 (currency data type) and "0" if the value is
zero or null. I get strings in the query output - they are all left
aligned and I cannot add them without first converting them to

I am trying to create a registration system in which a unique text string
accessible in a table of the program is turned into a unique number which
will be matched with a number sent to the customer to type into the program
to reregister it.  The idea is that this key will not ...