I have a subform, sfrmMktData, that is requeried in the Current event of the
main form:
Me!sfrmMktData.Form.Requery
But when the form opens, the subform has not been requeried. Shift + F9

When a subform loads, it runs a module using the system date.  It has worked
without flaw for several years.  Now it fails.  I discover that one of my
"available references" is missing: "DatePicker ActiveX Control module" in
C:\Novell\Groupwise\GWDPK.OCX!  The university recently ...

I know that I can pass a variable's value to a query by using the following
construct:
...
WHERE [TableName].[ColumnName]=[Forms]![FormName].[ControlName]

it possible to work with two recordsets?  I keep getting the error message
"Object variable or With block variable not set" for the variables strCtl2
and strCtl3 but not strCtl1..... they appear to me to be set.  One of you
Access lords will probably spot the problem in the code ...

i m running my Inventory system in MS Access Database. now i want Add 1
button in Database which opens my desired MS Excel file. i want to know any
Event procedure or Macro.

Hey Guys.
I was wondering if someone could help me. I am trying to automate an access
db that cleans data, runs a bunch of queries, and  then exports it to an
excel file.

I am trying to write a VB script that will go through several fields and
columns and update the appropriate information. I have columns like building
name, dollar amount, beginning year, end year, and also columns for years
1960-2005. Essentially, I am tracking the value of an ...

I used the following code to export an Access query to a formatted Excel
spreadsheet:
   DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, stFilename, False
It works fine except that the name of the spreadsheet is set to the name of

I have a data dictionary file with field types and lengths which is meant to be
used for programmatically creating a table.  In this file the definitions for
numeric fields specify the total number of digits and also the number of digits
to the right of the decimal separator.  I ...

I'm running a Make Table Query and I want to delete the table (created
by this query) after I extract the data. This is because I call the
requery function and it gives me an error saying "the table is already
in use by another process".  Then it points to the command that I gave

Hi, I am very new to access, so please bear with me.  I have an order entry
form with a combo box for customer ID.  It displays the company name, but it
is the custID that is bound to the table.  What I want to do, is double click
on this field to open up the customer maintenance ...

I have an access application that runs in different computers, some of them
with higher screen resolution that the one Access Application was designed
for.
Is there a easy way to "adapt" the application to the different screen

I'm opening a table and deleting all the records (about 120.000 rows) using
the following:
Dim db As DAO.Database, mytable As DAO.Recordset
   Set db = CurrentDb()

is there a method for exporting a Ms Access table to XML and ftp to a
preassigned location.

hi I would like to know how to achive two things.....
I have a client/sales based database i would like to:-
a.  Email the client from access to outlook with the To fiel
automatically filling in from the email address field on the databas