I've read prior posts on getting rid of extra instances of Excel that using
the Excel application from within Access code can present.  I've checked and
followed the objects created in the code, making sure to quit and set the
objects to nothing.  Below is the code I've been ...

I wrote a COM object several years ago using VB6 that would query an Access
2002 database into a DAO recordset. It would then format the data in a very
specific way and then write it out to an excel.application object. This all
used to work just great and the COM object could be ...

I need to be able to perform the same function as the command nslookup to
resolve a host name (i.e. ptr001.domain.com) to a ip address (10.10.1.1) .  
The hosts are not computers, they are network attached printers.  Does anyone
have a suggestion?

I have a subform in a form.
On opening the form, I have a VB script that turns allowedits on and off
based on parameters.  The script kicks off on the "on open" event.
The weird thing is, despite having Me.AllowEdits = False for both the form

Hiya all,
I need some help to get my code running. I must say that I'm quit new with
VB / VBA so maybe my question is a bit stupid. But anyway I would be really
happy when the following code will run nice and smoothly.

Using a list box, I simply need to pass the user's selection from the pull
down (which displays values from a particular column in a table) to a
variable.  Stumped.
Is this a Dlookup?  An SQL statement?  Suggested VBA code appreciated!

Is there anyway for me to change the fore color of the column headers of a
subform in the datasheet view?
I'm using Access 2000

I have code in the click event that opens a form (very straight forward
(just used the wizard).
What i now want to do is;
If the user holds in the SHIFT key and then clicks that same button another

Just a question that I have been wondering about.  I have recently started
using more and more recordsets to handle data in applications I have been
writting.  Now I am mostly self taught so I don't have a perfect handle on
everything access can do and can't do but I try to make ...

I am trying to implement Stephen's CanGrow to resize a text box on a
continuous form based on the control's content.  However , I keep getting an
error 2465?  The detail section and the control are set to can grow and can
shrink to yes, and the text box has scroll bars set to ...

Is there a way to list the objects in a query via code?

I have a very large table to be updated from an array. The array takes 3 sec
to be filled from a Tlist GRID, but saving the data from the array to the
table takes 50 sec, which is too much. Is there a way to do this faster?
What I am doing is 2 loops to go throu the array, ...

Please help:
1.  How can I open the immediate window using vba (Alt G) so that when I
open a module,  the immediate window is already open?
2.  How can I move focus to the "Modules" window with vba?

Can you help me build a password that is written in the table “my company
information” field PIN
I want at first to write the password by opening the form containig this
table, and after that, with the help of what is written there pass it to the

This seemed easy at first...
I have a database which users can download from a web site in a zipped file,
and then use on their machines - completely free-standing.  
How can I get the database to go to a .txt file on the website when it