Re: Creating Forms from Update Queries

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steve (Steve_at_discussions.microsoft.com)
Date: 12/08/04 

Date: Wed, 8 Dec 2004 08:47:02 -0800

Once again, my humble appreciation for both of your replies, Graham and John.

The one particular application where I 'd like to incoporate some sort of
form and an update query is in the switchboard environment. Your point is
well taken, John that I can incorporate VBA. I guess I am being lazy. Here is
more detail on this particular instance:

I have a real simple Product Distibutor inventory application, where several
items are received under an order number, added to inventory and then shipped
out together as one order. There may be certain line items on the order that
are exceptions. My thoughts were to incorporate an update query to zero out
the inventory when shipped with the execution of the update triggered by a
control button in the form. The form concept then can also be incorporated
into the switchboard menu environment.

Quite frankly, I am a neophite developer, trying to stay away from it if
possible. And Graham, as you say, this project is exhibiting all the signs of
a bad abstract painting!

Thanks again, gentleman.

"John Vinson" wrote:

> On Tue, 7 Dec 2004 18:51:01 -0800, "Steve"
> <Steve@discussions.microsoft.com> wrote:
>
> >I ma not sure where this was originally posted but this seems like the
> >appropriate forum. I know that froms can easily be created from 'select'
> >queries.
> >
> >Can they be created from update queries? If so, how?
> >
> >I am stumped - not being able to select any update type queries from scratch
> >and then not seeing them as options to change the control source.
>
> A Select Query is a source of data which can be viewed, edited,
> reported, used in Joins to create new queries. So you can base a Form
> on a Select query and use that form to edit the data in the tables
> which make up the query.
>
> An Update query is an *action* query. It is not a source of data; it
> cannot be used as the recordsource of anything because it doesn't
> "contain" data - it DOES something, changing the values in a table.
>
> Are you attempting to execute your choice of several update queries,
> selecting them from a list on a Form? You can do so using VBA code;
> but I'm not sure why you would want to! Please explain.
>
> John W. Vinson[MVP]
> Join the online Access Chats
> Tuesday 11am EDT - Thursday 3:30pm EDT
> http://community.compuserve.com/msdevapps
>

Relevant Pages

  • Re: Updating all records
    ... Okay, give me some time to digest what you've suggested here, Graham, and be ... I'm assuming you can write a query that has a unique row for each PartID, ... and which contains one column for each "variable" used in the calculation, ... Dim sExpression as string ...
    (microsoft.public.access.formscoding)
  • R.I.P. John Graham, 80, ("I Love You, Mouse" and widower of Alexandra Ripley)
    ... John Graham, a longtime University of Virginia faculty member, died ... Graham, formerly of Virginia, and Cathryn Spellman O'Neill, formerly ... T. Casteen III. "When he retired, former students came to Carr's Hill ...
    (rec.arts.books.childrens)
  • Agnes de Graham, wife of John de Monfode
    ... In prior posts concerning Sir John de Douglas and his wife ... Agnes de Graham (parents of the noted Sir James Douglas of ... John de Monfode. ... Sir Nicholas de Graham and Mary of Strathearn. ...
    (soc.genealogy.medieval)
  • Re: Corstabquery or normal query
    ... You can create the crosstab similar to the suggestion by John. ... church, also church elders, we have many elders, only 1st elder is one person. ... I would first build a query to get the data ...
    (microsoft.public.access.reports)
  • Re: Creatinig a database to update in alphabetical order
    ... John M. it is like you are reading my mind, ... know I am a movie fanatic. ... > should not be routine) displayed as a query datasheet. ... > Keyword ...
    (microsoft.public.access.gettingstarted)