[jawsscripts] Re: Creating accessible forms to manage databases in Microsoft Office 2007
- From: Luciano de Souza <luchyanus@xxxxxxxxx>
- To: jawsscripts@xxxxxxxxxxxxx
- Date: Mon, 24 Jan 2011 23:06:45 -0200
But, in this case, users won't be able to edit the form. I want to
create the database, link controls to events, however, I am aware I
can't define the correct layout. For this reason, after creating forms,
I would like a sighted people, with mouse, format the form. If I use
Visual Basic or C++, I will find two big dificulties:
1. Since the form was not created in Access Interface and aditional
tools won't be installed, they won't be able to edit forms to adjust the
layout.
2. Even if I use Visual Basic or C++, because it's not possible to
justify additional instalations in work environment, I should do
everything at home.
A long time ago, I asked in a group if it would be possible to create
all the form elements only coding. The answer was: "Yes, all the
elements can be created by means of VBA. For each control, I should to
define size, distance from top, lef and other attributes. This could be
a solution. However, I found a problem. Creating forms by code, it was
impossible to edit then. On the form designer, only controls not created
by code appears.
The problem is the tool. I could design the database with Sqlite and
Lua, features I know, but the database, the single available tool is
Microsoft Access 2007. It's a severe limitation and if I need another
tools the quantity of explanations and arguments, certainly it would
become the idea completely unthinkable. The development area will never
allow non standard tools.
I have never known anyone who understood the data access pages. This
feature seems to be really unknown. But, among all my attemps, I
believe, with data access pages, I reach the best results. With Notepad,
I created an HTML file. I created inside Microsoft Access, a data access
page. When I opened again the HTML file, several Activex controls were
inserted. ActiveX controls seem to be everything I need. If I could link
controls to events in Access interface, ActiveX definitions were placed
in HTML, attributing callbacks to buttons, lists and everything else.
if I could install any additional tool, I could create a web interface
for an application developed in PHP, Python, PERL, Java, C#, Lua, etc.
the problem is: I need to create my database only using Microsoft Office.
I made big efforts to use Microsoft Access, but until now, JAWS didn't
give me a good answer.
On 24-01-2011 20:58, Bryan Schulz wrote:
hi,
for free you can download and try visual basic or c++ 2008 or 2010.
you can design forms and use access on the back end.
Bryan Schulz
----- Original Message -----
From: "Graham Trevor"<grahamtrevor@xxxxxxxxxxx>
To:<jawsscripts@xxxxxxxxxxxxx>
Sent: Monday, January 24, 2011 1:25 PM
Subject: [jawsscripts] Re: Creating accessible forms to manage databases in
Microsoft Office 2007
> Hi Luciano,
>
> Two things to try.
>
> 1. I used to use a database called q& a, and found it easier than
> Access
> or Excel. Not sure what it's like these days or if it's still available.
>
> 2. Have you tried using Dreamweaver? You might be able to create nice
> looking, easy-to-use forms for both blind and sighted users and then
> import
> that into Access. Or build an intranet database using Dreamweaver and
> mysql.
>
> Been out of the loop for awhile, but I used to do lots with databases. So
> I'm sure there's a way somewhere. May be it's as simple as writing better
> scripts for Jaws to use Access.
>
> Good luck! Like the long message hope it's the right answer. I've never
> tried to answer before.
>
> If anyone else reads this this is a great source for learning how to use
> Jaws better.
>
> Graham
>
> ----- Original Message -----
> From: "luciano de souza"<luchyanus@xxxxxxxxx>
> To:<jawsscripts@xxxxxxxxxxxxx>
> Sent: Monday, January 24, 2011 10:09 PM
> Subject: [jawsscripts] Creating accessible forms to manage databases in
> Microsoft Office 2007
>
>
>
>> Hi all,
>>
>> I work in a management project area. It’s crucial to control several
>> structured information. I tried to do it with Excel. However, it’s not
>> easy to use
>> Excel with a database.
>>
>> My intention is to use Microsoft Access. The interface between Access
>> and JAWS is not perfect, but using Access 2003, I have created tables
>> easily with
>> SQL mode. It was really enthusiastic, however I could not create the
>> forms.
>>
>> Forms can be created with wizards, but there are two reasons why I
>> don’t want to use it:
>>
>> 1. I want to use VBA to validate the informed data and I desire
>> to customize some aspects to improve the navigation in the interface.
>>
>> 2. Wizards can create only simple forms from a single table.
>> It’s possible to create forms linking another forms.
>>
>> My question is: what is the best way to create forms with JAWS? I
>> consider the following hypothesis:
>>
>> 1. In Access, to create forms in the design mode, moving the
>> cursor to the control bar and trying to find and insert then in the
>> form. Long time ago,
>> a friend said me it’s possible to create forms using JAWS in Access.
>> However, my attempts was frustrated.
>>
>> 2. In Notepad, to create a HTML page and use it as a data access
>> page. When I heard about data access page, I thought the solution was
>> found. Only
>> typing some tags in a editor, I could create the interface.
>> Wonderfull? But, it doesn’t work. I could create the page, to import
>> it to Microsoft Access,
>> converting the page in HTML form available in Access. What was the
>> problem? I could create the form, but not to attribute callbacks to
>> the controls. For
>> example, I create a button called “send”. It should get the values of
>> the “name” field, “phone” field… and concatenate it in a sQL
>> instruction, allowing
>> the insertion of new records in the database, in other words, I needed
>> to attribute a macro or a VBA function to work as a callback of the
>> mentioned button.
>> Editing data access page in design mode, I can’t attribute functions
>> to controls.
>>
>> 3. In Excel, to create a form to get the data. I don’t use Excel
>> as a database. Since I was not able to create forms in Access, I try
>> to collect the
>> data in a Excel form. I wanted to get the data in Excel and
>> afterwards, to call Access with VBA, inserting records. I know, it’s a
>> very complicated way.
>> I would use Excel as interface and Access as database. Despite the
>> complexity, I tried it, but I was not successful. I opened VBA in
>> Excel environment
>> and I tried to create a new user form. The form is created, but it’s
>> not possible to attach controls to the form. As far as I could
>> observe, this task
>> is totally inaccessible for JAWS.
>>
>> 4. In VBA, to create the forms and their respective controls. Is
>> it possible? Yes, it’s possible, despite of the big complexity, it’s
>> possible. But,
>> if it solves a problem, unlikely it creates another. I want to create
>> the database. But I know, being blind, I can’t create beautiful
>> databases. If I am
>> able to create forms by the Access or Excel interface, the bad
>> positioned controls can be moved by a seeing person. My forms will be
>> awful, but with few
>> clicks, a seeing person could improve the the look. If I create the
>> form and the controls by code, it can’t be edited by a seeing person
>> because the controls
>> can’t be moved in the design mode. Therefore, I can’t follow this way.
>>
>> So, I ask if one of the solutions bellow are available:
>>
>> Solution 1: To create forms in Access without the wizard.
>>
>> Solution 2: To create a data access page in Access, attributing
>> functions to the controls.
>>
>> Solution 3: To create forms in Excel and link it to Access by means of
>> VBA.
>>
>> I could create it with Lua, Sqlite and IUP. For blinds, it’s really a
>> good combination among programming language, database and graphical
>> library. However,
>> I am in a company and I need to solve the problems with the tools
>> offered by the company. Unfortunately, Access and Excel are the single
>> alternative.
>>
>> Everything I described is based in Microsoft Office 2003. But I need
>> to solve my problem using the Microsoft Access 2007, Windows XP and
>> JAWS 11.01471.
>>
>> Is there a solution for my problem? Can I create databases with
>> Microsoft Office?
>>
>> This is my first message and it became really a long message!
>>
>> Best regards,
>>
>>
>> --
>> Luciano de Souza
>> __________�
>>
>> View the list's information and change your settings at
>> //www.freelists.org/list/jawsscripts
>>
>>
> __________�
>
> View the list's information and change your settings at
> //www.freelists.org/list/jawsscripts
>
>
__________�
View the list's information and change your settings at
//www.freelists.org/list/jawsscripts
--
Luciano de Souza
__________�
View the list's information and change your settings at
//www.freelists.org/list/jawsscripts
Other related posts:
