Recent content by daybase

Absolutely brilliant - many thanks - only query why doesn't trim strip the trailing spaces? Had to write code to strip it down works great but puzzled.

Apologies - didn't seem to fit properly anywhere

I have a database which holds details of graphic files and allows the user to view files. Due to the size and quantity of graphics I have opted against embedding the graphics but the table holds name of the file and uses that information to insert the graphic in the report or display on form...

I have a database which holds details of graphic files and allows the user to view files. Due to the size and quantity of graphics I have oped against embedding the graphics but the table holds name of the file and uses that information to insert the graphic in the report or display on form...

I'm trying to lay out a document using MS word with VBA - sort of working okay(ish) using .shapes.addpicture but layout goes wrong if picture is portrait as opposed to landscape. Any way of reading file size or, just centering the picture once it is re-sized to the right height

Charity - Thought the solution was something like that - tried every combination of (())'## etc etc but no luck. Thanks for making sense of it for me. Rich - thanks for the suggestions

Invoices is the simple bit - there is more that I want to do - warning letters etc. And letters are so fiddly to set up in Access

Help - I am starting to venture beyond access reports and simple macros - my latest (of many problems) is that I am attempting send the current record to a word document using the following technique lifted from knowledge base: Private Sub MergeButton_Click() On Error GoTo MergeButton_Err Dim...