Recent content by MikeGreen

Dave Thanks for the reply. Yes I was thinking of the table option but I quite like your idea on creating the floor plan using text boxes but do you know of an example of how the text boxes would be populated with the correct passenger? There script would have to allow for double seats where...

Hi all I am sure that I have seen this before but as I stated on my last thread it has been a few years since I last used access in real anger and the grey cells are not what they used to be. Okay I have a database that a friend uses to populate the passengers onto his coach. There is a report...

Just to let you all know that I have managed to sort out the vba that I required. Just for completeness here's the final code:- _______________________________________________________________________ Dim stDocName As String Dim MyPath As String Dim MyFilename As String Dim oApp As...

Minty, thank you for the feedback. I have tried this and I get the same message "The current OutputTo action was cancelled". and nothing happens regarding the creation of the PDF report. I am suspicious of this solution as there is no setting of the required link criteria. The report needs...

James Thanks for the quick reply. I also was suspicious of the "". I have tried omitting the "" but it returns the same error "The current OutputTo action was cancelled" result. I have run through Debug and everything looks fine with no errors. The file path etc are like this-...

Hi all I last touched Access about 9 years ago when I was quite good and I wrote a number of successful databases. As I no longer us it I have just discovered the level of skill fade that I have acquired when a friend asked me to update a database that I wrote for him (that's how I know it was...