Here's the name I want to use:
Authorizing_Entity_Label
Each time I attempt to change the
name, A97 changes my entry to

I have an unbound RTF2 control in an Access 2003 form which I set to
show either unformatted text or else text with words and sentences
highlighted. I do this by setting the PlainText property, getting back
the rtfText and then adding the highlighting strings and resetting

When I paste several rows into datasheet view in MS Access, does this
trigger a single INSERT with all the rows, or is it counted as one
INSERT statement per row?
Vegard

My son is trying to create an about form button for a form he has
already created. Any help would be great. Thanks

I am trying to get a parameter query to show me multiple survey #'s
or if I click on OK to show me all of the survey #'s.  I have tried:
Instr([Enter Survey#: use commas 1, 2, 3],[Survey#]),.  "> 0 or Is
Null" is in the criteria

Hi guys, i have a little problem and was wandering if anyone can help.
I just need my query modified a little bit to allow some extra values
in there...
Tables:

I've searched for this and haven't found the answer yet, so here
goes. I'm using multiple versions of Access, all 2000 or later. Is
there a command line switch that will produce the same result as
opening the file in Windows while holding down the bypass (shift) key?

Hi, the script below worked until a few weeks ago.  The only change
that we know of were security changes such as deleting an administrator
account under which the file was originally created.  Does anyone know
if security issues would make this script below fail and/or how this

Lo each,
I want to make a text file containing all of Access
intrinsic constant names and their decimal values for A2k to
A2k3.

Hello, i have the folllowing error in my form, appearing
from time to time: run-time error 2108. You have to save the field
before executing the action/method GoToControl.
When i click debug, i go to the procedure:

I am using Access 2000.
One table in my database has a field called RankName.
Values inlcude: Officer, Sergeant, Lieutenant.
I need create a report that groups these three RankNames into two

Has anyone had this problem ?
I am using MySQL ODBC 3.51 Driver, with MS Access 2003 and MySQL 4.1.11
standard log.
I created my tables in MS Access, then exported them via ODBC to an

i have a continuous form that conains data about a product
i have the product price and the quantity available
i have the calculated the total value for each product (textbox total)
i now want to sum all the totals to give me a overall stock value

i created a calendar using the active xcontrols from the tools menu.I
want the back color of the box containing the date to change based on
the value of a field in the table at that specific date. I realise now
that you cannot change the format of individual dates in the calendar,

I was wondering if you can create a code template for Access?  I would like
to have my error handling code inserted into each new function / sub, is this
possible?
TIA,