I have an application where the database window is hidden from the startup
menu option.
But, everytime the user minimizes the application and then restores it the
database window displays.

Can someone help me with the below problem:
when I try to read from a ms-access table in VBA all works fine;
when I use exactly the same on a query (with the same content) it goes into
an error:

How do I programatically create a table in an external database, that links
a table in the local database?

My brain froze up on me...
What is the best way to pass a value from a SQL query back to my form?
I am doing a LookUp of a value in a table based on a couple of parameters
passed into the query. THis is a SQL statement passing to SQL server 2k and

I could like to add additional code to track number of invalid password
tries attempted by user. After 3 times log-out automatically.
Private Sub PassWordLookUp_LostFocus()
  'test for blank password

I can not find a simple anwser in the help menu for such a simple task, strange

I currently use the shell command to run a batch file.  Is there a way for
me to integrate the batch file code directly into the vba coding of my db
instead of calling a secondary batch file?
Thanks,

I've MS Office 2003 Enterprise Edition and also MS Access 2003 Developer
Extension. When I am in the code window for MS Access 2003, I dont see
anything in the Add-Ins Manager window. In the previous version of MS Office
(XP), the Add-Ins Manager had around 4 very useful tools ...

Using the API call to open the 'Select File' box, is it possible to accept
multiple file selections?
Cheers,
Steve,

I'm looking for the best way to do the following:
On a form, I have a user enter a beginning and end date (Ex: 1/1/04,
12/31/04) - can be any 12 month period.   Then, I want to use those 12 months
as labels on a report.  Since it can be any 12 month period, I need to

I have a combo box(tech name) with its row souce query2. Query2 pulls
Tech_name; Tech_email; Tech_PhoneNumber from my tech table. I am running this
after update:
Private Sub Technician_AfterUpdate()

I have products in a table with quantity per year:
Product   Territory    Y1        Y2       Y3 ...
TTT            1           10        0          0
TTT            2            0         0          0

Does anybody out there have any VBA code that will allow me to count the
number of records returned by a query?

I've got an NCI 7820 scale.  I'd like to be able to populate the weight field
on my form with the weight from the scale.
The instructions in the scale's manual state:
Transmits weight and scale status whenever

I have an MS Access 2003 application and now I want to be able to start it
up from a vb.net app.  Additionally, the vb.net application will be
validating the user, checking for updated versions of the Access app and if
there are new versions, will prompt the user to download a ...