I have a form with a combo box that is based on a table of premade
'comments'. If a user has another 'comment' to add that is not on the list. I
want them to be able to add it to the table. How can I have them just check a
box that will copy the contents of the text box into a ...

When I built my database 6 months or so ago, I set something in my form
(can't remember what) so that existing records in the underlying table were
hidden and not visible to the data entry person.  The only records visible in
the form are the ones the data entry person enters ...

On one workstation, Access won't get past certain lines in an app, like
Set dbs = CurrentDB
Or
If Me. RecordsetClone.Recordset = 0 then

I know I can export data to a text file.
Is it also possible to open up notepad and paste a chunk of text into it?
Jesper

My main form uses one table, my subform uses another.  They are not linked.  
How do I write code for the main form that advances to the next record in the
subform table?  Thanks.

I am developing a project (Access 2002) that will ultimately have to be
compiled into an EXE file, which people who do not have Access will be able
to run. Please point me to the necessary information for me to read up on
how-to. In addition, any specific info you might have ...

Any idea to implement multi-threading in access?

I have created a main form and added two subforms.  I have linked form1 to
the main form using the Master Fields/Child Fields links.  On form2 i wish to
have the user enter information in existing fields (not adding records).  I
have linked form2 to form1 on common fields.  I am ...

I've got 2 subforms on another form.  Each one of them is displaying
the same data from a query.  I am using two subforms so I can see
adjacent records in a table, and then do some math calculations with
them.  Can I manipulate these sub-forms somehow so that when I advance

In Access 2000, I have a form containing a subform.  There is a button in
the main form which needs firstly to get the id of the selected record in
the subform.
Under certain conditions, it looks like no record is selected in the

I'm using now At Your Survey by Duane to make a survey. I want to
create a form with some list boxes to choose, one list for the
indicators and one for the respondents. The indicator will be the
SELECT parameter and respondent the WHERE parameter.

I'm seeing something strange with the .Count property of a multiselect list
box in Access 2000.  When I first open the form and use the following
statement:
   If Me.lstQuoteComponent.ItemsSelected.Count = 0 Then

Is it possible to use the "Like" function in an expression for a
conditional formatting rule.
e.g.
Like "*" & [Forms]![myform].[myfield] & "*"

I have a currency feild which captures amount in standart format ..(4,55.50$)
I want the format to be converted into alpabets when pressed tab and goes in
another field e.g Four Hundred Fifty Five Dollors and 50 cents only
plz help

I have an Access form that when I click the update button it starts a series
of queries one of which is an update query that has an iif statment with a
custom function. When I run the code and set the warnings to false I get the
MaxLocksPerFile error and the database will no ...