Recent content by MoJoP

Not sure if this would work but Ken Hamady pointed me in this direction when I was experiencing difficulties. http://support.crystaldecisions.com/kbase/c2005121.asp is the knowledgebase paper from Crystal. MoJoP

Hi DataBaseGuy I was searching posts for my Access Report to Word problem when I came across your posts. Would I also be able to get a copy of your sample? My e-mail is hims.sperritt@sympatico.ca Thanks very much!! MoJoP

Hi Rmcta I have a database with a command botton that sends a message to various people in my database query. Because there are so recipients, it is "cleaner" to include them in the BCC line of the e-mail and send it to myself in the To line. I've shown my example below but you need...

Bryan Where did you download the file from - I too have Adobe 5.0. Thanks. MoJoP

Hi I too had the DoCmd.DoMenuItem code come up from the toolbar wizard however, I was advised by another Tek Tipper that the DoCmd.RunCommand method was "cleaner". I'm not experienced enough to know either way.... MoJoP

HI I'm no expert but I usually make the form I want to "close" hidden instead so that I can still refer to it. I also requery the data source so that the main form is updated. Does that help? MoJoP

Hi Lloyd Is it not possible to just use the Snapshot Viewer i.e. DoCmd.SendObject? Otherwise, can you not invoke the distiller print drivers? Just a thought... MoJoP

Glen, I use the backup you suggested but because I wish to back up on CD-ROM I get an error message indicating "W:\ is not a valid drive, or you do not have access". Why is that? MoJoP

Dre I told you about this in the report I sent you - you format the suppression of the section using the phrase GroupNumber > {?TopNParameter} which will suppress all those other than what the user chose as TopN. It is found under the heading of PrintState functions in the function list. MoJoP

Hi Dre Just revisited the site to see you replied - the report has been sent. Please let me know if it was useful. MoJoP

Hi As in the other post, if you give me your e-mail address, I will send you my Top N parameter report which allows me to total the Top N per group and also the grand total using 5 formulae (which is needed to show the Top N numbers per group but also the sum total for the Top N groupings)...

Hi Dreman I can send you a template report in Crystal 8.5 if you provide me with an e-mail address. It's easier to show you that way. SynapseVampire - a copy is on the way. MoJoP

Just set up the running totals for the different questions. Group #1 is by person and add another group level for question number. The running totals should evaluate correctly because you will be a the grouping level of the person first - make sense? MoJoP

Hi Actually, I asked this question on the site awhile back and Ken Hamady pointed me in the right direction with the use of the 3 formula technique for a manual running total. Then you suppress the group footer of the report so groupnumber > {?TopNParameter}. The report works excellently...

Hello I have to do this a lot and figured this work around - not sure why it works but it does! For this example, let's say we want the % of smokers in a group of people. I would create a formula called %smokers and it would be # smokers * 100/# people. Then in the cross tab I would select...