A little while back, I was browsing these newsgroups, just like you
are now, and came across an article similar to this that said you
could make thousands of dollars within weeks with only an initial
investment of $5.00 !  So I thought, "Yeah, right, this must be a

Am using A97. Have defined Machine Data Source type DSNs
in Access' File, Get External Data, Link Tables, Files of Type ODBC,
Machine Data Source tab. Have many definitions. Would like to
delete some. Would like to edit some.

I'd like to know what references in my vba code are used or not.
I work in a code made by another person previously, i founded to many
references and i believe that someones are not used.
I'd like to optimize the application ereasing the useless references.

I have a sub form that both presents data based on the master form
(frmvacancy/tblvacancy).  When the subform appears it shows data from
a table (tblvacancy) that uses the primary key from the master form
(frmvacancy).  I can get the data to appear correctly in the subform

i have a rather short and possibly easy question: i have two tables
and want to find all unequal datasets. for instance like this: i have
a table A holding fields id and x and a table B holding id and y. now
i want to show a table C holding all ids except the intersection of

I have this sql that comes from the debug screen... where it fails in
code.  [Microsoft][ODBC SQL Server Driver][SQL Server] 'First' is not
a recognized function name.   I had this running on another machine
where it did not question the syntax.

I am designing the tables for a risk management database.  The current
build is like so:
RISK TABLE
Risk ID*

I need help in figuring out why a shortcut on a desktop to an access
database times out and never opens. This occurs on one computer and
not the rest..
I am able to open MSaccess and then the database from a peer to peer

Good morning,
If I group several text boxes and an image together, is there a way via VBA
to move everything at once (reference the group) rather than have a line of
code for each control?

I have a query (say it's called "Query1") that contains data in the
following structure:
id     reference       scoretype       score
--     --------------       --------------       ---------

I am trying to fix an access database for someone. They are having an
issue on a particular form when entering data. When any character gets
typed into the form, the below error gets displayed:
Run-time error '2450'

Hi, I know I seem to have the really complicated questions, but I guess
that's why I'm here.   This is a little verbose, only because I've been
trying to crack this for a week now.
Your help would be appreciated.

Have UNION query pulling & merging data from 3 tables.
Would like to show Name, Addr, City, State, Zip and table
name of source table. Dunno how.

I'm a student trying to teach myself to use access. I somehow managed
to minimize my navigation pane and now I can't figure out how to
reopen it. The Access handbook says that, even when minimized, it
should appear as a thin strip on the side, but it doesn't. Is there

There are a few memo fields in my report, with variable amounts of
possible content. How can I make the height of the box dependent of
the content inside it?
I already tried to figure out the information on