I keep getting a 'data-type mismatch' error and I know what it means,
but I don't know why I'm getting it here.  I copied the zip control
directly from the report and they're both pulling from the same table,
so why am I getting this error???

I'd like the query newsgroup to be available and now it
isn't.  Conflicting information is everywhere on the web
and this could serve as a hub for great information
exchange.

Main form - Customers
Subform - Contact History (with appropriate link - all OK).
On subform there is a combo populated from a third table called Contacts.
This has a list of all contacts in a company (linked via CustID).

I'm trying to add a button that find a record in a table and populates text
boxes on the form.  I have a query that sets the criteria equal to the text
I want the record for. My code is:
Dim rst As Recordset

Am trying to put a piece of code into a form load, so if it is not within
another form as a subform, it will display a message and cancel the event.
ie The user has double-clicked the form themselves.
Any idea how to test for this?

I am able to trigger forms opening, macros running etc. based on a "Timer"
function. No Problem.
However,
My users frequently close down the application (Access 2000 running on

I have a subform with an option group in the header.  There is no default for
the group.  I want the user to select one of the choices.  When the user
selects one of the options, the detail section of the subform becomes
visible.  There are several rows in the detail section to ...

I had this compacting routine working for days in my access 2003 program,
then i ran it this morning and got a "you attempted to open a database that
is already opened exclusively by user admin in machine.... (runtime error
3356).  I rebooted machine.   Nothing else is using it, ...

Hello to all.
I am trying to refer to a variable that is declared in the class module from
within an expression for control source.
I would appreciate any suggestions.

Nikos made a few suggestions in a previous post (Search Form with list box
doesn't search) and suggested I post back if they didn't work.  I have a
form/subform that I need the user to click on Find and have a Search Form
open up.  Copied the code from a free download as this is ...

Hi there. I need to find the code to do the following. I don't have much of
an idea... if someone could help that would be fantastic.
OK... onto the nerding.
I have 3 tables of information

Is there a way to put the contents of a (form) field into the clipboard?
I want to stuff a number into the clipboard when I open a form.
Thanks,
John H W

I'm using Access 2003.  I have a report the uses conditional formatting.  In
the right condition the text of a field turns red.
It works fine when viewed in Access.  It also works great when I export to
Snap format.  However, if I export to html the whole column turns red, rather

Does the ItemsSelected property not work if the listbox multi-select is set
to none?
I've been working my way through a problem, off and on for a couple of days.
What I wanted to do was enable/disable a command button based on whether an

I have a main form with a subform.
When a user chooses a option on the main form I would like
to replace the current subreport's form with another form.
Is there a way to do this?