I've got a table with about 20 fields in it.  One of them is "Analysis
Type".  There are 6 different types to choose from.  I've already got
a form in my self-created switchboard that has 6 command buttons of
each analysis type, enabling the user to choose.  From there, I'd like

Hi.  I have a text box on a form that is not editable by the user.  It
displays an automated number from the associated table.  It's shaded so the
user gets the hint that it's not enterable or editable.  However, it is
enterable if you click on it.  It also becomes unshaded when ...

I was able to do the code to get my pictures to show up on a form, but I get
an error message if there is no picture availabe.  How can I avoid this?  
Here's the code:
Option Explicit

I am attempting to add photos to a table in a Access 2003 database operating
under Vista Home Premium. In the past never had any success using OLE and was
forces to use Picture It (not an option now).  I also receive the not license
to use ActiveX message.

Recently I have created a new database (datasheet) which contained a list of
defined fields I have program it before.  Following that I have created a new
FORM using FORM (TOOLS) it has replicated all my originated fields as well
as, my data input field..no problem at all.

I have a report that will be printed out monthly.  I would like it so that
when the you open the report, it prompts the individual to enter his name and
the date that he/she would like printed on the report.  How can I do this?

I have an email with a large attached file on it and it will not delete. I`ve
tried to move it and still NO good

I want to install an activeX control on a form but it is asking me to
register the control.  Is there a default location for the file?
Thanks

I have an Access database that extracts information from a SQL database
through stored procedures and runs a report.  I would like giving the end
users the option to cancel the extraction process.  I have tried putting a
"CANCEL" on the form where they select the criteria for the ...

I'm just wanting to findout if it would be possible to design an online
bookstore like amazon.com or kalahari.net using Access 2003?  If yes, any
ideas where i can get info on creating something like this?
Any help is greatly appreciated.

I know how to use the "strconv" command to change case for a particular field
with an Update query.  Is there a way you can select all the fields and
change the case to all fields in a single Update Quey?
Thanks for any help

I need to input a default value for a text box in a form but is there any way
that I can put the default value so that certain things appear on seperate
lines within the text box - as follows...
Lives with

Is there a way to ensure that a user can NOT delete a Table, Query, FOrm etc
from the Database Window when they use the application?
I know some users have deleted all manner of files and folders from the
server but I want to ensure they do not bugger up my Access Application by

Let me preface this by saying I am not very savy in Access.  Someone
crateated an Access database for me in 2000.  It has worked well for me until
we recently upgraded to office2003.  When we converted, a page count field no
longer worked correctly. It gives the result "#Name?".  ...

ok here goes. when running this querry on data that is formated as
double, and includes positive and negative numbers with 3-4 decimal
places i get a divide by zero error. can anyone recreate this or have
any suggestions on how to work around it?