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: //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: //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: //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: //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