With -DoCmd.SelectObject acTable, , True- I open the Database Screen,
subsequently I open the Screen
-DoCmd.RunCommand acCmdLinkTables- for Linking new Tables.
After the user has been finished with linking new Tables I want to close the

Help Help!!
I have a combo box named cboALPHA with 5 records.  The 5 "unique" records are:
AAA; BBB; CCC; DDD; EEE.
I want the user to get a MsgBox when any of the 5 records are chosen.  The

Help, does not work. Could it be the "AND". This was an Excel formula.

I am trying to compare similar information between two access tables.
The information is in the form of numbers. In one table they can be
shown as similar to 0123456789 and the other table shows them as
456789. At any time the numbers can be shown in any number of digits,

Does anyone know of a way to import from MS Money into Access 2007?
I have a project for a lawsuit that I need to get tons of entries into an
Access database and I don't want to spend the next 2 weeks manually entering
the info.

Why can't I type an ampersand in MS Access?

Ok, I have a query that requests a user enter in a date such as 2/20/2007.
It then looks up some data, I then use this data in the following crosstab:
TRANSFORM Sum([qry_between].[TotalCharges]) AS [Total For Period]
SELECT [qry_between].[Sub Level A Name] AS Branch,

Is MS Access 2007 a relational database??

I would like some help on how to deal with missing records that have occured
due to me setting a field to required and then not inputting required field,
electing to stupidly close the database and it now has 6 records missing in
my table.  I cannot get htem back so am looking ...

How can I stop records being deleted if they are older than 12 months old
Thanks For any help................Bob

I have a tbale consisting of premium (currency), segment (text) and office
(text).  I want to run a query to rank the segments within each office.  Any
suggestions?  I'm not an sql wiz, unforutnately.

I have an Access database.  I'm not sure a form was created for it.  But I
need to view and print each indivadual record.  
Can someone tell me how to so this?

I will like to create a browse button than open the directory C:\ and after I
select the file it put the path in a text box which is a hyperlink.
I read a load of question already posted because I don’t want to repeat a
question.  

I have a unbound text box in my form and would like that undound text box to
state the current week # of the year and when the dates on that week are from
e.g., if this week is week 20 in 2005
Week# 20 dates from 05/08/2005 - 05/14/2005

I'm trying to prevent printing of a private phone number field based on a
field used to identify the number as "Public" or "Private".  I seem to only
include record or bypass whole record....