I am trying to familiarize myself with a new ActiveX control.  If I
place the control on the form and then reference it via code, the
Intellisense does not work.  However, if I explicitly declare the
control in code, then the Intellisense works.

I have a query that performs a simple sum, a running total
essentially. I want to be able to use that in a calculation in a form
but I can't seem to get it to display anything beyond #Name?
Structure -

I have a little search routine going whereby the user types in some text and
clicks a button on the main form.
I then see if that text exists in a record on the subform.  I get a match,
grab the record id and am now trying to automatically highlight that record

Looking for design approach ideas for collecting data from multiple
remote, standalone databases.  I have built one of these in Access.
Another I am told was built in Access.  some others the language and
database is unknown.

I have a combo box called "Recipient" who's row source is a table called
"Main" with three columns. The three columns are "Name", "Floor", "Location".
Following the combo box are two fields called "Floor" and "Location". The
after update event of the combo box runs the following ...

I have a problem that I haven't been able to resolve.  I have a form
that is opened by clicking a command button which does a simple
DoCmd.OpenForm action.  The form being opened is a fairly simple form
with the Data Entry attribute set to Yes.

Is there a way to select into a table in another database?
I have a db that contains master information on a series of tests. I
want to be able to make a subreplicant of the database that contains
only test information for a particular usergroup.

I'm using MS Access 2003 database.
Now I want to write a query that retrieves "n" rows that are not TOP
rows but starts from position "m".
For example: I have a table "Notes". Which has 37 rows and I need to

Hey all,
(Access 2000)
I've been having a horror story with this design problem. My Database is
Structured like This: AUTHORS, BOOKS, PAGES. Those are the Tables and each

I am going to use easy help to create my hlp files. I want to just have a
button on my form that says HELP. I would like to then set it up so that I
open the .hlp file. What would my Shell command read?

I have some functions that will allow a user to attach to a different
back-end database. I added this functionality to the program Ribbon in a
custom Access 2007 app. I have 2 ways to attach to a different back end db.
One is through a browse function. So the ribbon button option ...

I have an extremely simple query I'm running on a linked table.
However, when I run it (primarily, I'm exporting to a .txt file, but
the behavior persists even if I run the query), it returns zero
results. Then, when I view the table, it has zero records.

I am new to Access and want to transfer data to and from outlook calendar
( from access ) I need the date, location, and subject fields does any
versions of outlook and access do this or do I need a add-in any info will
be very useful

I want to export from Access 2000 a numeric field (double) to a text
file.  The export file should be fixed length (no delimiters), the
field should have 9 digits in total, including 2 decimals.  I want the
field to be right aligned so that the decimal separator is always in

I have a button on a form that prints a report based on a query i do
NOT show the report it just prints the report when the button is
clicked however i would like a message box to show how many pages are
needed to put in the printer to match the ammount of pages printing