I have created a database that stores information and then on a click of a
button, based on the users selections from a main page (form) queries the
data returning the results on a new form.  I have also created a button to
open a report that show the same data.  As part of the ...

Can we set few properties (as we have NLS in Oracle) at database level in
ACCESS 2003?
Most important is setting a date format for the whole database (though
regional setting is one option but i want to do that programatically or once

I've been tasked to revise an existing slide show that uses Access and
Powerpoint. This show is displayed weekly to a large audience and covers many
different items. Over the years, the presentation has been played with so
much that it looks bad.  Access is used because it ...

I am having such a frustrating problem and would appreciate any advice.
I have a split database and have approximately 15 front ends.  All of a
sudden, i am getting some bizzare record locking error message.  I have a
table which allows users to select via a combo box a patient's ...

I have an access 2000 database with some linked SQL server 2000 tables.
Everytime i open the database it always asks for the SQL user and password.
This database has eventually to be deployed round an office and obviously i
don't want the end users knowing these details.

My combo box shows fiscal month choices and autofills another field with the
date the fiscal month ends.  This works.  But, when I make my choice, save,
and go on to the next record, my choice shows up there also.
One choice on one record is filling in all records with that choice ...

I have a database in which I want to autonumber a Field based on the number
of occurances.
Say I have a database that holds calls for a client. (Table "CALLS"). This
database has a relationship to another table called "CLIENT". When I add a

I want one of my forms that I'm going to be using as a switchboard to be the
item that one sees upon opening the database in Access.  We have another
database that someone else created that does this so I know it can be done I
just can't figure it out.  I want the "objects ...

I have two related tables that are updated via a form. I need an item of
data in the second to be mandatory i.e.. Default Value only populates if
something else is entered but if nothing is entered I don't get an entry. If
nothing else is entered into the secondary table I would ...

I am having problems linking tables in a hosted SQL 2005 database on
GearHost.com. I have Vista with Access 2007. I am linking via ODBC DSN. The
DSN test is successful and I can complete the linking process, ie I can pick
the table in list. Once I try to view the contents of the ...

This appears to be easy for me, but for some reason I can't get my head
around it.
I have a find button that I would like to give me the results for all titles
under that publisher code.

I posted this in forms design and didn't have a response - I really need help.
I need to create a form or report in pivot table format for data from a
query based on a date range - I can do this BUT I am not able to get the
start and end dates to appear on the final form, leaving ...

When I query the the central project table to allow entry of multiple contact
information, the query fails. I.E. The query is only successful when adding
ONE contact's information... the database is not working!
The project table primary (text) key is: ProjectId. The four contact ...

I'm working on a very basic database design for entering data from a survey.
I am used to working with numeric data in the analysis stage. How do I define
a field as numeric and show the display on the form formatted as text? For
example, one question is: Are you a boy or girl? I ...

pl advise "how to open ppsx."