This is causing me a lot of grief!

[mbga8ejf]

Hi Guys,

I hope someone can help because this has been troubling me for a
while.

The situation is that I am trying to incorporate an access database in
frontpage using asp etc. I can succesfully do this and there is no
problem with the frontpage side of things. The problem is displaying
the right information in the fields.

The database is a catalogue of all my vinyl records. There is a main
table called General Vinyl Information and 3 4 other tables (Labels,
Genre, Format and Condition) which contain data to be displayed in
individual combo box's within the General Vinyl Information form.
These tables have two columns, the first is and ID and the second the
name of the label/genre/format/condition etc. I set the database up and
have over 400 records which seem to be displaying correctly when I
view the General Vinyl Information table however when I come to query
the database from frontpage the fields which read from a combo box
containg the ID number not the associated label/genre/format/condition.
I have played around with bound column properties and set the bound
colunm to 2. Having dome this, when i view the General Vinyl
Information table it displays the ID's in the combo box fields. Can
anyone help?

I am willing to copy the structure of the database and send it via
email for someone to have a look if need be.

I have done a few tests with a smaller database and found that after i
change the bound column to 2 the ID's are displayed in the table but if
i then go to to evry record and reset the value in the combo box the
frontpage query displays the correct data.

It seems to me that when the bound column is changed the data in the
table needs updating or something.


Also, the databse seems to be very large in size for what it is. At
present it is 37MB. I dont think this is normal but cant find a problem
with it.

Can someone Help?

Ed Francis

 

[Tim Ferguson]

I set the database up and
have over 400 records which seem to be displaying correctly when I
view the General Vinyl Information table however when I come to query
the database from frontpage the fields which read from a combo box
containg the ID number not the associated label/genre/format/condition.

I am afraid you have succumbed to the deadly "I Used The Microsoft Access
Look Up Wizard and Now My Database Is Knackered" bug. Just about everyone
thinks that this is a huge misfeature and has created much more hardship
than it will ever save (which is about half a dozen mouse clicks). In
short, the wizard is lying, deceitful, malignant and undermining. Badly
needs dropping into a volcano IYSWIM.

The secret is in understanding what you are looking at in the table -- and
that you should not be looking at the table sheets anyway. In the main
table you have a _numeric_ field that contains a code that points to the
Primary Key column of the other, looked-up, table. This is standard
practise, if a bit of an overkill for simple situations. What the evil
wizard does is to hide it all underneath a bit of GUI jiggerypokery, and
thereby displays the Description field from the looked-up table instead of
the value that is actually there. Ugh.

When it comes to querying the database, you have to do the joins yourself.
Add the main table to a new query grid, and then the looked up tables.
Access should make the join lines for you by default. Then drag the
description fields to the main grid, along with any other fields from the
main table, sorting and grouping, etc. This is the query you want to use to
feed to your asp page.

HTH


Tim F

 

[mbga8ejf]

Oh Dear oh dear!

Yeah thoought that might be the case because i changed the table by
hand, including the bound column proerties and reentered the info and
tried to retriev the info using asp. It worked fine.

Is there any way of writing the data from a cloumn to a text file or
excel (Not the ID number though) so that i dont have to reneter all the
label/genre/format info again?

I hope so!

Thanks

Ed

 

[mbga8ejf]

Sorted the problem Now

I copied and pasted the data into Excel and then inported the Excel
Document into a new access doc.

Oh Yeah that feels good.

Ed