What is the best way to only allow active choices in a combobox..
I have a combobox referred to a table that has an end date for the code.  I
want only codes to show that have an end date that is null or > Date()
I have been able to do this but for historic records that used the ...

The newsgroups I need are no longer available, anyone know
why? I need to set the recordsource of a subreport from my
code. I create a string of the SQL but when would I apply
it, how and how do I refer to the subreport?

I would for a user to be able to enter any type of date format and have the
date format to MM/DD/YYYY.  However input masks drive me insane because it
only allows for one preference...
I would like all of the following to format to MM/DD/YYYY:

Access97
I am trying to set a ComboBox Row Source using VBA and cannot work out
the correct syntax.
I wish to list two columns in the combo box thus:

using Access 2000
I have a button on my form that allows me to open C:\My
Documents\MyExcelTemplate.xlt  file.
My question . . how can my access application automatically save the

My Access apps are dated and stale... help! what am I missing?
What third party components are out there for Access developers? A VB .Net
interface blows away an Access UI because the controls are so much more
modern. For example, is there a grid control for Access that is ...

I am getting the following message  when I try to open my form/subform for my
invoices?
Any ideas on what would cause this?
" the expression is typed incorrectly, or it is too complex to be evaluated"

I have a form that I want to show only the date that are in FilterDateStart
and FilterDateEnd.  I have the code below, but I am getting the "error 13:
data mismatch".   What am I doing wrong?
-----start code---------

I want a code for a Command Button to open "Link Tables" Dialog box in ACC
2000.It would be equal to pointing to:
File menu>Get External Data>Import Tables...
Can anyone please help me?Thank you in advance.

My Access 2K to Word 2K mail merge module is:
***********************************************************
Function MergeDoc(varDocName, varQryName)
  Dim objWord As Word.Document

I am using Access 2000 and I have a query that returns only records
where the order is "Open". I have been attempting to open that query in
a recordset, then count the number of records in that recordset, thus
letting me know how many orders are open and in front of the current

I'm trying to requery a form from a macro so that I can add it as an option
to a right-click menu.
when I choose macro option 'requery' i get an error that says i cant use
the applyfilter action on this window. the error suggests using the select

HI there!!!
I am hoping someone can give me an idea on what im trying to achieve.
I have created a form that I wish to use as a search tool.
I have 2 option groups, The 1st has 3 buttons and the 2nd has 2.

Can I copy or save an .xlt (ExcelTemplate) file
as a .xls file

I have a form based on a query that has a paramter, the form has a filter
applied at run time which is applied by an load event. Why is my form
prompting me twice for the query parameter ?