Recent content by FacilitiesCAD

Do you have a report that just prints one picture already? If so what code does it have? Since your file names don't follow a specific rule (they look like 2 or 3 rules envolved) and you want every picture in a given path I think you will use some case of FOR EACH file in PATH do something...

Since there are only upto 10 and hopefully the image names are similiar you can do it many ways, 1 come to mind real easy. Set up 10 pictures where on error it shows no picture available. Set each picture up to show a specific numbered picture. abc1.tif abc2.tif...

OK Randy, I just spent a few minutes trying this out. [code] Private Sub Form_Current() Image4.Picture = Me.Text5 End Sub Private Sub Image4_Click() Image4.Picture = Me.Text5 End Sub [/c] There is two sets of code that both worked for me. The first one is probable a better choice...

AceMan, I hope he can get it because I lost track along the way in your direction. Probable just because I'm not making one at the same time. I'm off to Ireland for a vacation (10 days) but after that I should be back on the forumn. I may spend a little time this morning playing with this...

Sorry Randy, I can't help you right now. I have a slightly bigger problem right now. My wife has walked out on me. I probable won't be on this board for a while. Aceman should get you through this. Once I pick up the peices of my life I'll be back on and maybe I can help you with a new...

Follow aceman1 advice. I am a novice. BUT from your description I think I understand what went wrong. 1) In the textbox "ImagePath" set it back to visible = yes, you are doing this just so you can see it while we debug it. 2) in the textbox "ImagePath" type "= pic & name" without quotes. Now...

Thankyou, Things can be so easy to learn and so hard if you never try. I found out about underline and bold while looking for this info just now.

Don't you need to run the query somehow?

try threads 702-289543 and thread 702-831482. Wish I knew how to point to them. javascript:gothread(702.831482)

It sounds like you are trying to do something similiar to what I have done just recently. 1st) Do you have a way of specifying the image. IE C:\path\image.jpg ? 2nd) do you know how to edit a form and put any old image on it? 3rd) goto properties of the image you put on in step 2 and change it...

Thank you Bob, I have a working solution to the problems I've listed here. I use: dim criteria as string rs.movefirst criteria = "Path1 = '" & Path2 & "' and File1 = '" & File2 & "'" rs.FindFirst (criteria) rs.edit rs!field1 = "found" rs.update by the way what does the .update do for me...

I guess I would just: For r = 1 To 7 Step 1 sheet.Rows(1).Delete Next r but we all get the same job done. Tim

Sorry Im not sure. When I make a table and try to close it. I am told there is no primary key defined. It then makes a column labeled "ID" and no 2 ID's are the same in a table(due to autonumbering). Basicaly I want to change rs!field1 = "found" for the record that has ("Path1 = '" & Path2...

Thanks Bob, This I can follow. for my second problem can I dlookup() the ID which is the KEY variable and then move to that recordset. If so how? Thanks again, Tim

First Thank you everyone for the great posts here. I have learned alot about access from here. You have saved me unmeasurable time in organizing data. I am trying to maintain a database of all the autocad drawings on a specific public drive. The code bellow allows me to add a new record...