Does anyone know how I can check the regional settings on the PC that the
user is using.
I would like to know what country it is set for - e.g Australia, Singapore,
France etc.

Thanks for taking the time to read my question.
I have a form that I am viewing in datasheet view.  I have 42 fields, but
not all show up.
Is there a max number of fields allowed on a form?

I used the command button wizard to put a Save button on my form, but I would
like my Save button to save the current record and open a new blank record.  
What sort of code/query would I use to do this?
Thanks!

Is it possible to have up to 12 names selected from a multi select list box
appear in up to 12 seperate text boxes?

My function down below works great.  However, i've tried different ways so
that the limit will only be less than 16 and it's not working. Does anyone
have any suggestions where i can put the
<=16

I am really brain dead this week.  I can't remember how to make an Access
form auto fill subsequent fields.  For example I choose an employee in a
combobox and his address and company name and phone number automatically fill
in below in the other fields (appropriately named of ...

I know that there are various ways to convert data entered in forms to Upper
Case
via code behind each form or control or via an input mask.
I'm wondering if any one knows a way to do this by writing a global function

I have a ProjectEntryForm for entering new projects.  One of the fields is
CustomerName, which is a drop down combo box based on records in the
CustomerTable, so the user can select an existing customer.  If it is not in
the list, I have a "New Customer" button that opens up a ...

I need a total to calculate on my main form from numerous entries in a
subform.  For example I have a customer with several workorders. Each of
the workorders (listed in the subform) needs to wrap into the customer
total on my main form.  I keep getting erros.  Help please...

Does anyone know how to use fractions as data value because there isn't any
data value as fractions in Access?  I try to do fractions calculation such as
1/2 + 3/4. I can do it in Excel.  Please help

Hello, I have an access 97 application that uses a bound form.  In the past I
would
use
DoCmd.DoMenuItem acFormBar, acFile, acSaveRecord on the click event of a

I am getting the following error message:
"The expression On Click you entered as an event property setting produced
the following error:
Ambiguous name detected:"

Does anyone know how to make Access look up the Julian date?  Julian date is
how many days there have been so far in the year. (ie: 5 Janurary 05 : 05005,
30 Janurary : 05030, 1 April 05 : 05090 and 31 December 05 : 05365) [first 2
digits are the last 2 digits of the year, and ...

Hi
I'm trying to develop a login form for an access database.  This needs
to be quite simple with user, password and access level.  I don't want
to use the Access User Level Security at the moment.

I have a form with a combo box.  Selecting a facility number from the combo
box list will bring up the record associated with that facility number.  I
now need to use a macro to open this form, set a value in a combo box and
have it look up the matching record.  I am able to set ...