[AccessD] Re: microsoft access questions

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.