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.