Determining the last business date
Is there any way (at 5pm in the continental USA) I
can (fairly) conclusively determine the most recent date
on which the stock market was open?
This question comes from the following: If I have my
VBScript hop over to http://my.msn.com/ then I can
take a look at a fixed set of stock quotes (provided I
have set them up). However, I don't see the date
shown in any way.
Now, if I could guarantee that the script would be run
every day, then I could do some tricks (like checking
whether all the quotes are the same as the prior
accepted set - if so, I can assume the next date).
...Can I move down 12 rows in excel for every new entry
I am entering records of numbers which have formulas for calculation. I want
to place these records every 12 rows and be able to automate the worksheet
for our office personnel. How? HELP!! There can be anywhere from 50 to 150
records depending on how many batches are produced in manufacturing plant.
right click sheet tab>view code>copy\paste this. If not column A (1) then
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
"Mickey&...Z Report Customer Count vs Hourly Sales
My Z report shows customer count of 380 and hourly sales total of 384. Why
the difference? This happens all the time.
Your glass is:
Half-Empty : Do folks at register forget to ask "Is there anything else I
can help you with?"
Half-Full: Your impulse items at POS are working -- better late than never!
> My Z report shows customer count of 380 and hourly sales total of
> 384. Why the difference? This happens all the time.
OlyBikes Locally-Owned B...Can i apply 2 mailbox manager policies to the same mailstore ?
I have been reading up alot on this issue, and the only information i have
been able to find is that you cant run more then 1 exchange recipient policy
against the same user.
My issue - I want to have a seperate mailbox manager policy run against each
of my 4 mailstores to do a cleanup of inbox and sent / draft items. this
policy moves the mail items into the deleted items folder for each mailstore.
On top of this policy i want to have a policy that will delete all mail
items older then 60 or 90 days depending on the mailstore from the deleted
items, and delete them permanently. How ca...CRM Outlook Toolbar not for Delegates
I'm using Outlook 2002 and CRM 3.0 with the Outlook CRM Client installed.
I have delegate permission to edit my managers calendar.
This is available from my folder list.
When I create a new appointment from within my managers calendar the CRM
Toolbar is not available. It is also not available to be added using view,
Could you tell me how to make the CRM Toolbar available in other Calendars
as well as my own please.
...Can't Upgrade from 2004 to 2005
Several months ago, a creeping corruption problem that caused me to
spend weeks manually reconstructing transactions, destroyed my
confidence in Money's ability to maintain my data.
When I tried to updgrade from Money 2004 to Money 2005, it insisted that
I disable bill pay and that it would re-enable it. Instead of
re-enabling bill pay on the same account, it created a new empty account
and attached bill pay to that. There is no obvious way to correct this
and the new help system is totally useless. In the few days I had Money
2005 I never found a single answer to a question i...Changing a custom field length
We have created a custom section and there is a field (in that custom
section) whose length has to be changed from 100 to 500 of nvarchar
datatype, but the interface does not allow more than 100 for nvarchar.
I couldnt modify the format of textbox to textarea as it is disabled
nor i can change the datatype to another datatype. can anybody please
help me with this??
Unfortunately you'll have to recreate the field, as you can neither increse
the length of a text field nor change it's format after it's been created.
Then there's a question of what to do with any existing...CRM over VPN 02-21-05
Has anyone managed to get Sales for Outlook to work over
a VPN Connection. Can fully install, operate and sync
when connected via VPN. But as soon as I go offline,
cannot access any of the data stored locally. Keeps
stating Access Denied.
Anyone got any ideas?
The issue you are running into is already addressed via hotfix, please call CRM Support for fix 892352 (Title: "Permission denied" error accessing folders in
Microsoft CRM 1.2 Sales for Outlook when offline ). The KB is i...How do I create custom postcards in Word 2007?
I want to create my own postcards using the right size and type of paper for
This depends entirely on your printer. Can it handle the heavy weight
of card used in postcards, and can it handle the unusual size of a
On Apr 18, 2:54=A0pm, Create Custom Postcards <Create Custom
> I want to create my own postcards using the right size and type of paper =
Perhaps the easiest way to start is to get some Avery (or similar) postcard
stock, which will have two postcards per sheet. Then find the a...Mail Relaying denied error message, how can it be fixed???
I setup outlook express smtp to use incoming: mail.tpg.com.au
I can successfully receive emails and read newsgroup but I can't send out
emails because it keep on return the below error message, how can it be
fixed so that I can send emails? Thanks...
The error message when sending is:::
The message could not be sent because one of the recipients was rejected by
the server. The rejected e-mail address was 'firstname.lastname@example.org'. Subject
'Re: Again', Account: 'mail.tpg.com.au', Server: &...How can i stop same data being repeated in a column
I have a list of contract numbers relating to application numbers or
payments. they are in the format nnnnnnan or nnnnnnpn. The columns are fixed
to this format only. If they are entered with the a or p in the wrong place
or if they have been left out completely an error message will appear to
alert the user. I want to know how to alert the user if they enter an
application or a payment number that has already been entered.
ie if they enter 022079a4 but that same application has been entered else
where in the column.
Hope you can help
See Chip Pearson's
http://www.cpearson....CRM Install and Config exam
Having just failed the CRM 1.0 Install and Config exam twice (once with 76%
and today with 78% - aargh!), I'd like to ask if anyone here passed it and
how the flip they managed to do it?
In their infinite wisdom, my company chose not to send me on the actual
training course, so I tried to piece together the information from the
Implementation Guide and the rather pathetic (and *beta* based!) eLearning
course. And obviously failed.
Either I'm missing some important information, or I just don't get the
questions. (I've never seen so many spelling mistakes and daft questions in
...ftp server or I can saved from Ecxel? #2
I need to fine out how to save a hml workbook onto my website do I need to
use ftp server or I can saved from Ecxel?
...can`t print single checks
when I try to print a single check, the blue print icon
will not come up and can not print any new checks , but if
I try to reprint a previous check I have no trouble
I'm not sure exactly what issue you are describing, but read
"sp" <email@example.com> wrote in message
> when I try to print a single check, the blue print icon
> will not come up and can not print any new checks , but if
> I try to reprint a previous check I have no trouble
...Outlook 2003 Can't Open Item MS OFFICE FAILED
Yikes, I'm having a real problem. I am running
Windows XP with Service Pack 2 Home Edition
Office 2003 with Service Pack 2 (only have Outlook and Word installed)
Toshiba Notebook M15-S405 Satellite Pro
1.4 ghz with 512 mgs ram
I woke up one morning and saw that I had a stop error window open on my
computer explaining that Windows had encountered some kind of driver
error and that windows had to restart. Windows offered that I review
my system for serious errors. That is a very sad thing to wake up to.
So I ran a chkdsk and defragged and a virus check. No problems there.
I checked my ...Fixed Assets across business lines
Hello everybody -
Is it possible to spread fixed asset depreciation across multiple business
lines? We have certain assets that need to be depreciated across multiple GL
accounts..is this possible?
The simplest solution would be to use an allocation account (probably
a fixed allocation account) as the depreciation expense account. This
would spread the depreciation based on the percentages in the
allocation account to multiple accounts.
On Sep 27, 4:25=A0pm, modon...@knight.com
> Hello everybody -
> Is it possible ...Can I convert footnote numbers to text
I'm working with a document where the author has used the automated endnote
facility in Word. Since this is about to be translated into Quark for
typesetting, I need the endnote marks and the numbers with the endnotes to be
real numbers, not endnote marks -- Quark will not read them as numbers.
I was sure I did the conversion using ActiveDocument.ConvertNumbersToText in
Visual Basic once before, but I can't seem to make it work. Help! There are
20 chapters with about 40 endnotes each.
ActiveDocument.ConvertNumbersToText only works with paragraph numbering (and
LISTNUM fi...Merge Cells I can't find
I was trying to hide a column, and got a message that I couldn't, because
cells in another column were involved. I don't see those cells, and "merge"
is turned off. Any suggestions for finding them?
This quick macro will remove all merges on the current sheet:
You can, of course define a range instead.
"Actually, I *am* a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
"Ed Kearns" wrote:
> I was trying to hide a column, and got a message that I couldn't...Problem: CRM over Cisco WebVPN
Has anyone used Cisco's (3005) WebVPPN with MBS CRM. Other Apps work fine
put CRM wont. Errors with "Method Not Allowed", or "Not Authorized" even
before a login prompt.
What could we look for?
Darryl - firstname.lastname@example.org -www.mtccrm.com - Only Microsoft CRM
check to make sure ports arent beign blocked. I think my client is using
this system for vpn without issue
Microsoft CRM MVP
"Darryl Henderson" <DarrylHenderson@discussions.microsoft.com> wrote in
message news:FE72D066-D704-4338-8D85-E6A7DD0648AB@m...Send Fax with .doc and/or .pdf and .xls attachments from CRM SBS
When working with FAX the most common documents to be send are doc,pdf or xls.
All these are in CRM not supported and are not working reliable although CRM
is propagated as the perfect application to interact with MS-Office
In my opinion they should become supported and tested as soon as possible.
Here are our test results regarding send FAX with doc files attachments
Simple Word file with just 1 line of text, and a short English filename [25
KB]. Successfully sent.
Word file with a table tha...Can I install my copy of Access on 2 computers? My Desktop & my Laptop ?
Some software allows more than one installation... maybe one for your
regular desktop and another for your laptop.
Does MS allow this for a single license copy of MS Access?
Thanks for any help.
"Mel" <email@example.com> wrote
> Some software allows more than one installation...
> maybe one for your regular desktop and another
> for your laptop.
> Does MS allow this for a single license copy of MS Access?
You'd have to read the End User License Agreement that came with your copy
of Access. Licenses vary depending on version, ti...New Free Microsoft CRM Add On
New free add on from CRMeXtension: www.CRMeXtension.com
...Can I retrieve the key of my record?
I am creating a record using the following code:
Set qd = db.QueryDefs("Append Purchase Order")
qd.Parameters("pSUPPLIER").Value = [Forms]![Purchase Orders].Form.
The key field in Purchase Orders is PK_PurchaseOrder.
Is there any way I can retrieve the key of the record just created?
Assuming these are Access (JET) tables in Access 2000 or later, try this
kind of thing:
Function ShowIdentity() As Variant
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = DBEngine(0)(0)
db.Execute &q...How to zoom Excel generated webpage to fit a smaller frame size
I am using Excel to generate HTML pages for posting on web. However, I
would like to 'zoom' the web page to a smaller size to fit a smaller frame
size. Do you know of a quick way to do so? If possible, I would like
to look for a way to fit the Excel generated web page for different frame
...How can I update my "Publisher for Windows 95"?
I have "Microsoft Publisher for Windows 95," and I'd like to update it to a
more recent version. Currently, my OS is Windows XP. How can I do this?
> I have "Microsoft Publisher for Windows 95," and I'd like to update it to a
> more recent version. Currently, my OS is Windows XP. How can I do this?
The current version of Publisher is Publisher 2007, available at most
software stores as well as online. Check that your computer meets the
system requirements before purchasing. Publisher has undergone rather a
substantial number of chan...