Re: Access 2007 queries

  • From: Shane W <shane-jfw@xxxxxx>
  • To: Rod <Rod@xxxxxxxxxxxx>
  • Date: Wed, 10 Nov 2010 23:25:29 -0800

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

Other related posts: