The Search box

Oldsoftboss

AWF VIP

Local time

Tomorrow, 00:30

Joined

Oct 28, 2001

Messages

2,499

• Aug 5, 2002

• #1

The Search Button

I have created a form with a background picture and then thought - wouldn't it be good if you could easily change it. So I created a "Setup" form where the path to a picture could be placed. Then on load of the main form just go me.picture = field on the other form. Bingo it works.
Except on the setup form you must enter the exact path and extension in the field.
Now the question...
Can I program a button to open the standard windows 'choose file' window to add the file to my field ? (Take the guesswork out of it)
Thanks,
Dave

 

Last edited: Aug 5, 2002

D

DW

Registered User.

Local time

Today, 15:30

Joined

May 25, 2002

Messages

58

• Aug 5, 2002

• #2

Here's a sample for you to play with.

Dave

 

Attachments

• imagesample2000.zip

  70 KB · Views: 328

Oldsoftboss

AWF VIP

Local time

Tomorrow, 00:30

Joined

Oct 28, 2001

Messages

2,499

• Aug 7, 2002

• #3

Brilliant. Even better than what I had in mind. This procedure can be used for many different application.
Thanks, Thanks, Thanks
Dave

 

D

DW

Registered User.

Local time

Today, 15:30

Joined

May 25, 2002

Messages

58

• Aug 7, 2002

• #4

This is by far the better way to store images.

Holding one pic as an OLE or standard background pic is ok but, if you're going to save numerous pics, the database will increase in size enourmously.

With the sample, it stores only the file name and path, so not bloating the db.



Have fun

Dave

 

Last edited: Aug 7, 2002

Z

zzteam

Registered User.

Local time

Today, 07:30

Joined

Nov 24, 2005

Messages

36

• May 2, 2006

• #5

How I can use this sample database with OLE object (I know it's database too big but never mind...). I need pic in table.