[AccessD] Re: microsoft access questions

Marvin,

Last year I rolled out a database in Texas.  When I got to the last machine, 
I was introduced to JAWS.  I spent the next 2 days and nights modifying 
every piece of functionality that required the mouse.  It was very 
challenging with the 2 day deadline, but I learned a lot of lessons on that 
project.

I believe Robert and Roz answered you questions.  I just wanted to comment 
on the JAWS program.  I've never developed a db using JAWS, just developed 
one for someone using JAWS.  If you get caught up in any 
functionality/usability issues with the forms of your app, I'd be happy to 
share some of the tricks I learned.

Good luck with your database assignment.

Mark A. Matte



>From: "Robert L. Stewart" <rl_stewart at highstream.net>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: marvkin at hotmail.com
>CC: accessd at databaseadvisors.com
>Subject: [AccessD] Re: microsoft access questions
>Date: Fri, 01 Apr 2005 07:36:23 -0600
>
>Marvin,
>
>1.  If it is a primary key, then it will not allow a 1 multiple times.  
>Just add a column and make it an autonumber data type, remove the current 
>column, then rename the new column to be the same as the column you 
>removed.
>
>2.  Why are you trying to "trick" referential integrity?  Your 
>relationships a not correct according to data type, or you would not get 
>the error you are getting.  My guess is that you also do not really have 
>primary keys establishes, reference number 1 above.  And you cannot cascade 
>or update with out a true primary key.
>
>3.  Shift and the arrow keys.
>
>Robert
>
>At 12:08 AM 4/1/2005 -0600, you wrote:
>>Date: Fri, 1 Apr 2005 09:51:36 +1000
>>From: "marvin hunkin" <marvkin at hotmail.com>
>>Subject: [AccessD] microsoft access questions
>>To: <accessd at databaseadvisors.com>
>>Message-ID: <BAY102-DAV15EE448AA3D6BF3D9798E3AB470 at phx.gbl>
>>
>>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