I have a form that's importing files from excel into access. I need to create
a drop down menu linked to a cetain folder on a network drive that users can
pick from to import to access. I need it not to be static so it updates when
files are copied or deleted from the folder. How ...

Hi guys,
I have a combo box on form1 in which I will type Client ID to search for
that client information on form2.
For example in combo0 i type Client ID is : Lopez0001  (form1)

Is there an expression to collate text in a SubForm column in the same way
that there is an expression to total numbers or count the records? If so,
please enlighten me. It will save days of collating. Thanks.

I have a form where the user chooses a certain site from the first combo box.
I want the second combo box to then be populated with only the fields that
have values associated with that first field.
To be specific, the first field is a list of field sites (site_no).  The

Problem Re-initializing order/entry form/Subform
I have an order/entry type form/subform, which is not re-initializing
properly. The form consists of a
form header, into which a patient name is inserted in control 'Select

I want to create a query that returns total sales grouped on a weekly basis.
This isn't hard for monthly by just grouping on the month.
Ideally I want to define what constitutes the week (Mon - Sun, or Thu - Wed
etc...) and then return total daily sales for each.

As I program my forms I used to rely a lot on the step-by-step debugging (F8
key). For some reason, I can get it to work here.
When I press F8 I get a dumb tone and nothing happens.
When I place my cursor somewhere in the sub and use the  CTRL-F8 key, still

I am utilizing Allen Brownes' search form to find a record which
happens as it should. Once found, I now want to double click a field
IDNUM to open up a single form to edit existing data matching that
IDNUM field.

I have a listbox which whose datasource is a table with 52 records - one for
each week in the fiscal year. The form's OnOpen event triggers a procedure
which caculates the week # of the current date and selects that value in the
listbox. If the listbox's Multi Select property is ...

How do I place the text "Select Criteria Here" (or some smilar
message) in a combobox that has a sql statement as a row source and
limit to list is on/true?

I have a form, that I'd like the user to filter, then use a "Check All"
Button to select all the records that are filtered. I can't use an update
query like I know how to do, because it is filtered.
I thought about a do...until statement. But I don't know where to start with

I have a continuous subform called [Annual].  Each record has a [due date]
(to be calculated) and a [completion date] (entered manually).  There is a
base field called [Intake Date].  I need the first record's [due date] to be
calculated as 45 days after the [Intake Date].  From ...

At my worksite, they are deploying MS Access 2003 on all desktop
workstations, replacing Access 2002. This is because they're moving to
Exchange 2007, which requires Office 2003 at a minimum. Fine.
We have some applications to do a Mail-merge with Word docs, then auto-send

How do I setup a calendar control (activeX Calendar Control 11.0) to
be displayed as 1 line of combo boxes with a drop down arrow that
expands the entire control?

Hello.  This might be a simple matter to do but I am not that familiar with
it.  I have a textbox that is bound to a memo field so the user can type
notes into it.  This is on a continuous form and it would look/work better if
the textbox (memo field) is only one line in height.  ...