If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating Forms from Update Queries
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. Any help is appreciated. Thanks. |
#2
|
|||
|
|||
Steve,
You can't create forms from queries! You can, however, create tables from queries. What are you trying to do? Regards, Graham R Seach Microsoft Access MVP Sydney, Australia Microsoft Access 2003 VBA Programmer's Reference http://www.wiley.com/WileyCDA/WileyT...764559036.html "Steve" wrote in message ... 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. Any help is appreciated. Thanks. |
#3
|
|||
|
|||
Hello Graham-
Thanks for the more than prompt response (and overlooking my horrendous typos!) Here's what I am trying to do. I actually have two separate applications (one which uses forms in the context of a switchboard environment) where I want to make the user interface as friendly (ie, non-access-like) as possible. I am looking to use a form for the interface where the changes to input data can be made in a form and a control button on the form can execute the update query. Does my objectives make sense? Once again thanks for your prompt response and I hope the additional information helps your analysis. Regards, Steve Belville "Graham R Seach" wrote: Steve, You can't create forms from queries! You can, however, create tables from queries. What are you trying to do? Regards, Graham R Seach Microsoft Access MVP Sydney, Australia Microsoft Access 2003 VBA Programmer's Reference http://www.wiley.com/WileyCDA/WileyT...764559036.html "Steve" wrote in message ... 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. Any help is appreciated. Thanks. |
#4
|
|||
|
|||
On Tue, 7 Dec 2004 18:51:01 -0800, "Steve"
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 |
#5
|
|||
|
|||
Steve,
Firstly, why would you not want to use a "non-Access-like" user interface? Access forms and controls look, feel and work just like Windows ones - as a user, you can't pick the difference! It's just inexperienced developers who make the thing look like a MalevikAs painting! John Vinson has explained the difference between the different types of query, so there's no need to further explain that. If you want to use a form, just create one, basing it on the query of your choice: 1. From the Database Window, select the [Forms] tab. 2. Click [New]. The [New Form] dialog is displayed. 4. If you want Access to build the form for you, click [Form Wizard], or any of the [Auto Form:.....] options. If you want to design it yourself, click [Design View]. 5. From the [Choose a table or query.....] drop-down, select the query you want to base your form on. 6. Click [OK]. In this case, there's no need to have a button to commit the changes you make on the form, the changes will be automatically updated when you move from one record to the next, or when you close the form. Regards, Graham R Seach Microsoft Access MVP Sydney, Australia Microsoft Access 2003 VBA Programmer's Reference http://www.wiley.com/WileyCDA/WileyT...764559036.html "Steve" wrote in message ... Hello Graham- Thanks for the more than prompt response (and overlooking my horrendous typos!) Here's what I am trying to do. I actually have two separate applications (one which uses forms in the context of a switchboard environment) where I want to make the user interface as friendly (ie, non-access-like) as possible. I am looking to use a form for the interface where the changes to input data can be made in a form and a control button on the form can execute the update query. Does my objectives make sense? Once again thanks for your prompt response and I hope the additional information helps your analysis. Regards, Steve Belville "Graham R Seach" wrote: Steve, You can't create forms from queries! You can, however, create tables from queries. What are you trying to do? Regards, Graham R Seach Microsoft Access MVP Sydney, Australia Microsoft Access 2003 VBA Programmer's Reference http://www.wiley.com/WileyCDA/WileyT...764559036.html "Steve" wrote in message ... 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. Any help is appreciated. Thanks. |
#6
|
|||
|
|||
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" 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 |
#7
|
|||
|
|||
On Wed, 8 Dec 2004 08:47:02 -0800, "Steve"
wrote: 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. Just put a button on the Switchboard form, and use it to execute the action query. The Command Button Wizard offers this as one of the options for a new button. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
#8
|
|||
|
|||
John, what a simple, elegant solution!
Once again, thanks and I'll give you some feedback on the results when I implement it. Regards, Steve Belville Bryant & Stratton College Milwaukee WI "John Vinson" wrote: On Wed, 8 Dec 2004 08:47:02 -0800, "Steve" wrote: 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. Just put a button on the Switchboard form, and use it to execute the action query. The Command Button Wizard offers this as one of the options for a new button. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update Table from Queries | Mike | Running & Setting Up Queries | 1 | October 20th, 2004 03:49 PM |
Using Subqueries within Update Queries | MGalyardt | Running & Setting Up Queries | 1 | August 28th, 2004 09:54 AM |
Using Forms for Parameter Queries | Jon | Using Forms | 0 | August 6th, 2004 03:58 AM |
creating controls on open forms | Kenneth_J | Setting Up & Running Reports | 0 | June 23rd, 2004 06:44 PM |
update queries | angie | Running & Setting Up Queries | 2 | June 8th, 2004 03:11 PM |