password for command button?
Is there a way to code a command button in its on click event that will
prompt the user to enter a password to perform the command button's
On Jan 4, 11:34 am, Debbie S. <Debb...@discussions.microsoft.com>
> Is there a way to code a command button in its on click event that will
> prompt the user to enter a password to perform the command button's
> Thank you.
Yes, but you'll need to delve into VBA. Attach a click event to the
button and in the code:
Public Function Button1_Click()
...customizing quote merge template
I have 2 major problems that I just cannot seem to be able to resolve.
When using the mail merge template to do a quote it seems that there
are only a very limited range of "fields" that are made available to
the user. These DO NOT include the actual accounts "Address" only
shipping and billing address - 99% of our clients don't use these
address's so all our data is in "Address_line1" etc
Neither do the fields for "product description" appear in the list
only the products name. All our quotes have always included a short
four or five line desc...Customize Current View: Filter Problem
Using Outlook 2002, I have created a category called "Hidden" i
outlook. In my calendar, I put all the appointments I don't want t
appear in this calendar (i.e. daily reminders).
I then filter out all these "Hidden" items by selecting --
Customize Current View-->
Hidden (the category I created)-->
Edit these criteria directly-->
And then I change:
("DAV:isfolder" = false AND "DAV:ishidden" = false) AN
I have an account for some stock options in a privately-owned company.
Approximately monthly, AdvisorFYI keeps telling me, "It's time to update
your investment prices in Money." There isn't a price update that
often. Is there a way to turn this message off without turning of the
other useful AdvisorFYI Investment warnings?
...Resolving Email Address to existing contact problem
Has anyone else come across this issue in MSCRM3.0? - when you attempt to
resolve an email address to an existing contact in CRM (that does not
currently have an email address stored in their details) the contact resolves
OK but does not update the email address in the contacts details.
Is this by design, or have I found a bug?
...HELP Recovering addresses and email from Outlook 2003
I had some serious driver issues that required re-installing XP from
disc. I did use the backup option and have a backup of all the old
data. And of course had to reinstall Office 2003.
Will third party software restore my old email and addresses or am I
out of luck?? Thanks for the help
> I had some serious driver issues that required re-installing XP from
> disc. I did use the backup option and have a backup of all the old
> data. And of course had to reinstall Office 2003.
> Will third party software restore my old email and addresses or am I
> out of lu...Unable to click customizing outlook today button
Unbable to click the customising outlook today button for
Outlook 2000 install in the windows xp profession
machine. I have updated the office 200 patch 3. But it
seem remain the same problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;820575 might be
Neo [MVP Outlook]
Due to the Swen virus, all e-mails sent to this account will be deleted
"Clarence" <email@example.com> wrote in message
> Unbable to click the customising outlook today button for
> Outlook 200...how to match the color of a button with its background?
I have a owner draw push button. I associate it with two bitmaps, one
is down and the other is up. Is there a way to make the bitmaps's
background color match the color of the window where the button is
located. I manually choose the best matched color but still the result
is not good. I can even see a white border line (not drawn by me) when
the button is pushed. Please help. Thanks.
May Young <firstname.lastname@example.org> wrote in message news:<408473...custom field for projects with tasks past due
I am wondering how/what formula would be needed for creating a custom field
at the project level to show when a project has at least one task that is
past due. I have a custom field at the task level (IIf([Finish]<[Current
Date] And [% Complete]<100,1,2)) that will show when an individual task is
overdue, but I want to add a custom field to the Project Center > Summary
view to show when a project has any overdue tasks. The PM can then drill
down from there into the project and see exactly what tasks are overdue.
Once I figure out the formula for this I want to assign ...Setting up a new e-mail account
I'm trying to set up my yahoo account so that I receive
my e-mail messages in my Outlook Inbox. I went to
Accounts, and servers, and put in mail.yahoo.com for
incoming mail (POP3) and smtp.yahoo.com for outgoing mail
(smtp). When I click on the send/receive button I get an
Dave <email@example.com> wrote:
> I'm trying to set up my yahoo account so that I receive
> my e-mail messages in my Outlook Inbox. I went to
> Accounts, and servers, and put in mail.yahoo.com for
> incoming mail (POP3) and smtp.yahoo.com for outgoing mail
&...Non-VBA way of making custom menus.
Sorry for the new thread but even on Google, the thread isn't showing up.
Well, it was SOOO easy, as I knew it would be. The webpage I quoted in my
message this morning didn't mention the "New Menu" at all!
So, here is the non-VBA way to create a custom menu:
- TOOLS > CUSTOMIZE
- under the categories available choose NEW MENU and then drag the NEW MENU
option under the Commands window up to the menu bar (like D'UH!! <lol>
Wish all those hours spent searching yielded webpages that gave this! <g>)
- THEN one can go back to the MACROS category a few line...Input to custom reports
I'd like to be able to input values to a custom report like the Year. Is
there any way to package a custom report and provide input to it? Every year
the user has to go into the custom report and change the Year restriction.
Alternatively, (this is a payroll report), is there any global variable or
some other back door that I can use to get the current year in a custom
report? Given the report writer may not be the ticket what would the
recommendation be to create custom reports that require input? VB.NET?
Using VBA you can allow for input in the custom reports. B...Help me identify my missing permission (Cannot open public folder) -2147217843 (Maybe Authentication Fails?)
The following snippet of code throws an error number -2147217843. When
I googled this error code, I see many references to authentication
failed. I am assuming my problem is some kind of permission related
problem on the "MyNewFolder" public folder.
-- start code ---
Dim objFolder As New CDO.Folder
Dim f As ADODB.Field
'sURL is like: file://./backofficestorage/mydomain.com/Public
objFolder.DataSource.Open sURL, , adModeReadWrite, adFailIfNotExists
--- end code --
I have code that runs before this that actually creates the
"MyNewFolder" publ...Unable to sort on customer CRM 4.0
When you try to change the campaign response views to have customer as
sorting CRM gives an error. You can't even click on customer column to sort
when it's now customer that is default sorting.
Is this a bug ?
same here. I think its a bug
"Help needed" wrote:
> When you try to change the campaign response views to have customer as
> sorting CRM gives an error. You can't even click on customer column to sort
> when it's now customer that is default sorting.
> Is this a bug ?
...Customer check data
When customers pay by check RMS asks for specific information such as
drivers license number, routing number, account number, address and phone
Does anyone have a report and or a way to extract this info from the
database for cases when the check is returned for NSF?
We can write you this report. Contact me for detail on price .
Afshin Alikhani - [ firstname.lastname@example.org ]
CEO - Retail Realm
= = = = = = = = = =
"Scott Santorio" <email@example.com> wrote in message
> When customers pa...How to add a button to restore all altered cells original values?
I want to add a reset button to an excel spreadsheet that will restore the
values of all changed cells to the original saved ones.
Any help would be appreciated.
this would require quite some VBA code as you somehow have to store the
original values for example on a separate hidden sheet
"Dawnybros" <Dawnybros@discussions.microsoft.com> schrieb im
> I want to add a reset button to an excel spreadsheet that will
> values of all ...Clearing "Custom Footer" box
Is there a way to delete the contents of the "Custom Footer" option when
going through the "Page Setup" menu? I would like to clear out all
previously created custom footers and start fresh.
Go to FILE>PAGE SETUP>HEADER/FOOTER, click on the "Custom Footer
button. A new dialog box will appear with three panes. Highlight th
contents in each pane (one pane at a time) and hit delete.
Hope this helps
Message posted from http://www.ExcelForum.com
You have some responses at your other post.
T Crosby wrote:
> Is there a wa...Help! charts disappearing, new charts crashing powerpoint
When i open a presentation the charts vanish...i have restarted, they come
back. I try to edit a chart, and it crashes powerpoint after a few clicks.
What can I do...whole afternoon going crazy!
If you are using v 2007 there is a hotfix which is meant to cure some chart
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> When i open a pres...IM Add New Batch
GP 10 on 2003 Terminal Server.
How do you create a Payables Batch in the IM in preparation for importing to
the Payables Transaction destination? Alternatively, how must GP be set up to
ensure that the “Add New Batch” rule works correctly?
With the Add New Batch rule set the IM crashes (see my post Integration
Manager 10 Crashes). Additionally the characteristics of the Add New Batch
rule do not match the required information which I understand to be Origin
and Checkbook ID.
I figured there might be some default settings for Origin and Checkbook ID
in the setup somewhere but was not a...Moving exchange 5.5 to a new server exchange 2003
Good day all... how do I move exchange 5.5 to a brand new
exchange server 2003. The new server will be in a new
organization. Any info would be greatly appreciated.
Microsoft MVP - Terminal Server
>Good day all... how do I move exchange 5.5 to a brand new
>exchange server 2003. The new server will be in a new
>organization. Any info would be greatly appreciated.
...open outlook new email form from a crm form
It would be great to be able to open a New Email form (outlook form) by
pressing a button on the Contact, Account or Opportunity etc. form in CRM.
Customers like to use outlook for email and currently there is a disconnect
in that if you are on the opportunity screen and you would like to email the
Potential Customer (and have regarding on the email linked to the Opprotunty)
you have to leave the screen and start a new email in Outlook and lookup the
opportuninty you already have open again to populate the regarding if you
want to use Outlook. You could use Email button, but browser ema...LDAP Address Book
I use LDAP for my address book lookup. When I try to
lookup an address it comes back with "Unable to display
results because too many entries in the Internet
Directory match your search criteria"
Any ideas what is wrong? It works just fine in Windows
2000 but not with XP.
...How do I delete a custom attribute.
Help! I created a custom attribute in the Contact Entity of my
Microsoft CRM on my production server and it has a typo. I would
really like to rename it or delete it but there is no obvious way. I
have also looked through MSDN etc and have found no reference to it
(creating yes, deleting editing, no).
Thanks in advance.
Unfortunately it is not possible to edit or delete schema fields in MS CRM
"MagKip" <firstname.lastname@example.org> wrote in message
> Help! I created a custom attribute in the Contact Entity of my
&...How Do I Create A Personal Address Book In Outlook 2002
I'm new to Outlook 2002 and would like to know how do i go
about creating a personal address book.
Thanks in advance.
> I'm new to Outlook 2002 and would like to know how do i go
> about creating a personal address book.
> Thanks in advance.
You have a contacts folder ...that's what you should use. "Personal Address
Book" means .pab file - it's an old legacy thing, not what you want or need.
Enter all your contacts/addresses in your Contacts folder. If it isn't
showing up as an address book when you click the TO bu...Is there a way to add a toolbar button for individual signatures?
Using Outlook 2003 (not using Word), is there a way to add a toolbar
button for individual signatures? It seems as though you can add the
Signatures button and the More... buttons to the toolbar, but you
can't select and drag individual signatures to the toolbar. Any
No Spam <email@example.com> wrote:
> Using Outlook 2003 (not using Word), is there a way to add a toolbar
> button for individual signatures? It seems as though you can add the
> Signatures button and the More... buttons to the toolbar, but you
> can't select and drag indivi...