Trying to Export items from a Query "CalenderExport Q" (See Query Below) that
uses imputs from a combo box in a form.  Using a function to export the
records to Outlook - However, When it gets to Set rst =
oDataBase.OpenRecordset("CalendarExport Q"), it gives me an error "Too Few ...

Is there a way to populate a subform with an ADODB recordset? When the
recordsource is set this way, the Access linking feature (master to child)
doesn't work. I presume I will have to pass a key value on opening the main
form. Is that what others have done (or just avoided the ...

I have an Access database and a C++ application (module developed with
managed extensions for C++ indeed).  
I can get all tables from database using SQLTable function (ODBC API). But
SQLPrimaryKeys function doesn`t work.

I'm looking for some feedback with regard to taking some data from an Excel
Workbook we use to track info on and loading it into Access AS QUICKLY AS
possible.  Once it's in Access I can do the rest, but I am sort of new at the
best method to automate the movement from Excel to ...

I have a report in my MS Access application that I would like to attach to
an e'mail and send to others.  
To do this manually, I preview the report, right click and select Export.  
Then save as an RTF file and attach to an e'mail.  I need to automate this so

I'm having a problem with access 2000 on my system.  I have uninstalled and
reinstalled it several times and occasionally the problem is fixed for a
short time and then reoccurs.  I have code that runs at my clients and on my
laptop and was running perfectly on my desktop but now ...

Is there a way to call up the Global Address List from within Access? I want
to incorporate the search function of the Global Address List to help
populate a drop down to select USERID from within an Access form.
On the db form the user would type in the first few letters of the ...

Trying to Export items from a Query "CalenderExport Q" (See Query Below) that
uses imputs from a combo box in a form.  Using a function to export the
records to Outlook - However, When it gets to Set rst =
oDataBase.OpenRecordset("CalendarExport Q"), it gives me an error "Too Few ...

I have the following code
   Dim ObjOutlook As Outlook.Application
   Dim ObjCtl As Office.CommandBarControl
   Dim ObjPop As Office.CommandBarPopup

How can all the queries, forms, reports and modules be programatically
deleted from an external database?
Thanks!

dear mvp's
I need your help to give a sample code for the following situation, As i
have tried other ways i can't get it.
this is my table structure (For eaxmple)

Good afternoon all,
I have a dB that I am working on that a user can submit a request to add
something to a table that is used as a record source.  Once the user hits
submit, it sends out an email to a group mail box to tell managers what has

have a table with three fields: Parcel,date of sale, and most recent.
Want to cycle thru records, and flag the most recent sale for a single
parcel id.
Know logically how to do how I'd do it... but need advice on best way to

I am trying to populate a form with an ADODB recordset using code supplied
here:
http://support.microsoft.com/?kbid=281998
but I get an error "operation is not allowed when object is open" when

I am trying to set up a table of application settings which would allow the
user to set certain values. At the moment I am working on setting up the
application name. I know that the user can set an application name using the
standard Access Options, but in addition, I want the ...