Wanted: ? UnknownFunction("vbOK") returns 1 in VBE Immediate window
It is not a function; it is a constant. If you lookup msgbox function and
msgbox constants in Help you will find out more about it. The following is a
small example of its use where the users selection is returned to a variable.
Dim Response As Variant
Response = MsgBox("Do you want to continue?", vbOKCancel)
If Response = vbOK Then
MsgBox "User selected OK"
'Insert required code here
MsgBox "User cancelled." & vbLf & _
...SP4 Apply Issue - GP 9.0
While applying SP4 on GP 9.0, we keep getting the following error “ File Not
No errors during executing MSP file.
We get this error when we launch GP Utilities and accept the new code prompt.
We checked the folder and it does not exist.
Any help is appreciated.
...Issue with Powerpoint 2010 Video Insert
I created a presentation in PP 2010 and inserted a video to a slide. When i
try to save the presentation, a compatibility box opens and says that the
video will be saved as a picture. Not sure why this is happening.
When I open the presentation to view video slide......nothing there?
Video is a WMP file. Seems to be conflict with new PP 2010.
Any help will be greatly appreciated.
Jack Barrett - Director of Development
The First Tee of the Palm Beaches
7301 North Haverhill Rd.
West Palm Beach, FL 33407
PPT 2010 embed...Page 1, Page 2, ...is showing up very large in the worksheet.
You are in Page Break Preview mode. Go to the View menu and
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Tink54" <Tink54@discussions.microsoft.com> wrote in message
> Web Traveler
You're in Page Break Preview mode. Choose View/Normal.
You are in page break view mode, go to view and switch it to normal mode.
> Web Traveler
I work with numbers that have leading zero's. Excel
constantly drops the leading zero's is there a way to stop
this. Ex type 01111 in a cell and it drops the zero. If I
past 01111 into Excel for Access it keeps the zero's but
doing some function will then drop the zero again.
Format the fields as text
"John Stech" <firstname.lastname@example.org> wrote in message
: I work with numbers that have leading zero's. Excel
: constantly drops the leading zero's is there a way to stop
: this. Ex type 01111 in a cell and it d...Repeat 6 rows, 1 column on many pages in Excel, 6th row cut off?
How do I get Excel to not cut off the text in the 6th row when I want to
repeat 6 rows and 1 column on multiple pages for printing?
...Excel Template #12
Sorry but I am a little new to templates in Excel.
I have created a template, which I would like to add to a toolbar,
which I thought I had done although when I click on it, it opens the
the actual template where as I want it to open a version of it?
Please can anyone help with how I can do this??
VickyC's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27391
View this thread: http://www.excelforum.com/showthread.php?threadid=490752
It sounds like y...My 1099 issue
We're on v9.
My Acctg Manager want the AP staff to input 1099 TAX info when setting up
new vendors and not have it default and be able to 'save' a new vendor to
'Not a 1099 Vendor' as it does now. What I'm looking for is when setting up a
new vendor, the user must go to the Vendor Mtce Options screen and be obliged
to enter a Tax Type from the pull down. The user will not be able to save a
new vendor unless they do so. I've researched this request and cannot find if
this can be done or not.
Thanks in advance for your help,
GP Guy in AZ
No, there is not an o...Running CRM 1.O
Having issues with receiving e-mail to other mail enabled users. Customer's
e-mails are coming into the techsupport queue but other techs do not receive
the e-mails. We have followed Microsoft documentation, but our mail server is
separate from CRM server. We are using Server 2003 help!
Sorry running CRM 1.2
> Having issues with receiving e-mail to other mail enabled users. Customer's
> e-mails are coming into the techsupport queue but other techs do not receive
> the e-mails. We have followed Microsoft documentati...Book1 issues
If I open Excel 2003 it opens Book1 (that is normal), then if I make no changes to Book1 and close Excel it asks if I want to save Book1. Normally if you open Book1 and then close Excel it does not ask if you want to save it. Also, if I open Excel 2003 it opens Book1 then I click File, Open and click on an existing .xls file. It keeps Book1 open and you can see this on the taskbar - Book1 and the existing .xls file. Normally if you open Book1 and then open another .xls file it 'closes' Book1 and you don't see it on the taskbar. I have 2 user with Notebooks that have this issu...excel #132
Column A contains Postcodes numbers, Column B contains Suburbs
I would like a formula where Column C contain combined list of of suburbs in
a particular Post code separted by comma
for example row1- PC 4034 suburb Geebung,
Row2- 4034 Aspley,Row3 - 4034 Zillmere
Answer required - Post code 4034 - Geebung, Aspley,Zillmere
need ur help
...Bizzare issue in Excell & Word 2000 When i type the # "1"
In both excel & word (2000) when I type the number "1" it
immediatly chages to the word "one". This is a
particualr pain in excel becausae it can't be used in a
formual. This only happens with the number one. Is this
some strange setting that I can fix? Please help.
Somebody has probably put an auto-correct entry in the list. In either Word
or Excel, Tools > Autocorrect and scroll down the list until you find the
entry that shows find "1" and replace with "one". Select that entry and
"ajsa1009" <a...1 becomes 10, how can I stop this
Iv'e been working with basic formulas and worksheets for a short time. Today
I opened a saved sheet and found that when I use a number and enter to the
next cell, the number gains a zero ie 1 becomes 10. If anyone can help out
with this I'd be very grateful.
check for the format of cells.
right click on the cell in which 1 turns to 10 select Format cell and
see for its format and change it to yor required format according to
> Iv'e been working with basic formulas and worksheets for a short time.
> I opened a sav...ASP.NET Gets Error "550 5.7.1 Unable to relay" to outside domain
Hello, I am an ASP running my own ISP using SBS 2003 and EX2003, and
currently have 25 domains I am hosting. My problem is that my ASP.Net pages
cannot send email using System.Web.Mail.SmtpMail to an addressee not already
in my domain recipeint policy. This is a problem, as the code should be able
to allow anyone in the world to register with the site and then recieve an
email message from the code. It seems to me that I should be able to somehow
configure the ASP.NET user to have full open relay permissions, or some other
clever solution that will not turn me into an open relay, yet st...Is there anyone using GP v10 and Office 2000 -- Does it work?
Is there anyone using GP v10 and Office 2000 -- Does it work?
This is not an officially support combination. Specifically, does Smart List
export to Excel 2000, and does the home page work correctly?
Thanks, Dan L.
On Nov 16, 7:19 pm, Dan Lapp <DanL...@discussions.microsoft.com>
> Is there anyone using GP v10 and Office 2000 -- Does it work?
> This is not an officially support combination. Specifically, does Smart List
> export to Excel 2000, and does the home page work correctly?
> Thanks, Dan L.
The basic smart list and home page features work. The onl...Office 2010 Word
I have looked through the list of available discussion groups but am unable
to locate one for Office 2010 beta, so I post this here in the hope that
someone might direct me to somewhere or someone that can help. Having only
just downloaded the beta I have found it to be causing several problems in
terms of the speed in which certain things happen - my computer seems much
more sluggish than previously with Office 2007. However, I can live with
that, but I have also found that when I am using grammar and spell check in
Word I get one of two results: 1. No attempt is made by Word...Only 2000 characters in CRM 1.2?
I have using MS CRM 1.2 and we seem to be limited in the notes section
for Phone calls and letters to 2000 characters which we find VERY
Is there any way around this at all?
> I have using MS CRM 1.2 and we seem to be limited in the notes section
> for Phone calls and letters to 2000 characters which we find VERY
> Is there any way around this at all?
...1 Report, Multiple Queries
I am trying to use the same report layout for multiple queries but am having
some trouble. The button code is:
Private Sub cmdOpenProjectReport_Click()
On Error GoTo Err_cmdOpenProjectReport_Click
Dim stDocName As String
stDocName = "rptStandard"
DoCmd.OpenReport stDocName, acPreview
Reports!rptStandard.RecordSource = "qryMainTopList"
The problem is that when I click the button I get an error messag...Outlook (2000) opens in 1x1 square
Suddenly today outlook started opening up, on screen, not
minimized, but the window was approximately 1x1 inches.
I've tried the maximize option and closing it while
maximized, I've tried everything I could think of that
has worked with Photo Editor or Word. Even checked
through the registry but I can't seem to find the
setting. Running Outlook 2000 on NT4.0.
What if you right click on the shortcut, choose properties and say
"Debbie" <email@example.com> wrote in message
>...Unexpected value in metabase smtpsvc\1\domain
I deleted all the domain keys and the db2mb key as suggested,
and when I restarted the exchange services and the smtp service,
the metabase was correctly repopulated.
I also got one I was not expecting: stirlingadvisory dot com.
I do not have a recipient policy for stirlingadvisory.
I have an SMTP connector that has stirlingadvisory in the address space.
Should I get rid of all my recipient policies?
Single Exchange 2003 in native mode on Windows Server 2003
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote:
>I deleted all the domai...CRM 1.2
i would like to have all documentation of crm 1.2 (implementation guide, user
guide, etc.....) in french version only.
is there someone who can help me?
Thanks to reply
You can read all information at
> i would like to have all documentation of crm 1.2 (implementation guide, user
> guide, etc.....) in french version only.
> is there someone who ...Excel 2007 Sheet with rows more than 15000
While working with excel sheets having rows more than 15000 lines, sometimes
I observe that the processing is slowed down if data more than 15000 lines is
selected. However the work is takes very less time if number of rows selected
are less than say 12000. I have 2GB RAM, Can someone help me on this issue?
I'm not sure what type of help you're looking for. Excel 2007 is what it is,
and you either need to select more than 15,000 rows or you don't. Other than
purchasing and installing more RAM on the computer or buying a newer, faster
computer with tons of RAM I'm not s...change a number (100) to word (i.e Hundred)
Dears, Is there a function or a way to change automatically a number typed
in a cell (eg: 100) as in tex format? (i.e Hundred)?
Take a look at
Excel FAQs - Convert Numbers To Text
(remove nothere from the email address if mailing direct)
"CHA Salam" <CHA Salam@discussions.microsoft.com> wrote in message
> Dears, Is there a function or a way to change automatically a number
> in a cell (eg: 100) as in tex for...GP10 on SQL 2000 MSDE on an XP Machine
I am dealing with a client that is running the most wacked out
configuration I have ever witnessed. He has 5 instances of SQL Server
running on his XP Machine ... all SQL Server 2000 (2 developer
editions, 3 MSDE) ... He was running GP 8 and GP 9 side by side.
Wooof! Then he tries to upgrade GP9 to GP10 and screws up somehow,
then decides to do a fresh install GP10 without switching ODBC
connections to one of his other SQL Server instances.
I have pretty much got him back to working ... He is running off one
of MSDE instances. He is only up to SP3. I was trying to upgrade him
to SP4...How do I make a Header stop printing on page 1 only?
Try this CB
Regards Ron de Bruin
"CB" <CB@discussions.microsoft.com> wrote in message news:14D5CA97-518E-4A45-BFEA-E1DB8F807DFD@microsoft.com...
Looking at your helpful code I wondered whether you have to specify the "To"
parameter. It doesn't look like it, as least this prints page 2 and
everything beyond it in Excel 2003 for me:
.RightHeader = "Your Header info"
ActiveSheet.PrintOut From:=1, To:=1