[mso] ms access questions

  • From: "marvin hunkin" <marvkin@xxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Fri, 1 Apr 2005 09:43:45 +1000

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.

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts:

  • » [mso] ms access questions