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

"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

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]

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.

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]

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/

"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

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

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

"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