I am trying to hide a form from withing itself.
I tried me.hide and it doesn't exist.
I also tried:
Dim f As Form

I have a main form with a subform in it. A user selects an item from a
combobox on the main form which triggers the subform to display records
based on that selected. This I have in the AfterUpdate event of the
combobox. I am trying to add a check box to the subform at runtime that

I have a text box on my for named "TextJO".  I'm using it to search for
either a Job order number or the tracking number.  The Job order number has a
hyphen so I'm using it as text field.  But when I enter a job number or a
tracking no, it does nothing.  Here's my code.

Is it possible to find the recordcount of a recordset that contains a
specific field.  I mean if a recordset lists multiple records for 5
different invoices can I, through code, get the number of records for
invoice number 2?

Hi Folks, got a strange one here!
I have a combo box that works great on my dev PC but on several clients
machines 'occasionally lists only partial data. After several closing and
opening of the form the combo shows all records again.

Is there a way to name a textbox in a subform in datasheet view?
I am trying to use the same form and subform to view different tables. I can
set the recordsource for the subform, and I can set the textbox's
controlsource, but what I cant do is to name the textbox. Is there a way? ...

Is it possible to highlight a particular row in a combo list, say, in a
different font color or in bold, based on the value of one of the columns in
each row returned from a query. So if a combo list is based on a query which
returns 3 values per row as below :-

I have a form with the following code:
**********************
Private Sub Form_BeforeInsert(Cancel As Integer)
   Dim mTable As String, mField As String, mYearPart As Long, mNextNumber

I have a form for which the user will choose a particular plan (cmbPlan) then
based on that plan choice the user will choose a product choice (cmbProduct).
Once the the user makes these choices, the next choice will be either to
choose a command button for Current Rates, ...

I have a search form that is based on a query, and after I place the search
criteria in the search form access opens the form, then when I close the form
it gives me the following message:  Microsoft Access Can't find the
'FRM_Search_Criteria' referred to in a macro expression or ...

When I export a report into word all of the format is lost.  I know that I
can make a pdf file of a report.  But I want to make a word document to be
able to e-mail a form to be filled out and e-mailed back.  When I export it
to word I loose all the formating such as; lines, ...

On my form I have a combo box which lists employees.
I have set the Double Click event of the combo box to open the Employee form
providing the ability to add an employee if it does not appear in the list.
I currently have the Employee form opening to a new record.

I would like to add a button to an Access 2000 form with the VBA code behind
it to import a table from another Access 2000 database.  My plan is to use
this to import a data table from a previous version of the application when a
new version is installed.

Hi;
I have a text file prepared by this code:
Open [FilePathAndName.txt] for Output As #1
Print #1,[something]

A form containing details of a training course contains a text box with
a comma-separated list of types of attendee the course would be
suitable for. This list is derived from a table of courses/attendee
types. All of this is working properly.