Solved

Hide formula

Posted on 2000-03-08
3
247 Views
Last Modified: 2013-12-18
Suppose a document is created and then it will mail the entire document to receipent as well as saved in the one database.
I want to hide the one action button   when the user open this document by mail.
but unhide the button when user open the document from the database,
so what formula I should use in hide formula?
0
Comment
Question by:edwardy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Accepted Solution

by:
Simon_Hendry earned 50 total points
ID: 2598022
The best way to do this is to check whether the database the document is being opened in, is the users mail database , you can use the @MailDBName function to acheive this ...


If the databases are always going to be on the same server then use

@Subset(@MailDBName;-1) = @SubSet(@DBName;-1)

Or if their is a possiblity of the user mail database and the other database being on seperate servers and there is a possibility of another database having the same path as the users mail database on that other server (rare !!) you could use this function..

(@Subset(@MailDBName;-1) = @SubSet(@DBName;-1)) & (@Subset(@MailDBName;1) = @SubSet(@DBName;1))

This would hide the button if the current database is the users mail file..
0
 
LVL 6

Expert Comment

by:ghassan99
ID: 2598088
I like this solution:)

-Gus
0
 

Expert Comment

by:ikke_de_steve
ID: 2603830
If you send an mail, normaly you change the FORM field to "memo", so you can check of the FORM field is equal to "memo".

Good luck,

Ikke De Steve

PS.: In the database you have to change the FORM field back after you have send it the "memo".
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question