Search results for query: *

Hi Any help on this problem would be much appreciated. I have a report with six columns with a sub-Report in the Report Footer. Both Group Headers, the Detail and the Report Header and Footer have the following settings:- Force New Page = None New Row or Col = None Keep Together = Yes...

Thanks Duane. I had already checked out Stephen Lebans site plus looked through any references I could find elsewhere on the net but there was nothing relevant. Perhaps I need to email him. Chopsuey

Thanks Duane for pointing out the Lebans code. Very helpful - I have been wondering how to do this for a while - have a star! However, do you know if there is a way to wrap the text within the caption? Chopsuey

Hi Lonnie I found a solution at Leban's website which creates a snapshot of the report, splits the pages and turns them into a PDF. Is this what you found? Very elegant! Am currently coding and hoping this will be a viable solution as it does not incur a hefty investment in PDF software for...

Hi Lonnie I am about create a report which need to be sent to customers by email and I was planning to convert it to PDF format prior to sending. I was wondering where you found your code that converts a snapshot to pdf. Could you post a reference to it? Many thanks. Chop Suey

Hi Interesting little problem here. Have a build string statement:- string = fielda & fieldb Fieldb is larger than 1024 as it is a textline for a letter. When I look at the string field, fielda is there and complete but fieldb has been truncated to 1024 characters! Anybody know of any...

Hi. I have been hunting for a solution for a problem with selstart value too. I found that I was getting unreliable results with _Enter event. A member on the following thread (702-726089) suggested using _Click instead and I have found that that solved my problem. Could you use the _Click...

Thanks Dave. I know this is an old post but I was getting nowhere trying to use selstart in the _Enter event (although I HAVE got it to work previously on a different form). Have a belated star!

I have had the same problem as Skinicod trying to get Access to recognise that the user has made a selection in a list box. My code is straight forward and like Skinicod I can get the code to work correctly by inserting it into the click event of a button instead. My code is as follows:- Dim...

Have resolved the problem. The .emf file was ok but the others were corrupted even though they appeared to functioning normally. I recreated each type of file properly and it works. Sorry to waste your time.

Hi Bob I know this is an old thread but I have come across it trying to find a solution to the runtime error 2114. The file I am using opens ok and is small (72kb) and I have tried it as a jpg, bmp and emf file (all of which open and appear normal). I am running a report with a small logo at...

Found your thread on a search for a solution for my own problem. Have you checked the reference libraries? I have encountered a similar problem when running access 2000 code under access 2003 and its looks like the access object 11.0 library might be the culprit.