new to access - please forgive ignorance

  • Thread starter Thread starter i dude eclair
  • Start date Start date
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
Click to expand...

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/accessjunkie/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
 
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/accessjunkie/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
Click to expand...

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.
 
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.
Click to expand...

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.
 
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.
Click to expand...

It's much more difficult on a web page than in Access.
Any direction to get me started would be greatly appreciated.
Click to expand...

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).
 
It's much more difficult on a web page than in Access.


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).
Click to expand...

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).
Click to expand...

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
 
Back
Top