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
|
|||
|
|||
new to access - please forgive ignorance
my client wants an application to behave like this website:
http://ericshin.com/orchestrations.php I would think that access would be the ideal application. Any direction to get me started would be greatly appreciated. -thanks |
#2
|
|||
|
|||
new to access - please forgive ignorance
"i dude eclair" a écrit dans le message de groupe de discussion : ... my client wants an application to behave like this website: http://ericshin.com/orchestrations.php I would think that access would be the ideal application. Any direction to get me started would be greatly appreciated. -thanks |
#3
|
|||
|
|||
new to access - please forgive ignorance
On 26 Feb 2010 17:09:40 GMT, i dude eclair wrote:
my client wants an application to behave like this website: http://ericshin.com/orchestrations.php I would think that access would be the ideal application. Any direction to get me started would be greatly appreciated. -thanks Intriguing! This could certainly be done in Access; you would need at least four tables: Composers; Works; Instruments; and Instrumentation. It would be reasonably straightforward to build a form based on these tables to replecate the functionality of the website (with subforms and combo boxes or listboxes to select the records). It's more than would be appropriate for a newsgroup post, but here are some resources to get started. Allen's and Crystal's tutorials should get you off the ground, and you're welcome to post back with specific questions. Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
#4
|
|||
|
|||
new to access - please forgive ignorance
John W. Vinson wrote in
: On 26 Feb 2010 17:09:40 GMT, i dude eclair wrote: my client wants an application to behave like this website: http://ericshin.com/orchestrations.php I would think that access would be the ideal application. Any direction to get me started would be greatly appreciated. -thanks Intriguing! This could certainly be done in Access; you would need at least four tables: Composers; Works; Instruments; and Instrumentation. It would be reasonably straightforward to build a form based on these tables to replecate the functionality of the website (with subforms and combo boxes or listboxes to select the records). It's more than would be appropriate for a newsgroup post, but here are some resources to get started. Allen's and Crystal's tutorials should get you off the ground, and you're welcome to post back with specific questions. Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials thanks for these I have my 4 tables, and was about to start on the form creation, but I wasn't clear as to 1 main form with 2 subforms. Then I was thinking about some apply-filter-on-click event when I thought it best to ask for direction. I shall study. |
#5
|
|||
|
|||
new to access - please forgive ignorance
On 26 Feb 2010 18:51:05 GMT, i dude eclair wrote:
I have my 4 tables, and was about to start on the form creation, but I wasn't clear as to 1 main form with 2 subforms. Then I was thinking about some apply-filter-on-click event when I thought it best to ask for direction. It always helps to be specific with your question - we can't see your screen! g I'm guessing that you might want a Form based on the Works table, with a filter set by a combo box or listbox of composers; and a Subform based on instrumentation. Data entry into the tables might require an additional form or two. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
new to access - please forgive ignorance
i dude eclair wrote in
: my client wants an application to behave like this website: http://ericshin.com/orchestrations.php I would think that access would be the ideal application. It's much more difficult on a web page than in Access. Any direction to get me started would be greatly appreciated. Your looking for discussions of filtering combo boxes, or synching combo boxes (maybe "cascading"). The techniques are the same for combo boxes and listboxes. It's a matter of using the AfterUpdate event of the first listbox to either set the rowsource of the second or requery it (if the rowsource has the first listbox hardwired into its criteria). Then the AfterUpdate even of the second does the same for the third. It's really that simple, though there are a number of niceties that will be required (like clearing/requerying the 3rd listbox when the first is updated and such). -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#7
|
|||
|
|||
new to access - please forgive ignorance
"David W. Fenton" wrote in
36.100: i dude eclair wrote in : my client wants an application to behave like this website: http://ericshin.com/orchestrations.php I would think that access would be the ideal application. It's much more difficult on a web page than in Access. Any direction to get me started would be greatly appreciated. Your looking for discussions of filtering combo boxes, or synching combo boxes (maybe "cascading"). The techniques are the same for combo boxes and listboxes. It's a matter of using the AfterUpdate event of the first listbox to either set the rowsource of the second or requery it (if the rowsource has the first listbox hardwired into its criteria). Then the AfterUpdate even of the second does the same for the third. It's really that simple, though there are a number of niceties that will be required (like clearing/requerying the 3rd listbox when the first is updated and such). thank you that is a great start muchly appreciated |
#8
|
|||
|
|||
new to access - please forgive ignorance
Your looking for discussions of filtering combo boxes, or synching
combo boxes (maybe "cascading"). The techniques are the same for combo boxes and listboxes. It's a matter of using the AfterUpdate event of the first listbox to either set the rowsource of the second or requery it (if the rowsource has the first listbox hardwired into its criteria). Then the AfterUpdate even of the second does the same for the third. It's really that simple, though there are a number of niceties that will be required (like clearing/requerying the 3rd listbox when the first is updated and such). do you know of any known examples of this, so that I can look at the code? I haven't found any in Northwind ... tks |
#9
|
|||
|
|||
new messenger go very good
Friends and friends around the world.
We are presenting the new messenger. He will be in the commissioning by the friends that we indicate to use the system. Access the system by clicking the link below and register free. You get something for using orkut? You get something for using skype? You gain something by using twiter? You get algumaocisa for using facebook? Enjoy this is your time!! Sign up and join for free. http://www.sqipcom.com/?ref=webempreendedor http://stakeholder.sqipcom.com/user/webempreendedor |
#10
|
|||
|
|||
new to access - please forgive ignorance
"i dude eclair" wrote in message . .. "David W. Fenton" wrote in 36.100: i dude eclair wrote in : my client wants an application to behave like this website: http://ericshin.com/orchestrations.php I would think that access would be the ideal application. It's much more difficult on a web page than in Access. Any direction to get me started would be greatly appreciated. Your looking for discussions of filtering combo boxes, or synching combo boxes (maybe "cascading"). The techniques are the same for combo boxes and listboxes. It's a matter of using the AfterUpdate event of the first listbox to either set the rowsource of the second or requery it (if the rowsource has the first listbox hardwired into its criteria). Then the AfterUpdate even of the second does the same for the third. It's really that simple, though there are a number of niceties that will be required (like clearing/requerying the 3rd listbox when the first is updated and such). thank you that is a great start muchly appreciated |
|
Thread Tools | |
Display Modes | |
|
|