Search results

Expr1: [FName] & " " & ([MName]+" ") & [LName] The bracketed middle part of the expression will not produce anything if there is no middle name and so avoid having 2 spaces. See attached example db. Hope this helps :) Just reread your post and realized I missed the order you wanted, (LNAME...

Hi Chris, Thanks for the compliment. The quote you quote me as saying is actualy quoted from the link that was given by Rickster57 - wheels within wheels eh? http://www.groupacg.com/ARptTip.htm#SUBR1 I'd suggest having a look there. I had a quick search (4th variation of the search strings...

Bump Anybody know how to set the caption property of a report before it is opened so that when you use the send object method to email, the snapshot file uses the report title for the file name? Long sentence, hope the answer is shorter :)

Thanks orna. vbnewline loks a little better that the chr'()s. Ill give it a go.

Just a thought - are all items (subreports, headers, footers, etc) set to 'can shrink'. If there are any that have no data, they may still take up space.

Hi Chris, This thread shows how I recently worked out just about everything (with help of course!) regarding the use of fake footers for subreports. My guess is that the principles would equaly apply to the headers. http://www.access-programmers.co.uk/forums/showthread.php?t=119364 Hope it helps.

Sue, Many thanks - "chr(13) & chr(10)" works fine for the message portion of the sendobject when emailing reports. It may well work for the subject etc, but I haven't tested this. :) If qanybody out there could shed a little light on why the chr(13) won't do the business on its own, I'd be...

Thanx for the responses guys. I use my flash for carrying jpgs & docs etc between PCs (sneaker-net). All the PC's I use are using Windows XP so I guess that I am ok as long as the device is not being actively interrogated at that the moment of removal. :)

Cosmo75, Do you still have the sample? The link on this old thread is broken. Could you reprost your solution? Ta in advance.

A colleague passed on the advice that you should always stop a flash drive before removing it. I have never done this, indeed until he showed me how, I didn't know how to do it r even that it could be done. It makes sense not to remove the flash drive when reading or writng to/from it as you...

When using sendobject to email a report, can I send a carriage return in the message somehow? "chr(13)" doesn't work. The snapshot file attached to the email takes the report caption property to generate the filename "caption.snp". I have been able to set the caption in the on open property...

Thanks Gemma, This worked for me: If Nz(Projectnumber, 0) = 0 Then 'Test for null project number PrjNumber = "" Else: PrjNumber = " Project: " & Projectnumber End If :D

Clueless is adapted from Jane Austen's novel Emma, first published in 1816. I haven't read the book or seen the film, but I recall reading something somewhere commenting on Austin's 'lightness of touch' and the well drawn characters. From this point of ignorance (pretty extreme) it may be...

This works a treat. A few things to note: 1: My report has 9 subreports and so I loaded up 9 footers numbered 1 to 9. Curiously, the sorting and grouping shows the pseudo groups in the opposite order to the report itself. That is, if the sort and group shows 1 to 9, the report shows 9 to 1. Go...

Thanks for the heads up. :D

Hi again, I managed to get this working based on the question and answer from your link. Thanks.

Thanks Gemma, I shall go a way and play!

Lots and lots of posts on this subject so it is something that obviously gives lots of trouble to newbies such as myself. The code below works fine if the control is not null but gives Error 94 - invalid use of null when the control is null. I have gone around in circles with this - what am I...

Hi, The code shown below generates the reprot with no filtering. I want to have the report for the current record only based on the ProjectID. StrCriterion = "[ProjectID]=" & Me![ProjectId] DoCmd.SendObject acReport, stDocName, , , , , Subjecttxt, Messagetxt, , StrCriterion...

I think it will.... Rickster, thanks for the pointer. I will try this out today and reprot back. From the link: When designing a report which contains one or more sub-reports, there may be instances where the sub report grows large enough where it will span more than one page; with the...