Recent content by Sally

I am interested in this. I use the Shell call to start Word and run a macro stored in the normal template. Is it possible to check if Word is already open and just run the macro without opening another instance of Word if it is?

Thanks very much - that was a great help. As a matter of interest, why does the "If" expression still execute the Shell call even when the recordcount is zero? Sally

I'd be grateful if someone would look at the following for me. I have a database converted from 97 to 2000. I want to check for the presence of records in a table produced by a make table query and if it is empty, abandon ship. This is what I have: 'Check to see if any students in report Dim...

Thanks very much one and all: I had tried "'" i.e. " ' " but not "''" i.e. " ' ' "! - this was my first proper foray into SQL and it works now, so thank you.... I'm not sure how I'd manage without the forum to search/ post to

I need an apostrophe in part of a SQL statement I'm constructing from code. The code works if I take it out but I get a ByRef error if I put it in. I've tried looking at previous posts but still can't sort it out. Please help

Thanks very much, Bob. That's done the trick. Thanks especially for persevering with me on this!

I have tried using a textbox and = "blah blah etc" but I get to the stage where it says "text too long to be editted" and won't let me do any more. Any more ideas please? Could I put it in a table as a memo and use Dlookup? If so, wouldn't there be a problem with running a query to produce...

Sorry... I don't mean text box - I still mean label (as per the first message. Can I join the contents of two labels?

I can't put it all in one text box because there is too much text - it exceeds 255 characters

I have a report with too much text for one label so I use two. It looks fine in Design view but when I preview it the label areas overlap or leave too wide a gap. Any ideas about how I can get round this one, please? Thanks

Yes... look up "add a background picture to a report" in the Access help file as this simulates a watermark HTH

Have you looked at: http://www.access-programmers.co.uk/ubb/Forum5/HTML/000617.html It seems to fit the bill HTH