Recent content by errant

Anyone can help?

my Macro program here: Dim I As integer Dim FilPath As String Dim Rng As Range With Sheet1 For I = 2 To . Range("B65536") .End(xlup).Row FilPath = "R:\04 Seasonal\"& .Cells(I,2).text & ".jpg" If Dir(FilPath) <> "" Then ***************.Pictures.Insert(FilPath).Select ***************Set Rng =...

Hi, all, I have a spreadsheet with many pictures, because these linked Pictures in my folder, if I save this file and send to another people which is not in my area, then it would not show pictures. How can I embed these linked pictures and send out?

I got it, that's the Me.Pictures should show Pictures only really don't know what is the Me. mean..

I got it, this is really simple that I put Picture path and wrote the code Private Sub Report_Current() Me.MtImage.Picture = Me.Pictures End Sub then I can see picture in the report, this is wonderful but there have "Compile.error" Method or data member not found what is the problem with this?

Ok, that's more simple, I made the default value for the pictures path to update table detail. Pictures = "R:\Picture\" & [ItemNo] & ".jpg" question is how can I use this path to show picture in report?

for the ("JPG"), this is because the form only show the file name without extension. By the way, is this Private function in the form? I understand the structure but don't know how to use this function for the report, can you tell me more? I'm really new in VBA.

Hi, All, I made a form and placed image in, this image source in specific folder which is match with the ItemNo, means: Database[ItemNo] = Folder[ItemNo.jpg] (if picture can't found then will display a unique picture - "No Picture") This function made by VBA. The problem when I print report...

Thanks Gentlemen, I'm trying to make different way that you guys suggested.

It better say just one current data update with the save button. Sorry for this confusion!

It better say just want current record, is my existing program similar? Or this is totally different? Please help on this, it would be get much more if I can figure this out! Anyway, I just want to make a save function and get update and update by use in these fields.

Is it would be update all data in this field? Actually I just want to update one record set which in my form, I tried to figure it out but no luck to make this work.

Thanks for your reply but don't understand, how should I write this program look like?

Hi, I'm trying to make a VBA program to update and Save record, unfortunately, the following program only effect on the 1st record in the table. This is the button function that I placed in a form with detail, can anyone can point out where is the problem? Private Sub btItemSave_Click() Dim db...

This is Rex who is the new guy in programming and Access!