Search results for query: *

That did the trick, thank you very much Remou! Love the easy fixes despite the "Duhhh!" feeling.

My only ideas at this point is that the two variables ParentLink and ChildLink aren't updating as the recordset is changing to the next record. In which case it would make sense that it is only creating one folder.

Hey guys, What i'm trying to do is automate creating a large number of file folders by using Access. I already have created all of the "Parent" folders. What I need my code to then do is cycle through each record and create child folder within the parent folders that will be unique. So I will...

That most definetly was it! Once I went through and redid my tables, forms and reports to follow proper naming conventions everything worked fine. So now instead of Report I have lngReportNumber and it links perfectly!

You are correct dhookom, I didn't need to run that code on the main report. What I did have to do to get this to work though is in the Subreports Data tab set the LinkMasterFields to actually specify exactly what table. So by default, Access was doing the Child field as Report and the Master...

A follow-up to the above: I've created a new report using a template to see if that might help solve the problem. Now the pictures do display correctly with:srepImageReport!UploadImageFrame.Properties("Picture") = srepImageReport![ImageLink] but ONLY if I don't make a parent/child link of the...

Here's where i'm at right now dhookom: My main form has the following OnPrint Event Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) On Error GoTo PictureNotAvailable srepUploadImageFrame.Properties("Picture") = srepImageLink.Report![ImageLink] PictureNotAvailable: If...

I also use Detail_Print as it loads the images on a page-per-page basis rather than loading them all at the beginning of the report. I found that trick on another post on this forum where the user had 100's of images that were making the report impossible slow to load.

Ok i've converted the subform into a subreport and it now works correctly displaying the images. Now where i'm stuck is what code i need for the OnFormat of the main reports Detail section. If I try to use Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)...

I should also add this is Access 2002.

Hey all, I'm at the end of the rope with my problem. I have a form that allows users to upload the path's to image files which are then stored in a table and linked to the corresponding record#. I then have a form I created that shows the upload pictures via an unbound image control. That part...