Selasa, 11 Desember 2018

[MS_AccessPros] Re: VBA code for inventory photos

 

Hi Ken


There is a sample database that displays pictures on our Files>Samples folder named LoadPictures.That should give you what you need.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <kenaf42@yahoo.com> wrote :

Please help

Code for inventory photos

Access 2010

ReceivedProduct.asccdb "tbl"

FORM controls,

 ID

Combo Box: "text unbond"  Contains all SKU codes, retrieves related information  from another table


To Control: Product_SKU "text"

To Control:Produt_Name "text

Product_Cost "Curency"

Date_Received "Date"

Then, To Controls of :several other text controls for technical specification and finally an Image Control

I need VBA code and to know where in Event property apply it that while end user chose SKU in the combo box and gets all above in formation he/she be able to get the image of the product from another Field on hard drive, I do not want to store the photos in database.

 

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


SPONSORED LINKS
.

__,_._,___

Tidak ada komentar:

Posting Komentar