Desktop services template - help with Text

[Kev0360]

I have downloaded this and set up everything OK.



The one thing I am unable to do is change the control MyContactInfo which appears on the quote and invoice reports.

It insists on putting "Fax" instead of "email" as the company info underneath the company name. Is this produced with a macro?

[June7]

Blast! This is a web database. Do you really need a web db?

I opened the Quote and Invoice reports in Layout view, clicked on the Fax label, changed the caption to Email, saved the report.

[Kev0360]

If I open the quote or invoice report, the part where the phone and email are doesn't have a label - just the Control Source MyContactInfo

[June7]

Not what I see. I see labels Phone and Fax (now Email). Cannot replicate issue. If you want to provide db, I will look at.

How do you open the report? I can't find a button for this so I just opened from navigation pane and enter past all the prompts.

EDIT: Found it, let me do some more looking.

Here it is: Need to change the QuoteClientOnly and InvoiceClientOnly reports as well.

[Kev0360]

I have tried another download using their default database, the problem appears to be that it puts the word Fax in regardless of whether it has been entered followed by the email address. Just a bug I think, There are definitely no labels to edit?

[June7]

I edited my previous post. Yes, there are labels to edit. There are 4 reports.

[ssanfu]

@June,

Didn't know this was a web database .Yechhhh!!!

The OP is looking at his company info, not the client info

I finally found where the query field "MyContactInfo" is being generated.


The InvoiceDetails has a field "MyContactInfo: [prmMyContactInfo]"

It looks like this is generated in the "INVOICE" macro. (this goes for the QUOTE macro also)
SubMacro ViewInvoice

SetTempVar: tmpMyContactInfo

Expression: IIf(IsNull([TempVars]![tmpCompanyPhone]),"","Phone " & [TempVars]![tmpCompanyPhone]) & IIf(IsNull([TempVars]![tmpCompanyFax]),""," Fax " & [TempVars]![tmpCompanyFax]) & IIf(IsNull([TempVars]![tmpCompanyEmail]),""," " & [TempVars]![tmpCompanyEmail])

I really hate macros.......

[Kev0360]

Superb, thank you both for the help. I have edited the word Fax to say Email. Job done

[June7]

Ooops, glad you stepped in Steve.

But shouldn't the string have both Fax and Email?

Expression: IIf(IsNull([TempVars]![tmpCompanyPhone]),"","Phone " & [TempVars]![tmpCompanyPhone]) & IIf(IsNull([TempVars]![tmpCompanyFax]),""," Fax " & [TempVars]![tmpCompanyFax]) & IIf(IsNull([TempVars]![tmpCompanyEmail]),""," Email " & [TempVars]![tmpCompanyEmail])

[Kev0360]

Probably should but who uses fax these days!!!

[June7]

Blast again! Why won't it let me add that text to the expression? Ahh, seems to be too many characters in the expression.

I know, but putting Email in front of a phone number doesn't make sense.

[ssanfu]

Then if you don't have a fax, I would take out the IIF() for the fax.

Also, I wouldn't use IsNull() function. I would use Len() and Trim() functions.

Expression: IIf(Len(Trim([TempVars]![tmpCompanyPhone]))=0,"","Phone " & [TempVars]![tmpCompanyPhone]) & IIf(Len(trim([TempVars]![tmpCompanyFax]))=0,""," Fax " & [TempVars]![tmpCompanyFax]) & IIf(Len(Trim([TempVars]![tmpCompanyEmail])),""," Email " & [TempVars]![tmpCompanyEmail])

I think what is (was?) happening is that when the fax number was removed, it resulted in a null string for the fax number. Since a null string is not a NULL, the word "Fax" and the null string for the fax number was being displayed.

Using "Len(Trim(someField))=0 " checks for both a NULL and a Null String.

[ssanfu]

Whoops... I just saw June's post about the length problem...... I really, really hate macros.
...11 chars too many.

So... back to "I would take out the IIF() for the fax."

[June7]

If these contact info data are required in the table, then the IIfs would be unnecessary. However, if want to leave them optional, need to make some decisions. Maybe eliminate Fax or shorten the TempVars variable names.

Or don't use web db design and switch over to VBA for all code.

[Kev0360]

Blast again! Why won't it let me add that text to the expression? Ahh, seems to be too many characters in the expression.

I know, but putting Email in front of a phone number doesn't make sense.

That is true but if the fax details are left blank it just looks like Email then the mail address