Hi, my name is Nadia. I joined this Access community so that I can brush up
on my Access skills. I really think this is a great idea. :-)
Well, I'm going now.

I need to create a query that will display information in different cities,
but the city need to only be displayed once.

Hi, I am tring to create something on access 2003 to send external mail to
the suppliers and I am using the following code:
Private Sub CommandButton1_Click()
'Sub Mail_Selection_Range_Outlook_Body()

I am a new user of Access 2007. I have made a database and now want to delete
it. The database was saved to "My Documents". I deleted it from "My
Documents" but when I go to Access and select open, on that "Recent
Documents" it still ahows there.

How do I query a table check box "on" condition? I want results of a table
query that only have the check box checked?

G-day
I am stetting up a  database. I have built the tables and have them set in
one relationship. Now I would like to take a number from one colum and would
like to do a calculation and have that entered in  another colum in a

I cannot firnd the view button that I needs in the Access Database Worksheet.
I would like to know where can I find or locate it?  Once I locate it how
can I put it on the Access Database Worksheet Ribbon?

I recently implemented user-level security for a group of twenty people for
my database. On my PC, a prompt will ask for a User Name and Password. On
someone else's PC, they can access the database as an Admin with the
System1.mdw as the Workgroup File. They are not prompted for ...

Hi All,
Currently, my environment is this:
LOCAL COMPUTER: OS is XP, Database is ACCESS2007
INTERNET: Server is UNIX, Database is MySQL (via commercial hosting, I have a

I have an Access app that I roll out to 7 locations. The code part is the
same but each location has it's data in a different location. Currently I
copy the original to each user's network path and then open it and relink to
their data, but I'm sure there's a way to do this better.

Up until a few days ago, when I tried to delete a record, a box would pop up,
asking me if I was sure I wanted to delete the record. Now it just deletes
the record without asking me!  How do I get the question back?

I have a function that generates a string and I need to enter it in A Bound
Field:
Public Function PtKey()
...

I'm sure this is straightforward but I just can't get it to work so
I'd appreciate some help.
I have a form which is based on a parameter query to restrict the
displayed records to a single member of staff. It works fine but when

A          B          C    
1         10         TEN
2         20         TWNETY
3         25         TWENTYFIVE

Need help please & it goes like this. I have in column L the words NEW &
EXISTING & in column M the letters Y & N. All I need is to count the number
of NEW & Y as one cell. Same goes with EXISTING & Y. I've tried all sorts of
COUNTIF formula but it always returns zero.