HELP!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please please please, could someone help. I have tried to look through all
this great stuff you guys put up but I still can not work out what i need to.
I wish to put a browse button onto a form so that a user can select a certain
image to appear on that form. Im sure this is not that hard but could someone
provide a step by step guide for a newbie. Thanks in adance.
 
Please please please, could someone help. I have tried to look through all
this great stuff you guys put up but I still can not work out what i need to.
I wish to put a browse button onto a form so that a user can select a certain
image to appear on that form. Im sure this is not that hard but could someone
provide a step by step guide for a newbie. Thanks in adance.
Click to expand...

Nick,

You know the structure of your database. You know where your images
are. We do not.

We cannot help unless you help us do so!

Are you using Microsoft Access (I hope, since that's the subject of
this newsgroup)? Are your images stored in a Table? What else is in
the table? What information exists in the table which would let the
user select an image?

John W. Vinson [MVP]
 
Hi John
Ok my database is fairly simple at the minute as it is something i have
picked up and put down many times. And i hope the structure is now correct, I
currently have one table with two forms both the forms have tabes. i am an
estate agent and wish to use one form to record my buyers and there needs and
another to record my sellers and there property details this is where i am at
just now, on one page of my sellers form i wish to be able to browse and
insert three photos of there property for reference and later to be used in
another way but i need to get past this hurdle before i can go any further.

thanks again
Nick
 
Hi John
Ok my database is fairly simple at the minute as it is something i have
picked up and put down many times. And i hope the structure is now correct, I
currently have one table with two forms both the forms have tabes. i am an
estate agent and wish to use one form to record my buyers and there needs and
another to record my sellers and there property details this is where i am at
just now, on one page of my sellers form i wish to be able to browse and
insert three photos of there property for reference and later to be used in
another way but i need to get past this hurdle before i can go any further.
Click to expand...

Again:

I CANNOT SEE YOUR DATABASE.

I'm a Wysard of Information, that's my business name anyway - but I'm
not telepathic.

You have a table - or maybe two tables, that's not clear ("both forms
have tab[l]es"). I don't know anything about the structure of these
tables. I don't know what is in the tables which would allow you to
find an image.

You have some images in external files (that's good, in fact - storing
images in Access is VERY inefficient).

I would strongly suggest that - if you have only one table - that you
need some more. A Buyer is not a Property; a Buyer might or might not
also be a Seller; a property might have several prospective buyers; a
buyer might be interested in several properties. Mushing together
information about all these entities into one table will NOT give you
a good design.

I would suggest that you need at least the following tables:

Properties
PropertyID
Address
City
Postcode
AskingPrice
<other info about the property as an entity>

Pictures
PropertyID
PictureFile <name of a file containing one of the pictures of this
property>

Customers
CustomerID
LastName
FirstName
<other bio information, contact information>

Buyers
PropertyID < link to Properties >
CustomerID <who's interested in buying it>
<other fields about this customer's interest, ...>

Sellers
PropertyID
CustomerID <who's selling>
<other fields about this seller>

To display the image (or images) you would use a Form with an Image
control on it. In some suitable event, you would set the Picture
property of the control to the text string containing the path and
filename of your image.


John W. Vinson [MVP]
 
Thanks for the guidence had originaly started with what you have said "table"
wise, then changed it for about the 1000th time to what im working on now.
Which had seem to be the best way of doing it. But I'll listen to someone who
knows what there talking about and go back to the drawing board AGAIN!!! or
maybe just give up for now.

Thanks Again

John W. Vinson said:
Hi John
Ok my database is fairly simple at the minute as it is something i have
picked up and put down many times. And i hope the structure is now correct, I
currently have one table with two forms both the forms have tabes. i am an
estate agent and wish to use one form to record my buyers and there needs and
another to record my sellers and there property details this is where i am at
just now, on one page of my sellers form i wish to be able to browse and
insert three photos of there property for reference and later to be used in
another way but i need to get past this hurdle before i can go any further.
Click to expand...

Again:

I CANNOT SEE YOUR DATABASE.

I'm a Wysard of Information, that's my business name anyway - but I'm
not telepathic.

You have a table - or maybe two tables, that's not clear ("both forms
have tab[l]es"). I don't know anything about the structure of these
tables. I don't know what is in the tables which would allow you to
find an image.

You have some images in external files (that's good, in fact - storing
images in Access is VERY inefficient).

I would strongly suggest that - if you have only one table - that you
need some more. A Buyer is not a Property; a Buyer might or might not
also be a Seller; a property might have several prospective buyers; a
buyer might be interested in several properties. Mushing together
information about all these entities into one table will NOT give you
a good design.

I would suggest that you need at least the following tables:

Properties
PropertyID
Address
City
Postcode
AskingPrice
<other info about the property as an entity>

Pictures
PropertyID
PictureFile <name of a file containing one of the pictures of this
property>

Customers
CustomerID
LastName
FirstName
<other bio information, contact information>

Buyers
PropertyID < link to Properties >
CustomerID <who's interested in buying it>
<other fields about this customer's interest, ...>

Sellers
PropertyID
CustomerID <who's selling>
<other fields about this seller>

To display the image (or images) you would use a Form with an Image
control on it. In some suitable event, you would set the Picture
property of the control to the text string containing the path and
filename of your image.


John W. Vinson [MVP]
Click to expand...
 
Thanks for the guidence had originaly started with what you have said "table"
wise, then changed it for about the 1000th time to what im working on now.
Which had seem to be the best way of doing it. But I'll listen to someone who
knows what there talking about and go back to the drawing board AGAIN!!! or
maybe just give up for now.
Click to expand...

I'll be glad to try to help...

if you'll provide some information other than the fact that you're
frustrated.

I understand your frustration, and I'm sorry that you're feeling it.
I'd like to help you get over your frustration. But unless I were
there, or unless you describe WHAT you are currently using, and what
SPECIFIC problems you're having, neither I nor anyone else can help
you.

I've asked twice now - this is the third time - for some specifics
about your database structure. If you'll please post them, I'll try to
make some constructive suggestions.

You might want to look at some of the references in the websites
below, particularly Jeff's Database Design 101 links; or you may want
to consider hiring someone who's experienced with databases to at
least get you up and running.

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson [MVP]
 
Back
Top