I have an object-field referring to a Word document showing in a field.
On a form I show theese documents according to an empoyeeID.
When I doubleclick in the object field, I get the possibility to edit the
document.

I have a TextBox & I want to set its Validation Rule to check if the 1st 2
characters are = "CC" & if so to then display a message otherwise do nothing.
I know you can use LEFT function to get the 1st 2 characters, but what is
the syntax to enter in the Validation Rule Property ?

I am designing forms (all of which are based from the same table) based from
a questionnaire and am trying to implement skip patterns for certain fields
that are set up as option groups (1=Yes; 2=No). What I want to do is when
those particular fields equal 'No', I want the focus ...

Is there a way to make these buttons a different color other than grey? I
don't believe there is a way, but if there is, that would be greatly
appreciated.
Thanks!

MS Access 2K, Windows XP
=====================
Hi,
The database I'm working with has forms with the tab pages displayed in 2

I have a dilemma I hope someone can help me with.  I have an access db that
uses the "DoCmd.TransferText acImportDelim" to import a delimited file
"Contacts.txt" into the db as "table1".  I modified "table1" by inserting new
fields into the table because the  delimited data file ...

This is a problem I've been wrestling with for a while now, & it comes up again:
Its where I can make calculations in unbound text boxes on a form work, but if they are
bound to a table then I loose the calculations in the record source to the table field,
eg:

I have a database that has evolved and is currently Access 2002.  Quite a few
forms, tables etc and I wanted to try splitting it since we have multiple
users over the network.  I did the following steps:
- Open the database and do a compact/repair to make sure

I’m looking for the most efficient way to allow only form or one report open
at a time. For example, in a database which has three forms: If the user
tries to open FormC, a function(?) checks to see if FormA or FormB are open
and, if so, closes the open form and then opens FormC. ...

Using VBA I want to change the visibility property of a page on a tab control
on a form. (access 2000)

I am trying to find out if a value exist from a different table and if it
does warn the user.
I have a combobox that gets its value list from a query that orginates from
another combobox's selection(group values).

I have a form and on it a Subform.  In the subform i have tabs to break up
the information.  That is all working fine.  I have added a button on the
subform to add a new record to the database.  The problem is when the button
is clicked a new record is created BUT the tab switchs ...

This is killing me. I call a print selector form from another form and place
the calling form name and other information. Everything works fine except
when I try to put together and string to find a value of a field on a form I
get the form text. Here is a portion of the code.

Is there a way to populate a textbox by what a user picks from a combo box?
I have a combobox that uses a query that is filtered from another combobox.
What I am wanting to do is if a user selects something that is from the list
of the combobox, populate a few textboxes based off ...

It there a easy way to display a vider clip or a Movie clip on an access form.
Any help would greatly be appreciated.
Thanks in advance