RE: Access 2007 queries

Hi Shane,
        95% of the access stuff I do, is with tables, queries, and macros. I 
used forms awhile back, but had better vision then and used zoomtext to work 
visually, and haven't messed with MS Access forms much using JAWS, so can't 
help much there.

Look up parameter query and see if that helps you. A parameter query will 
prompt you for input when the query is executed. Sounds like what you want is 
information from a user to enter into a form. That form field name is what is 
used in the parameter query .
Here's kind of an example off the top of my head:
Select [FName], [LName], [HomePhone], [Email]
From MyTable 
where [FName] like [NameToFind];

So, since [NameToFind] is not defined in the Table, it's treated as a 
parameter, so when you execute the query, you're prompted to enter a value for 
[NameToFind], so let's say you enter 'Shane', as the value, the result from the 
query would be the name phone & email where [FName] = 'Shane' (which may return 
more than one row).

So, along the same line, if you create a form the input field name would be 
'NameToFind', and in your query, it would be referenced as [Form].[NameToFind].

Hope that helps, Good luck,
Rod




-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf Of 
Shane W
Sent: Thursday, November 11, 2010 1:25 AM
To: Rod
Cc: jfw@xxxxxxxxxxxxx
Subject: Re: Access 2007 queries

Hey Rod,

Hand-coding SQL is an excellent suggestion and one I didn't
consider. I come from a PostGreSQL/MySQL background so that
shouldn't be difficult. But how is input obtained from the
user? For example, part of my assignment says query when
given the broker's first and last name returns all clients
managed by that broker. So a simple join occurs but does
the query editor have a placeholder that says hey when you
encounter this, go out and query the user?

Also, how do you find designing forms as that's a big part
of what I need to do?

Best,
Shane

On Wed, Nov 10, 2010 at 03:39:14PM -0600, Rod wrote:
> Hi Shane,
>       Yes, Jaws does not work well with access. I think it's got worse 
> instead of better.
> 
> Play with the tab & f6 keys to navigate around. 
> 
> I've been doing queries, by coding the SQL in notepad, then in access, switch 
> to the sql view, and paste the SQL from notepad into it. If there are no 
> errors, it will save, and you can run it. If there are errors, you'll have to 
> fix the query. It's not easy, or fun, but can be accomplished. My hopes are 
> that Jaws will eventually catch up and work better with Access. 
> By the way, I use Vista Home, Office 2007, and Jaws Version 12. 
> 
> Good luck.
> Rod
> 
> -----Original Message-----
> From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf Of 
> Shane W
> Sent: Wednesday, November 10, 2010 2:06 PM
> To: jfw@xxxxxxxxxxxxx
> Subject: Access 2007 queries
> 
> Hello all,
> 
> I am taking a course which requires the use of Access 2007
> but am really confused about the JFW support here. I expect
> this is a common enough application though so wondering
> what others do.
> 
> My current issue is the design of queries. I have tried
> using the query wizard and the query designer but Jaws
> isn't reading when a table is selected and the resultant
> fields, query types and values etc.
> 
> So just wondering how people are using access...
> 
> Best,
> Shane
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list: 
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to 
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> Archives located at: http://www.freelists.org/archives/jfw
> Alternative archives located at: 
> http://n2.nabble.com/JAWS-for-Windows-f2145279.html
> 
> If you have any concerns about the list, post received from the list, or the 
> way the list is being run, do not post them to the list. Rather contact the 
> list owner at jfw-admins@xxxxxxxxxxxxxx
> 
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list: 
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to 
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> Archives located at: http://www.freelists.org/archives/jfw
> Alternative archives located at: 
> http://n2.nabble.com/JAWS-for-Windows-f2145279.html
> 
> If you have any concerns about the list, post received from the list, or the 
> way the list is being run, do not post them to the list. Rather contact the 
> list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list: 
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to 
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: http://www.freelists.org/archives/jfw
Alternative archives located at: 
http://n2.nabble.com/JAWS-for-Windows-f2145279.html

If you have any concerns about the list, post received from the list, or the 
way the list is being run, do not post them to the list. Rather contact the 
list owner at jfw-admins@xxxxxxxxxxxxxx

--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list: 
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to 
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: http://www.freelists.org/archives/jfw
Alternative archives located at: 
http://n2.nabble.com/JAWS-for-Windows-f2145279.html

If you have any concerns about the list, post received from the list, or the 
way the list is being run, do not post them to the list. Rather contact the 
list owner at jfw-admins@xxxxxxxxxxxxxx

Other related posts: