The Search box (1 Viewer)

Oldsoftboss

AWF VIP
Local time
Today, 20:43
Joined
Oct 28, 2001
Messages
2,499
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:

DW

Registered User.
Local time
Today, 11:43
Joined
May 25, 2002
Messages
58
Here's a sample for you to play with.

Dave
 

Attachments

  • imagesample2000.zip
    70 KB · Views: 295

Oldsoftboss

AWF VIP
Local time
Today, 20:43
Joined
Oct 28, 2001
Messages
2,499
Brilliant. Even better than what I had in mind. This procedure can be used for many different application.
Thanks, Thanks, Thanks
Dave
 

DW

Registered User.
Local time
Today, 11:43
Joined
May 25, 2002
Messages
58
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:

zzteam

Registered User.
Local time
Today, 03:43
Joined
Nov 24, 2005
Messages
36
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.
 

Users who are viewing this thread

Top Bottom