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()
...Outlook 2003 News
I am trying to setup the news reader in Outlook 2003. I follow the
directions but it won't stick when I drag news to go menu. Any ideas?
To get the News command back, go back to the Programs tab in Control Panel |
Internet Options and change the default newsreader to Outlook Express. If
OE prompts you to make it your default newsreader the next time you launch
it, clear the "Always perform this check..." box and then click the No
You may need to reset the Menu Bar and/or restart Outlook and/or reboot your
machine in order to complete the process. Not everyone is repor...Business Portal Error-SQL server does not exist or access denied
We are running business portal 4.0 for one of our customer. It was running
correctly, however, they have changed the SQL server port (previously it was
set as default 1433). After that the business portal becomes very slow and
while creating a new request (purchase requisition) if we open the item pop
up; it is showing exception
"SQL Server does not exist or access denied...."
Can any body tell me how can I provide the new port number to business
portal connection to the database.
Thanks and Regards,
Thanks for using the newsgroups. I have a...What's happened to the findfirst function in Access 2010?
I have a working Access 2007 Application which is now failing miserably in
2010. It hinges on location the first available working document in a table
runing the following VBA code:
.FindFirst "([fld1] + [fld2]) = 0"
If .NoMatch Then
.FindLast "([fdl1] + [fld2]) <> 0"
.... FURTHER PROCESSING ...
What must I do to correct this? Go through a record by record search?
In 2007, this works correctly, stopping at the appropriate record (approc.
rec 1385 in the recordset...open two different Access reports
I was wondering if i can get some help here. I have two different reports
that i want to open when a user clicks a button to view the reports for
printing. Is there any way of popping them up at the same time in VBA?
Thank you in advance
>I was wondering if i can get some help here. I have two different reports
>that i want to open when a user clicks a button to view the reports for
>printing. Is there any way of popping them up at the same time in VBA?
>Thank you in advance
Yes. Call the DoCmd.OpenReport command twic...Outlook 2003 #79
I nhave recently purchased Office Professional 2003.
When using Outlook the send / receive function sometimes
does not work and I need to log off the computer and log
All configurations are standard and the email servers
have been verified by the ISP.
Does anyone else have problems with the stability of
Whenever I open Outlook 2003, I am getting a dialog box which displays the
Microsoft Office Outlook has encountered a problem and needs to close. We
are sorry for the inconvenience
When I click Debug it displays a message box with the following error
"The instruction at "0x3007e993" referenced memory at "0x0000000:. The
memory could not be read"
When I click No it Visual Studio JIT debugger pops up.
I uninstalled and installed several times but still the problem persists.
Is there any regsitry entry that I've to modify/delete?
...Canadian Mergers 2003
I have Money 2003 which will not allow me to preform a stock merger in the
Canadian format. Will upgrading to 2006 allow me to do this?
In microsoft.public.money, giff42 wrote:
>I have Money 2003 which will not allow me to preform a stock merger in the
>Canadian format. Will upgrading to 2006 allow me to do this?
Yes, with Deluxe there is a built-in function and above. It should
be able to convert your Money 2003 file automatically.
While there is not the built-in feature, here is how you could do it
in Money 2003 Standard, do it if you did not hold both stocks
involved in the merg...Outlook 2003 with XP SP2
IS there an issue with outlook 2003 running on a XP machine with SP2. I
am having connectivity problems. When I shut off the windows firewall, the
outlook client connects. some help please.
I suggest that you add outlook2003 to the Windows Firewall exception list.
"stonefly" <shitij_T@hotmail.com> д����Ϣ����:OAoct1k5EHA.4028@TK2MSFTNGP15.phx.gbl...
> Hey guys,
> IS there an issue with outlook 2003 running on a XP machine with SP2. I
> am having connectivity problems. When I shut off the windows firewall, the
> outlo...Filters in Excel 2003
I am using Filters in Excel 2003.
Every cell in sheet B is linked to every cell in sheet A. That way I
can alter data in B without corrupting the original data in A. I then
highlight the cells in B that I want to assign a filter to and select
Advanced Filter. I have no criteria so I do not set that. I click OK.
I then select Filter again and this time select Auto Filter. Drop
down arrows appear at the top of my columns. Great, no problems so
far, I then select from the drop down list the criteria that I want to
filter. Again no problems, my list filters correctly.
But once I have do...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...Need Help with Deleting Empty Paragraphs in Word 2003
I have written the code below to delete all empty paragraphs at the end of a
document and then place the cursor at the end of the last paragraph.
It works fine as a stand alone sub in a new doc, but fails inside the real
document that contains other code that manipulates several documents.
The failure is that it will delete the last empty para, but then gets stuck
looping inside the While...Wend because subsequent .Delete are not happening.
So, the question is why would this work in one document, but then fail in
n = 0 ...Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with
Office 2003 Service Pack 3 so that I could open Word documents with the file
ext docx. Subsequent to the Service Pack 3 installation, whenever I open a
Publisher file (which I created), I get the following message: "Publisher has
detected a problem in the file you are trying to open. If you are certain
that this file came from a trusted source and does not contain harmful
information, click OK." What is causing this and is there a way to stop this
Error message when you...Using Access 2003 on client to see Sharepoint 2007
Testing a Sharepoint environment and I can easily manipulate and run the
database from Access 2007, but when I try to use Access 2003 it wants me to
save the database to a location. The Access 2003 has the compatiblity pack,
but it seems to not work when I download it.
So the question is using Sharepoint 2007 and posting the Access 2007 format
to it, can a user go to the sharepoint site and use a 2003 Access database
that has the compatibility pack and open without having to download it?
Message posted via http://www.accessmonster.com
Send check for $500.00 to: David A Jenn...Outlook 2003 Out of Office Reminder RPC over HTTP
I have some remote office users that have Outlook 2003 configured
using RPC over HTTP. They do not get the notice that pops up
reminding them that their Out of Office is on when they open Outlook.
Is there a way to get this to work?
...Access 2007 and Vista code problem
I am developing a database on a XP SP2 machine. On a form I have created
some buttons with event procedures that run 2 queries and open a form. I
sent the db to someone running Access 2007 on a Vista machine and nothing
happens when she clicks the buttons and there are no messages.
I know nothing about Vista so thanks in advance for any help.
Might be a reference problem, have them open the open a code window and
click tools references. See what says missing and tell them what should be
there, Add it and it should work. Duff
"Tim Reid" <TimReid@discussions.micr...shortcut with command line switch probs
I have a shortcut set up which has the target declared as:
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /
This works fine on my PC. Excel 2000 running on Windows XP.
Unfortunately it doesnt work on someone elses PC, who asked for m
They have the same software set up, and access to the same folde
When they try to run the shortcut, a window opens and closes almos
solotoo's Profile: http://www.excelforum.com/m...Ctrl+D not working on outlook messages
Any idea why?
> Any idea why?
And what are you expecting to happen?
"alltimefav" wrote in message
> Any idea why?
So instead of hitting Ctrl+D to delete an item, what happens when the
item is selected and you hit the Del key, or the "X" toolbar button,
or right-click on the item and select Delete?
Did you really expect a detailed response for such a vague question?
You didn't even bother to say what "not working" means, like the item
does not get delete...Outlook 2007 Calendar -> Outlook 2003
In the past I could forward appointments and birthdays from one PC to
another, if both PC's had Office 2003. I just tried forwarding a birthday
from Outlook 2007 to Outlook 2003 and it doesn't work. I get the email in
2003. Open it, open the calendar item, then click on Save & Close. No
error message. But it's not there. Neither in the current month or for
next year. I forwarded it as a reoccurring item, that's the only way it
will let you do that.
Has anyone else been able to do this?
Or, is this a backward compatibility issue?
It's odd.... this works fine for...PDA-Outlook 2003
I have a Jornada 540 and I try to sync to outlook 2003
using Activesync 3.7. I get the message Outlook is no
longer installed. Reinstall MS Outlook.
This happens on both Exchange and Outlook 2003
Appreciate your help
...compact database in VBA access 2007
I have recently upgrade to office 2007 from office 2003. To compact a
database from within the database itself, I used the follwing code.
Unfortunately it no longer works in access 2007. Is there some similar code
that will work?
Public Function FncCompactTheCurrentDB()
CommandBars("Menu Bar"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
On Thu, 28 Jan 2010 17:34:01 -0800, SL <SL@discussions.microsoft....how to make macro work even a sheet is hidden.
I have macro assigned to a button in Sheet 1 which goes to sheet 2.
Press a button to Refresh and then PRINT preview
It does work in normal state.
I do not want the user to see the Sheet 2. I hid sheets from
but the macro is not working when sheet 2 is hidden.
how to overcome this error
"can't execute code in break mode"
the macro code is
Application.Run "'Latest 2009Payslip.xls'!Sheet2.HURows"
...Merge code issues with Publisher 2003
It seems whenever the data source is altered, the merge code fields have to
be reinserted in the Publisher document. Is this normal?
The data source starts in Excel and is then saved as a .txt file to retain
number formatting on final merge.
...Some Excel formatting functions taking a long time to work #2
Excel 2000 SP3
When I use some formatting functions for the first time in a
session, such as bold, increasing font size etc, it takes up to 30
seconds to work. Meantime Excel is locked up until it completes that
formatting call. I suspect faulty DLL?
Has anyone experienced this? How to fix (other than a complete re-
Any advice appreciated.
On Nov 5, 8:39=A0am, Piri <wiremu.pare...@hotmail.com> wrote:
> Excel 2000 SP3
> When I use some formatting functions for the first time in a
> session, such as bold, increasing font size etc, it takes =A0up to 30
> secon...LDAP Write access?
My ldap server allows Write access to entries - and a few clients now
Any plugins available for Outlook to allow this too?
None that I'm aware of.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Subscribe to Exchange Messaging Outlook newsletter:
Outlook Tips: http://www.outlook...