| |
Damage
Posts: 1
Score: 0
Joined: 3/18/2004
From:
Status: offline
|
I am a beginner who has been slung in at the deep end (for me anyway) with some VBscript. I have access to an access database of 48 holidays with a variety of categories (Adventure, Theme, Destination, Duration, Group Size, Price).
1. I have to create list of bullet points by checking through each category (depending on what category's page i am on) but without duplicating any of the categories (say if there was more than one holiday of any type/price) these bulletpoints also have to be hyperlinks to a table containing full details of each holiday from the database.
2. Use VBscript to create a new table everytime a new type is found in the database.
For example; Using the "ADVENTURE" page
In "adventure" the first topic is "ballooning"
First i need the topic in text as the table title
Then I need the script to create a table with 8 headings (holiday, adventure, theme, destination, country, duration, group size, price)
Then find all "ballooning" holidays until all are included
The bottom row of the table must then include a "back to top" link
after the table i need a horizontal line.
Now i need the database to create that table over and over again until all the categories (the second being "biking") have their own tables just like it.
Something like this:
Ballooning
Holiday, Adventure, Theme, Destination, Country, Duration, Group Size, Price
#1.........Ballooning..Air........Africa............Kenya.....7 days.....4................?499
Back to Top
This table should repeat over with a different title and moves on to the next adventure each time.
As i said i am a beginner so any help would be very appreciated because i be up S*** creek
Thanks
Matt
|
|
Printable Version
Repeating VBscript - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread