I have developed this database completely in Access 2003.
The ControlTip texts I have placed for various controls is not appearing.
This worked in previous version of Access.  Is there a setting somewhere
that is preventing these from appearing?

Using Office 2003 and Windows XP;
I just need to know the fastest, most direct, and expedient method of just
copying one table from one DB into a new blank DB, both are Access 2003.
The table to be copied is stand alone; i.e. no joins or connections to any

I'm helping a friend with a program that uses random numbers. The user
tells the program how many questions to ask and the program will either
add, sub, multiply, or divide 2 numbers. The range of random numbers is
from 0-100. The problem, if there is one, is that many times the ...

Our office database is set up that every entry receives a new control number
- 2006-0001, 2006-0002, 2006-003, etc. I would like to change it for calendar
year 2007. How do I change it?
Our access expert is gone and not available

I have an Access form with a button.  When clicked, it opens a variety of
queries which eventually lead to a final table.  I want to add a line to
automatically open an Excel sheet I have linked to this table.  Seems like it
should be simple enough but I have not been able to ...

I am trying to import 4 fields from database1 into a table in database2.  
Here is the code I am using:
vSQL = "INSERT INTO CITY_TABLE SELECT [Field1],[Field2],[Field3],[Field4]
FROM [All_Officesl] IN 'C:\Locations\City.mdb' WHERE [Field1] = '" & Loc & "'"

A database I inherited was developed by someone who thought font size 5 was a
good size for everyone to read (I think he liked squinting); Nevertheless,
he's gone (for good reason) and I'm stuck with having to open each table and
select Format - Font - Size 10. Not an impossible ...

I have a form that on the OnOpen Event has the following code:
'------------------------------------------------------------------------------
Dim strRecSource, strOne As String
strOne = "[05] + [06]"

For documentation purposes, I need to identify the sub-reports in a list of
reports. Can you provide some code?
Thanks,

How do I return a part of a field if that part matches a certain
format?  In this case, being a three digit number (###), or a six
digit number (###-###) followed by a letter g.
More specifically, I have a field for fabric (FabricAdj) which runs

In a field of a query is there a way to call a function to return a formula
to the query field?  I have tried but when I create the formula in the
function it always returns the string.  I need to call the function because
the field(s) needed to sum in the query field will not ...

I'd like to insert a lot of HTML text into a messsage that I am sending
through SendObject code.  Is there are way to do this (novice level).
Any help is much appreciated!

How would I do this (or any other report property)?

I am trying to build a text string that has to have a set number of
characters.  Some of the fields in the database have a value of 'null.'  I
need to be able to format the null field as being say 10 positons long and
have the ten positions added to the string.  The following ...

How do I call a sub procedure from a different form?  
Here’s the setup:  Form A has a button to open form B.  Form A is still
open, but form B is on top. Once form B is updated I want to close form B,
but have it run a procedure from form A.