[AccessD] microsoft access questions

marvin hunkin marvkin at hotmail.com
Thu Mar 31 17:51:36 CST 2005


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.




More information about the AccessD mailing list