I notice that the Form_Dirty event does not fire in Access 2002 (SP-1) when
the first character is typed into a new record. In previous versions of
Access it does fire.
For existing records that are being edited, the event does fire.

I am having problems getting unicode characters into VB. Using VB6 (sp3) and
Access 2000
Characters are displayed correctly in Access, just when I use ADODB (2.7) to
read them in VB i get ? character instead of unicode characters.

What version of DAO Do I need to use with Access 2000

I know of the Ucase() function to convert a string to uppercase.
Is there a function to convert a string to Title Case (1st letter of each
word capitalized)?
Thank you

Here is my code for the Union query                   "Table [Mytable1]
union Table [Mytable2] union Table [Mytable3];"
The tables are actually queries themselves.
I made a form for the query, but when I try to update the form, I get a

I recently started working in a real estate company and I am having
serious problems on organizing their database, mostly because I had
never "put my hands" on Ms. Access. My problem is the following:
We have lots of addresses of companys and each area of activity is a

Okay, I've got a report that runs perfectly.  Designed originally with the
report wizard and enhanced with about 8 subreports and other stuff.  Works
great.
However, I also now need to have the same report printed to a text file

Hi:  
I am using TreeView in a Microsoft Access 2000 form.  I can create the tree, populate it and select items.  
Now I want to Programmatically select and highlight a node on the tree based upon a value selected elsewhere in the form.  
Can someone explain how to do the above, or ...

I want to be able to enter a  hyperlink into a text box but have access
determine whether it is a  hyperlink and change it to one without the
rest of the text being  changed. I know there is a property HYOERLINK
but I don't want the whole field changed. Any ideas on how I would go

When designing a new form or report, the Default ForeColor is often
something like -2147483640 which is the colour of Windows text (possibly
black) and the default backColor is  -2147483643 (possibly white)
Can anyone tell me how to convert these colours to either RGB colours or ...

Probably the answer is there just in front of me only awaiting me to
discover it,
but:
1: I want to build a query that returns all records in one table for which

Hallo zusammen,
ich habe folgendes Problem:
Ich habe ein Formular in dem ein Gesamtwert in einem Feld errechnet
wird. Jetzt möchte ich diesen Gesamtwert automatisch in ein anderes

I am trying to build a form that has certain criteria on it (combo
boxes) which a user can pick from a range of values to specify the
criteria he wants when he runs a query on the form.  I am trying out
different ways to do this, but nothing is working.  Does anyone know