[AccessD] microsoft access questions

Hi Marvin

To get sequential numbers you do need an autonumber primary key. If you try
to change the column you already have, I suspect it will fail. You probably
need to add a new primary key field and remove the number field you have
currently.

Once the underlying data is corrected the report should be OK. You may also
find that your referential integrity works once you have a unique key. It
should be noted, however, that cascade deletes are dangerous and best
avoided... Try it and get back to us.

Sorry I can't help you on the software question.

HTH

Roz



-----Original Message-----
From: marvin hunkin [mailto:marvkin at hotmail.com] 
Sent: 01 April 2005 00:52
To: accessd at databaseadvisors.com
Subject: [AccessD] microsoft access questions


hi.
doing a database assignment for my access class.
i am a blind student at my college in australia.
using ms access 2000, windows 2000, and using the jaws screen reading
software and using version 5.10 for more information about jaws for windows
go to http://www.freedomscientific.com now have had several problems. now if
any one can give me some answers on how to fix the problems i am having. 1.
one of my queeries which i built from a table and imported from excel. it
has the primary key field set to number. but instead of giving me sequential
numbers like 1.2,3, it only says 1,1,1, etc. should i try to set the data
type back to autom number? will this fix this problem? also got the same
problem with my report, it just keeps saying the id 1, for each record. it
should say id 2. id3, etc. how do i fix this? 2. when i set up my
relationships to the id fields in my tables in access , and try to tick the
referential integrity, cascade update records, update deleted records, and
try to click on create, it gives me a message saying the database could not
lock the table, or that the data fields are not the same type, as they are
all data type of number, and set to long integer. 3. i created several
reports and sub report in collumna format. how do i resize the report and
sub report using the keyboard? jaws will not let me use the mouse, or reads
very erraticly. is there any third party software that will allow me to
resize reports and sub reports in access 2000? if any one can help me, then
e-mail  me privately off list. cheers Marvin.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------

The contents of this message and any attachments are the property of Donns Solicitors 
and are intended for the confidential use of the named recipient only.  They may be legally
 privileged and should not be communicated to, or relied upon, by any other party without 
our written consent.  If you are not the addressee, please notify us immediately so that we 
can make arrangements for its return.  You should not show this e-mail to any person or
 take copies as you may be committing a criminal or civil offence for which you may be
 liable.  The statement and opinions expressed in this e-mail message are those of the 
writer, and do not necessarily represent that of Donns Solicitors.  Although any files attached
 to this e-mail will have been checked with virus protection software prior to transmission, 
you should carry out your own virus check before opening any attachment.  
Donns Solicitors does not accept any liability for any damage or loss which may be caused 
by software viruses...