The report indicated in the send object command below has various
colours in it which show nicely when the report is previewed and
printed.  However, when sent as an attachment to users without Access as
per the statement below, no colours are displyed:

It has been mentioned that a ghosted machine or a machine linked
by cable modem and USB may result in my reading a MAC address
other than one burned onto a NIC in the machine. That being the
case, I would have a problem.

I would like to know if all MAC addresses
are expressed as 48-bit numbers, IE, they
contain 12 HEX digits?

I am concerned.
I have recently moved to A97 from Access 2.0 where I rolled out
runtime apps with the ADT. Now, the Office Pro Developer's
Edition with Access 97 is what I'm using. I find some unfriendly

What is the meaning of this error?
Operation Must Use An Updateable Query
???

I am scratching my head with the required quotes and parentheses.
I started with an existing working Query with Running Total
by date.
Now I need to produce a running total by quarter day, so I converted my

I'm running Server 2003 and wonder how well WTS works when printing an
Access report to a client.  Any suggestions would be appreciated.
Thanks.
IC

I have James Isle Mercanti's barcode39.mdb. With this i can print a
barcode in a report but i would like to see it in a form.  Is that
possible with his code? And what code do i need?
TX anyone, anywhere, anyhow

MyLocPhone: Format$([LocPhone],"(@@@) @@@-@@@@")
The above expression is a field in a select query. On one XP box
(the dev box, of course). It works fine. On two other XP boxen -
it fails saying "Function isn't available in expressions in query

I was wondering if it is possible to create simple queries with the
data included in the select statement, similar to how you use the word
VALUES (x1,x2,...) in in INSERT statement.
The reason I want to do this is for simple graphs. For example, a pie

I am working with MS-Access 2002. The two tables that I am working with
are:
dbo_IDX_FRS_account_bal_by_month ==> this is a linked table to SQL
[Select FY_06 to-date] == local table

I have created an A97 runtime distribution for the first time in my
life this morning. I had precious little time to do it and was unable
to create the distributable installation fileset with the option of it
creating a shortcut for me.

A97: If I create a new user with CreateUser Method, is she
automatically a member of Users group? Or, do I have to
append her to that group?

What's the simplest way to allow a user
of an A97 app to change password?

The following lines are running when I open my A97 mde file...
If CurrentUser() <> "mlh" Then
   Application.SetOption "Show ToolTips", False
   Application.SetOption "Key Assignment Macro", "NonExistent"