I can't get the DblClick event to fire. I've tried in on a couple of
different forms with bound & unbound controls (no header or footer),
double-clicking all over the place. Is there a flag that needs to be enabled,
somewhere?

Group:
I have a form that requests the user to enter the company name. However, if
the user enters a period ( . ) in the company name, I want to take it out. I
have developed the following code to take out the period, but it inserts a

I am trying to count the # of each different wine shown in my report so I
can use it in a formula to show the % of each wine in the report.  I used the
regular count funtion on one that I only had 2 values I was looking for and
it worked great; however, it will not work of the ...

i deed to make a database it can comunicate with a magtek micr reader i need
help.

I need help to create profile in access 2003 and access 207.
Is it possibel somebody give me an example?
Thanks

the listbox on Form 1 has 5 options (populated from a table.)  The choice is
used in filtering the second form and setting value of a textbox and it works
fine for all possible choices.
Additionally, if the choice is "instrument" I want to display additional

I have an Access 2003 database which I have been using for over 5 years. The
AutoNumber being used as the Primary Key in one of my tables is now 88537 and
is increasing as I add more data. Is there a limit on how high this
AutoNumber can go? Occasionally I delete old information ...

Trying to merge multiple records to multiple tables. No problem with single
record using bookmarks, but looking for ideas on least painful method to use
multiple tables (3 per page) to show multiple access records.

Hi, I need to add a constant to a user defined number entered in a textbox
using an on enter event.  Then I need to dump that sum into a table to which
the form is attached.  I guess my real question is how do I work with the
entered value from the text box in a private sub? And ...

Does anyone know where it is located?
By using F1 doesn't show any hint.
I have searched for a GRAPH12.CHM but I didn't found it.
How can I get help about coding MS Graph in Office 2007?

I have one table called "Providers" and another called "User preferences."
When I split the DB, they went to the backend, and the software calls the
last used Provider to be the one that populates the front end data on a
couple forms.

Hola
I changed recently to Access 2007 and the above reference do not come with
the program.  I got one copy (ver.6.0.8169 dated 18jun'98) from a friend but
after instalation as reference do not work.

Is there a way for me to capture the execution status of DoCmd.RunSQL ? I
want to trap the execution status to handle it appropriately.
Thanks in advance.

I am using Access 2000
I have a form (Prospects) with a Tab Control (Tabctl21) and some text box
controls on a Tab called "Add Prospects", Page Index =1. I'm trying to turn
Enable Property off on these controls using on Change event procedure. I cant

Good afternoon...
I am not seeing my error on this one...this should be easy.
i have a listbox in a form, and i want to clear it.  but the total number of
items can change.  so i tried this code: