I'm a beginner for Access and I am trying to create an OpenReport command
that when someone clicks on a command button, a pop up box will open and ask
which report to open by product number. I only want one report/form to open
and I also would like to have the question pop up ...

Hi,
Any suggestions on the following would be a great help!
I have an access database, and on one of the forms i have 10 text boxes
(labelled 1-10)  I want to be able to type 1 number into each text box

I'm running into trouble using the special effect feature on my text boxes.  
I recently created a new database and in the creation of my forms realized
that all of the text boxes looked as though they had the "flat" special
effect even though under properties it says that they ...

hey im currently creating a small library system for my college
project, and i need some help and advice.
My tables are;
* PK = Primary Key

I'm designing a form with drop-down list boxes. So let's say I have a field
called 'species' and another called 'sub-species'. If the record's entry in
the 'species' field is 'dog', the user should only be able to choose
'labrador', 'dalmatian', 'dachshund', etc from their ...

We have created a database for a client, and our goal is to make it so
the client can search, run reports, etc., but we want to restrict them
from ever being able to add or modify data.  What is the simplest and
most sure-fire way to accomplish this?

I have been designing a database and I have not backed up in a couple of
days (yeah I know I'm an idiot).  Anyway the main form I have been working
on seems to have gotten corrupt.  I can't open the form in either Form View
or Design View.  I can seem to access the code but I cant ...

Lame question I know, but I accidently set one of my tables to 'hidden'-how
do I un-hide it?

Good day everyone.
It's been a while since i've played in Access, so please bare with me.
I've got this 'text box' where in the 'control source' i have the following
expression:

   My MDB contains price and price1. If it is zero dollars, MDB shows
$0.00. From VB, how do I display all records that are $0.00? Each price and
price1 field is Currency. Using VB6.
       strSQL = "SELECT * FROM Products WHERE price = " ???

I need to filter an Access 2000 result set in ASP 30 using the ADO
recordset.filter.
I build the filter in pieces.  The first clause of the filter is this...
   WHERE  word LIKE 'S%'

This may not be the best forum to post this but thought I'd try it since you
all use Access and are developers ;-).
I have developed in Access for quite a few years and can do basic coding and
some more advanced stuff with the help of you guys! We currently send

After a stupid mistake i have a corrupted database file, error reading "The
database is in an unexpected state..."
After searching the internet i have found various programs that repair the
file but all cost close to $399.  While the database is important its not

Si recibe numerosos mensajes de correo electrónico a diario

Can someone tell me where I Can find a good accounts receivable templete.
Thank you,
Edward Keith