This is probably a very stupid question but for the life of me I
cannot figure it out.  I have a form with tabbed pages and on one of
the pages I want to put more tabbed pages.  When I put the sub tabbed
pages on the page I want it shows up on all pages.  This is annoying.

I have field1, field2, field3. Let's say I have record 111,222,333 and
I don't wont to have the same record. 111,333,222 or similar might
be.
Thank you

The sendmessage code below in a form causes error 429 "ActiveX
component cannot create object".
   SendMessage "johndoe@xxx.net, word.doc"
This happens for a user running Outlook 2007.

When I display the form, the screen flickers, the hourglass flickers
on and off, and the taskbar displays 'Calculating'.
The form is quite complex with nine tabs and seven subforms. but the
problem only occurs in certain records.

I'm trying to use a multi-select listbox as criteria to either add new
record or edit the current record of the destiantation table with each
row selected in the box.  This works fine for adding a new record but
once records exist in the destination table, the routine seems to

Actually I have two guestions using AccessXP;
1. can you have a pass-thru query(which is TSQL coded) be the source
of an access select query(SQL coded)??
2. Is there a third party product or access add-in that will convert

loads of money £££££££ An easy way to make money and get rich quick!
No scam! 100% legal this is not a scam i have done it myself Can you
really make money so easily? I did and this helps while developing my
own online business! I thought it was impossible. Just read this. I

I have a form that the user enters a logon and password. I want to set
the minimum number of characters allowed in the password filed to 6
characters
I have the Input Mask of the Password Field on the form and in the

running access 2k;
And before anything else is said - "Yes, Virginia, I know you can NOT
use a variable to set a constant (that's why it's constant)".
BUT - my problem is - I want a constant, that I can set from a

mdb was originally developed on another machine and I had no trouble in
making a MDE. It is now on a XP machine with Access 97 installed as well as
Office 2003
installed (but not Access 2003). The mdb runs perfectly well, but I get the

First, I read http://allenbrowne.com/appevent.html
I have a rather large database of phone call information ... and I'd
like to search for "overlapping" calls.  I have FromPhoneNumber,
ToPhoneNumber, DateTimeBegan, DateTimeEnded.

I have a BMP file, with the same name as the application, in the folder
where the app resides.  The application also has user level security.
When I click on the desktop icon to open the app, the splash screen
appears for an instant before Access opens a blank full screen view ...

Does anyone know of a web service that can supply live currency
exchange rate data to Access, via an addin, VBA snippet, or some other
technology?
Thanks,

I have an Access front end that uses an ODBC connection to a SQL
Server database.
Every time i come into my Access front end and try to execute a query,
it fails and the prompts me with a SQL Server Login .

I'd appreciate if someone could give me a hint to this little annoying
problem:
I have a simple database that I want to be able to query from Excel.
When I use the "new database query" wizard on an unsecured version of