I'm on my very first switchboard, and enter text next to the first button in
design mode.  
When I go to form view, it reads "New Switchboard Command" instead.
Anyone know how to fix this?

Is choosing "save as" and making a copy and removing the original the only
way to rename a report, table, or form?  I started with the Issues template
but I want to change the names of the objects.  I can right click and rename
the shortcuts in the navigator window, but the name ...

Sorry - I haven't used Access in a long time .....
I have 4 SQL linked tables.
A select Query is run on the SQL data.
A form opens, containing SQL data, as well as additional fields that I have

NEED HELP ON HOW TO GET STARTED ON BUILDING MY OWN LEATTER HEAD ON A DOC THAT
I CAN SAVE SO THAT I CAN USE IT OVER N OVER AGAIN-BY DOING ALIL EDITING.I AM  
JUST COMPLETLY CLUELESS ON DOING THIS,PLUS I AM NEW TO THE MS WORD 2007 AND
ALL IT'S OTHER OFFICE PROGRAMS.

I am trying to do something by using the most simple technique possible.
I have two tables in the database.  I have an input form which populates
table one.
On this input form there is a client code to be inputed.  Table two has the

I am printing a report of Items Ordered in response to a mailshot. If
there are any Advance Orders for books not yet in print, a subreport
is included with the detail line. I am then trying to add the total of
books ordered to the total value of advance orders. Can I tell from my

Can someone help with how I can populate a look up combo to only show the
last record in the table.
I know I will have to assign a query to the row source but I don't know how
to write the actual query.

First my apologies! I seem to have had my news reader filter set so that I
missed not only my original message but any responses I may have received.
If there is an archive I'd be glad to look there - but if not I'd sure
appreciate it if any replies would be resent. I suspect my ...

When I use this expression MonthRange:DateDiff("m",[DTE REF],[DTE OF PAY]),
if the [DTE REF] is, for example, 10/29/06 and [DTE OF PAY] is 11/05/07 it
calculates the result of 1.  When the result is really 0.  
Is there a way around this.  What I am looking to do is to say if the

I am not a newbie to Access, have developed couple of applications but
still dont know lot of concepts...
ok my question is
I have developed MS Access 2003 based application, where the

I imported the data for a table via ODBC.  The table is a single column with
30,000 records; most of which are duplicates.  I went to Access Help and it
said to select the table, copy, then paste-structure.  When I try this I get
the following error message

I consider myself an expert Excel user and an above average Access user.  I
am having considerable trouble understanding the syntax and parts of the
dlookup function.  Also would like some info on the appropriate use of the
quotes, brackets, etc.  I know that if I can get some ...

In a table have some value like
1-1-1
1-11-1
1-1-2

MS Access community,
I need to find a better solution to organizing a medical contacts list for
my non-profit naturopath referral list.  I'm currently using Microsoft
Outlook and with over 9,000 contacts and counting, Outlook is starting to

I frequently used Access 2000 System DSN's in XP. But I can't figure out how
to set these up in Vista. When I try to set them up, I can only find the SQL
driver. Vista Help tells me to find the ODBC Drivers on the web. I've never
had to do this before.