I have two problems I want to rename all tables of a database because if I
import these tables they get the name public + 'realname' so I don't want to
keep public.
Sub Renamingtables()

my table [tbleName] has 500 records, of names, cities, etc.  How do I make a
query that will give me a list of the cities, from the field [City], without
duplicates?
There will be lots of duplicates, but I just need a list of the cities

baffled on this one, can anyone help?
in code
I'm in the module I open a form acdialog mode.
a simple form with a list box and an 'ok' button.

I have a field in a query named Field1 (e.g.). Can I use code to set the
source for the field?
e.g. The following works in the query grid, but I would like to create a
function to do the same.

I have recently upgraded from Access 2000 to 2007. At the moment I am
continuing to use the database in Access 2000 format since the
database has confidential information and I needed to retain the
ability to control access to the different parts of the database.

to I've hidden the Access database window and on a form, have a button unhide
it.  However, sometimes a user will use the F11 key at an inappropriate place
to make the window appear.
Even though I'm fairly new to VB Application, I probaly should know this or

I realize this isn't directly related to Access, but I'm desperate. I support
an access appl that runs on a terminal services server.  I have been using
Windows remote desktop to access that server.  After months of doing this,
all of the sudden I can't connect - when I try to ...

Function Phone_List() As Recordset
'This opens a recordset from the Table [Name]
'This recordset contains records that have 3 or more phone #'s
Dim strSQL As String

I've got this nice little recordset up and running now, and get get things
from it like:
rst!Phone or rst!Name
...but I need to know the total number of records in it.  I tried

Below is a sample I use to run an update query.  Is there a way to tell if
any of the fields were actaully changed?  In this case, a carriage return was
removed from the end of the string. ...is there a way to tell if this changed
any fields?  That way, if if did, I could run it ...

I open a table (recordset?) with the following code:
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("Name")
...and then I can work with rst

Not sure if I should be posting this in Access or Word forum but since I am
trying to do what I want from Access I thought I would try here first.
I have an Access procedure to copy some data from a form in Access to
DocVariable fields in a word document and print the document. ...

Hi. I don't want to desactivate the F11 key because I need to access to the
database access windows.
So I would like to only desactive it for the rest of the users.
I have already a code in the Splash form the first one to open that disable

I use a modified keyboard layout for another language, when I use
KeyboardLanguage=? access automatically reverts back to the default keyboard
for that language. Does anyone know of a way to keep this from happening?

does anyone know best approach to import this text file with over 256
columns? thks  ken