I would like my users to be able to enter STARTDATE and leave the
ENDDATE open in the query by form that I have built. Using some code
from another group post I have this within my SQL statement:
strMySQL = strMySQL & "And ((Forms.frmMainSearch.STARTDATE Is Null) Or

when the specific mdb file be opend, i want to open maximize the aceess
db. and  maximizebox is disabled.

If I place a database on Sharepoint can users run the database from
Sharepoint ?  Unfortunately when some of my users access are overseas.
Thus, I thought Sharepoint may be a solution.

I have a form with a subform where the subform uses the value from a
combo box on the main form as a query criteria. I don't want the
subform to update or get data before the user has selected a value in
the combo box because the subquery takes a while to update. Is it

 I'm using MS Access to query against Oracle DB via ODBC. Is it
possible to use HINT in Access?
Thanks,
Wei

I have a button that runs 2 reports.  If there is no data on the
report, I use the No Data event, and tell the user, and Cancel the
execution of that report.
However, if the first report has no data, the second report doesn't

I have a Continuous Form based on the following table:
sku, description, categoryId, subCategoryId
I restrict the initial dataset to include one value for categoryId, but
it may include differing valuse for subCategoryId.  The user needs to

Hey there,
I am trying to import an excel spreadsheet using the code below.  Every
time it gives me a "cannot locate object" error.
Does anyone know what I am doing wrong?

I'm having a problem with a form that uses AutoNumber as the primary
key.  I have an Abort button to delete the current record and close the
form.  If AutoNumber is assigned, the code executes a SQL statement
that deletes the current record.  I need to be able to detect when

I am just getting started with VBA and I'd appreciate any help anyone
can offer here. I am trying to use VBA to look through the "Curr Year"
column in table "tblYear" and check whether the value "2006" is in any
of the fields for that column. Here's the code I have so far...

So I've had my knuckles rapped by a pro who can offer only vauge
advice. I need to reduce the size of one of my tables.
Here is the scene:
I'm trying to track lots of test scores for individual middle school

Ok, I am pretty new to Access (Using Access 2002 at my job).  Here is
what I want to do.
I want to create a database that has a form.  On this form will be a
dropdown menu (combobox).  Depending on what you select in the first

I have a form (View All Assets) with two combo boxes (ComboManufacturer
& ComboProductType) and a subform with a dataview that displays the
results of my query below:
SELECT Assets.[RDC Asset Number], Assets.

I am using access 2000 and need to send reports via email, the reports
contain sensitive data and i would like to be able to password protect
the attachment in the email. Preferable format for the output would be
RTF.

I've got a code sample below from a report from a computer database
that I have built with a printer subtable, which in turn generates a
printer subreport that I'm trying to put on its own page (one page has
hardware, one has software, one if necessary has the printers...not