Access Forms – Database How-To Help?
I am creating a Database (in Access 2007) to list my numerous movies / DVD’s. I currently have the form set up to list the: Movie Name, DVD Type (drop down list for Regular, Blu-Ray, etc.), Standard / Widescreen (drop down list for Standard, Widescreen or Both), Genre of Movie (drop down list for Drama, Action, Comedy, etc.), Year of Movie, Number of Discs, Length of Movie, Watched (drop down list for Yes or No), Notes and Movie Description.
What I would like to do is have a pop up form where I can fill out the information or select it from a drop down list click on a command button that will save it and close it, however I want all the information to be auto populated and added to on a table (like an Excel spreadsheet), where I can have a complete list populated from all the records. I would also like this complete list to be sorted by the movie name in alphabetical ascending order.
Is this possible and how can I set this up, I am not very knowledgeable on Access.
Ok.
Yes this type of thing can definitely be done.
Your best approach is to create a set of lookup tables for the different options.
e.g. tbl-DVDType, tbl-format, tbl-Genre.
Each table should have an ID column (with an autonumber) and a Name.
You create a movies table with columns like this:
Movie name (Text)
…
formatID -> Set this as a lookup and choose the ID field from the tbl-format.
Repeat for the other lookups.
when you come to build a form then you can convert the ID fields into drop downs.
It is pretty hard to explain like this so if you want to then feel free to email me (via Yahoo Email) and we can take this offline to my private email account.
==== this was taken offline and help was provided
Perfect Movies for Halloween available on Blu ray
|
|
BluScenes: Journey Through Space 1080p HD Blu-ray Disc $14.95 BluScenes: Journey Through Space 1080p HD Blu-ray DiscJourney through Space – BluScenes Journey Through Space gives you an astronaut’s eye view of the wonders of the universe, featuring imagery and specially-created animations based upon images from NASA and the European Space Agency and presented here on 1080p HD Blu-ray disc. Your journey begins in Earth orbit and takes you past our moon and neighboring planets, before venturing into deep space for a stunning interstellar tour, with a digitally-recorded soundtrack presented in 5.1 Dolby Digital Surround, or 7.1 DTS-HD Master Audio. Optional subtitles provide information about each scene.Features:Content: 1080p HD Scenery from Outer SpaceDirectors: Jason RosenfeldFormat: Dolby, Surround Sound, WidescreenRegion: All RegionsNumber of discs: 1Studio: Scenic LabsDVD Release Date: December 10, 2009Run Time: 63 minutes |
|
|
When We Left Earth – The NASA Missions – Blu-Ray Edition $69.95 When We Left Earth – The NASA MissionsCommemorate NASA’s 50th anniversary with this stunning high-definition series chronicling the inside story of the space agency’s epic endeavors. From John Glenn’s Mercury mission to orbit the earth, to Neil Armstrong’s first historic steps on the moon, to the unprecedented spacewalks required to repair the Hubble telescope, these epic stories are shown in stunning clarity and told by the astronauts and engineers who were there. The missions, the people, and the triumphs of space exploration are revealed through exclusive interviews with celebrated astronauts including John Glenn, Buzz Aldrin and Charlie Duke, and newly-digitized, original mission footage from NASA’s secret film vaults.Features:Six complete episodesFour hours of bonus features including digitally restored NASA film highlights, mission clips, and astronaut interviewsEpisodes Include: Ordinary Supermen Friends and Rivals Landing the Eagle The Explorers The Shuttle |
|
|
Pirate To- Do List $29.99 Pirate To- Do List |
