I am very new to Access.  I have created a database in Access 2003.  I
can enter the required record fields from a form.  I would like to add
a feature that allows a user to update the "quantity" field (it is type
long integer).  The update would be to add or subtract a user-entered

all..
this group is amazing.. have been getting lot of answers without asking
from this forum.. got a couple of questions..
first the background

I recently built a database and have created a form for data
review/entry pulling from a query.  My problem is that I currently
cannot change anything in any of the fields.  I can tab through the
fields, click into the fields, but cannot make any changes to them.

    I have scoured through a million messages (ok...thats a bit
exaggerated) but I just cannot figure out how to display null values in
a query. I have tried Nz, IIF, Count(*) but it just does not work. I
hope someone can help me with this. Here are the details:

I'm trying to limit the number of records that can have a checkbox
clicked. I created a query that counts the number of records with that
checkbox clicked and tried to make a form validation expression "(Count
total of field) <= (maximum number of records permitted to have this

I'd appreciate if you could help me to perform the following
calculations:
I Begin with two Tables:
Table1

I need a way of bypassing the Report_Close procedure (or come up with
another event to handle the Update Query.)  Right now, if I set the
value of Report_NoData to Cancel=True, the Report_Close event fires,
and the message prompt is not applicable.

Thank you so much in advance to those who will take the time to read
and answer.  This group is a wonderful site.
I have inherited a contacts database that sits on a server.  Users
logon to the server and have access to the front-end of this split

I've seen a number of posts concerning the above type of conversion but
have not been able to locate anything that gives a clear set of
instructions to accomplish this.
Here is my problem, I have an application to be converted from access

Hello to everyone out there. I may be out of the newgroup in this matter but
would like someone to provide me some suggestion.
I have a DB that runs on  SQL2K, and reports created using crystal reports
8.5 running in Crystal enterprise.

I'm fairly new to VB programming and I've been going round the bend
with this problem, so any nudges or shoves in the right direction would
be greatly appreciated.
I have a template form in Word. The information that I need to populate

I want to export DDL of an existing Database Microsoft Access 2002. I
could write a routine that navigate into the TableDef of the DB. Exist
something snippet code that do this?
thanks

I have a form where I select a business and I need to send a report to
a person who is tied to that business in one of my tables.  How can I
use a command button that is tied to a macro to Send a report to the
specified person?

I have created a Table that has 13 fields and 2 Primary Keys, e.g. 60  1, 60
2, ... 60 28,
61 1, 61 2, ... 61 28, etc...
I want to create a Form where I can input the Primary Key values to query

Is it possible to convert a snalshot to pdf ?
How ?