Re: Access 2007 queries
- From: Shane W <shane-jfw@xxxxxx>
- To: jfw@xxxxxxxxxxxxx
- Date: Sat, 13 Nov 2010 16:49:50 -0800
Thanks for the pointers Rod. I can successfully build
queries with prompts in Access. Reports and forms are
another matter but I'm thinking I might be able to get
around reports by using Excel as the frontend and setting
Access as the data source. Not sure about forms yet though,
that might be a problem going forward.
Anyways, thanks.
Shane
On Thu, Nov 11, 2010 at 02:42:12PM -0600, Rod wrote:
> 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
--
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
Other related posts:
