Recent content by jeh35

I need to produce a grouped report. Each group has a header taking up the full page width (A4 landscape), reporting material common to all the records in its group. The detail records for each individual component, basically a small image and some dimensions, require much less space. Three...

Solution found, with help from someone in another forum. The image control's data souce needs to be set to a local string function that interprets the relative link, gets rid of extraneous characters, prepends the rest of the path and takes the value of the total path to the image file in text...

I’m struggling with what should be a simple problem. Each record in my database includes a field containing a hyperlink to an associated image file. The hyperlink is a relative address since the whole system is used from time to time on different computers. Displaying these images in Forms and...

Thanks John. That's the clue I needed. Best wishes John

I have a few thousand transactions in an Access 2010 DB. Each is assigned to one of about a dozen categories. The categories are listed in a separate table. I need to be able to list in a report all the transactions in one or more categories which the user chooses at run-time. Doing this for a...

I use a form/subform combination to allow entry of stock whereabouts. The main form is an item description; each subform record contains (amongst other things) a field, LOCN, indicating the item's location. Earlier records in the subform report where the item has been in the past. Currently...