On Mon, 28 May 2007 12:50:33 GMT, "Steve"
wrote:

Jack,

Send me the screenshot of the frontend.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications


Done, but that is an outgoing email account only, so no need to reply
via email.





"JackShephard" wrote in
message ...
Hello folks,

I have a HUGE Excel 2007 DVD spreadsheet with a nice front end, and a
section to cover my purchased library.

If anyone is interested in looking, I can post a screenshot in a binary
Misc pictures group to show you the front end I have made for it using
lookups and a little visual basic code to paste the disc cover images.

What I would like to do is make a nice Access version of this database.
Particularly since it currently carries ove3r 110,000 records, which
makes it hard for excel.

I currently have several sheets in one workbook, all of which have an
ID column and then a column for the data, such as DVD Title, and MPAA
Rating, and where I bought it, MSRP Price, sound, Disc Aspect ratio, etc.

So, essentially, I have a series of two column sheets, and one at the
end that carries all of my purchased data, and the pointers to the image
files. The first sheet in the workbook is my "master view panel", which
is a vertically oriented pane of all the details for a single title.

That sheet has a tough time importing into access, since the
orientation makes it hard for access to garner what would be fields, etc.
That sheet is also where all the VLOOKUPS, and VB Code is at.

All of my attempts at constructing an ACCESS front end fail to get me
there.

I was used to "Paradox" years ago where user view panes were "forms".

Is this paradigm still true? Do I bring in the tables, make the
relationships, and then create a form for viewing/stepping
though/searching the data? Or is that now a "report" of some kind?

None of the templates I found online even come close to approaching
what I am looking to do, and my nil experience with access makes it even
harder.

I felt I could import all of the sheets, one by one, and then create
the indexed relationships to each. The problem is that access wants to
put in its own ID field every time.

It would seem, I got "issues". :-]

I have posted the screenshot in alt.binaries.pictures.misc though the
volume of posts there make it a nightmare to haul in headers from.

The post is DVD Database screen shot, for anyone interested.

Thanks for any help you can provide. I am a total Access newbie. :-[