I've got a client/transaction type of database where tblClient is linked to
tblTransactions via ClientID.  The client table contains all clients from
day one.  The transaction table contains all transactions from day one
(includes any purchases, labor charges, payments, ...

Hello, Hope everyone is well :-)
Any help would be very much appreciated......what I want to do is use
the IE 6/7 object model from within VBA (MS Access 2007) to browse to
a web site, log in using a SecureID FOB and a WInXP username/password

Is it the rule that any table that you want to use via ODBC must be a
UNIQUE record?
And if you want any speed associated with the table it should be indexed?
I was having some difficulty linking to some FoxPro files last week.  I

Set rstTemp = .OpenRecordset(dbOpenSnapshot)
Execution of the above line gives me a "Too few parameters"
error. The line is preceeded by another line I thought would
make it work...     With qdfTemp

When looping through all controls on a form in code, is it possible to
determine what section a control belongs to? I want to skip controls in the
footer for some code I'm doing.

I have a form that has its own custom menu bar in Access 2000. I'd like to
make a copy of the menu bar and use it with another form. How can I do this?
Thanks.

Using access 2007 in MDE
All tabbed forms opened as maxmised with no restore or minimised buton. A
lot of my forms look really ugly if maximised. Anyway to open it not
maximsed or get the retore buttons to display?

I'm using automation with winword to search and replace text in a word
document.
The word document is a letter with text such as <<Company_Name>> and
Dear <<FirstName>>, Which of course I would like to replace with

Hiya folks,
I'm trying to put together a database for student involvement in school
sport activities. I'm not exactly what you'd call "proficent" in Access,
so my apologies if I'm making some very stupid or obvious error.

is there a way to group records in forms in 2003 version
ie.  i have number of records with date and would like to see it in this way
on a form
sep 2007

it is easy to go to the database window to double click on a table and
open it. it is also possible to import or link tables of a secured
database and open up the tables in a new database.
is there any way i can secure (lock or hide) access tables so nobody

I tried to post the following in the Access Team Blog (twice) but
didn't see it posted. I don't know if it was because it is long or
because the administrator censored it.
I did manage to get a short note published so maybe it is just the

in einer Access Datenbank ist ein Feld, in dem ein Benutzer ein Datum
hineinschreibt. Und zwar in der Form 09.11.2007 13:30:00. Wie kann ich es
erreichen, dass der entsprechende Datensatz genau diesem Datum und dieser
Uhrzeit beim nächsten Klick auf die Navigationsschaltfläche sich ...

This is driving me nuts. Can anyone help?
I have a program which searches for and analyses Access databases
across a corporate network. At one point in the code I am looping
quickly through all the querydefs in the target database to give an

Problem Description:
I have a large form called Reports Menu that lists several reports that can
be viewed or printed.  Printing works fine.  When I click view, the report
opens behind the Reports Menu.  I then have to minimize or close the reports