While working on a User-defined RowSourceType function, I noticed two points
of interest.
First of all, the documentation for defining the function lists 9 different
constants that may be passed to the function through Code.  However,

The following code was built with the command wizard & works great, however,
I need to add addtional code to filter with more content.  Currently, when
the command button is clicked, it opens the form based on the Plan and
Product chosen.   The user will also have to choose the ...

I have got an unbound combobox that has a recordsource of a field in a
table, when you select a name from the combobox, it stores that name in a
textbox when you click on a save button. That does fine!
Problem

I have a process_month_year field that I set up in a table as Text-mmyyyy.  
However, now I'm finding out now that it was a bad design because I can't
sort on it.  I do need to display it as a month name on the input form later
down the road.

I have a List Box on one of my forms that fails to show certain records when
an index record is clicked.  It works fine for other records. The data are in
the table for all of the records but this is an application that I have
reused a few times by deleting records from tables.  

The code below generates a "Type Mismatch" error on the last line. Any idea
why?  The filed in the recordset, "Text1" is a text field in the table and
the variable lgNum is dimmed to Long.  What am I misunderstanding about this
process.

I have a form that features a combo box that is filled by a user-defined
RowSourceType function.
Another combobox on the form selects one of four default filters (no filter,
and three filters to restrict the records viewed to one of our three

I use the command
    DoCmd.RumSQL (select * into tempTB from table1)
in VBA.
The command runs fine but only insert 199 items. (tabel1 has 3000 items)

Is there another way to do this?  it seems like a lot of Code!
Thanks
DS
Dim LSun As Date

I have an application in which the user will enter some information regarding
insurance policies held by a client.  The client may have several policies
with different benefits but much of the information will be the same from
policy to policy, i.e. client name, address etc.  ...

I have over 3500 customers in a table attached to my combo box.   The feature
that "auto types" the name is invaluable.  However, I also need the ability
to add new customers into the combo box. I loose the auto type feature when  
I set the "Limit To List" to "No". .  Is there a ...

I have a form with an unbound control, which is used to pass information to
an unbound control on a report.  The form is activated by the Report On Open
event.
Is there a way to "automatically" spell check this control (and any others

I am trying to add many new records at once.
What I need is to enter about 25 invoice numbers at once and thos
invoice numbers are linked to one employee. Is this possible? Pleas
help. Thank you

My form has a combo box that allows the user to select a customer using auto
type.   The combo box is based on a table that has a auto Customer RecordID#
and the CustomerName.  How can I user both the "Auto Type" feature and the
"Limit to List = No" features.   I've tried added a ...

I would like to know how to specify a field's contents in a command button.
I'm using Access 2000 here at work.
I have a field 'Program File Name' that I have the full path name to a file
stored.  I have assed a command button to open up the preferred editor for