Help with a module
A few months ago I posted this question:
> I am trying to make the default value the date of the first monday in
> the month in an unbound box. Is there a way to do this?
I used the following solution by Arvin Meyer, but today I ran into a
problem. Since the first monday is the 5th and today is the 1st, I
need the first monday of last month instead. I know this only happens
a few days every month, but I thought there might be a way to fix
this. Could someone help me modify this module for this situation?
Paste the fol...Help old files and opening them
I have a file that is from Publisher for Win 95 ver 5.
It won't open in Pub98 which is the latest I have and I can't get it resent
as the author has passed away. Is there any way I can open this file?
Outgoing mail is certified Virus Free by AVG but the sender recommends that
Email virus scanning on your own machine in case of infection on route.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.675 / Virus Database: 437 - Release Date: 02/05/2004
Outgoing mail is certified Virus Free by AVG but the sender recommends that
you ...Help! I can't close MS Money!
When I try to close MS Money, it says it can't close.
Also, I can't get my reports to come up.
What might I have done to cause this?
Before that happened, I moved my backup files into a new
folder, and I moved some accounts from one Money file into
another Money file.
If anyone can help me get out of this bind, I will be so
In microsoft.public.money, inourmidst wrote:
>When I try to close MS Money, it says it can't close.
What is the actual error message?
>Also, I can't get my reports to come up.
>What might I have done to cause this?
>Bef...XP SP2 Right Click Cut issue
My Company developed an user interface tool, similar to Windows Paint
When i select multiple objects, right click, cut and then exit the tool
will cause the application to hang. I have to go to the task manager
and kill it, no other way.
this is written in VC++ and i'm new to VC++.
suggest me some ideas to fix this issue.
Thanks in advance.
> My Company developed an user interface tool, similar to Windows Paint
> When i select multiple objects, right click, cut and then exit the tool
> will cause the application to ha...Help
I have about 1500 entries from alleged tiawan addresses. My queue is flooded
and I need a quick way to remove these attampts. I would also like some
advice as to how to prevent this (we have relaying prohibited but that doesnt
prevent someone from trying and filling up the queue) . In any case any help
What type of messages are they? Are they NDR's being generated by your
server (sender of < > or administrator)? Are you referring to the outbound
If it is just NDR's being generated, it shouldn't be a huge issue, as the
remote dom...I need help adding columns
I have a spreadsheet with several differnt people. I need to add the columns
up per person. I want to add only those cells that has something in them. I
can get it to count all cells but I cant get it to calculate only thoses with
something in them. Please help
> I have a spreadsheet with several differnt people. I need to add the columns
> up per person. I want to add only those cells that has something in them. I
> can get it to count all cells but I cant get it to calculate only thoses with
> something in them. Please help
I think you are confused. You talk a...Issue with Automatic Calculation with Roll-up of Physical % Comple
I am having a issue with the automatic Roll-up calculation of Physical %
Complete. It sometimes does not calculate the Roll-up value properly. I
need to manually change each value for all the subtask to some other number,
then back to the original number to get the correct roll-up value. This can
be very annoying when I have many tasks to update manually. I tried
selecting the "Calculate Now" button in Tools->Options->Calculation dialog
box, but it does not work. Is there a way to automatically redue the
calculation for Roll-up of Physical % Complete. I am r...Excel Help stays on the tool bar- how can I use it
I have been unable to access Help while using Excel. I am using only 3
worksheets. The Help icon stays on the task bar, although a right click shows
'move' and 'size' and 'cancel', I can only cancel.
not sure but i think you may be clicking the wrong thing. on my xl, help is
a word on the worksheet menu bar.
Tools>customize>toolbar tab>check worksheet menu bar.
you should be a toolbar that sez....
file edit view insert format tools data window help
click help. follow the wizard.
"puzzled OAP" wrote:
> I have been unable t...Trying to publish using Publisher 2003 website. HELP!!
1. I have followed all the instructions outlined on the Publisher Web Design
2003 page. I always get the message "cannot find the URL ..." I am using the
same company to host another web site for me. I can upload to that website
and make changes, etc, with no problem. I must be missing someting basic, but
I can't figure out what.
I get this error message every time I start up publisher:
"Publisher cannot load the speller or dictionary.
To install the Spell Check and Hyphenation dictionary, run Publisher
Setup again and choose Custom Installatio...help on sorting data
I have a soccer grid result. So I would like the column corresponding
to the points of the teams sorted descending. But I want the other
column to follow. And I want the first column (rank) to remain still
and not affected by the sorting operation. How can I do that ?
Just select the columns you want to sort, and then sort.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Sam" <email@example.com> wrote in message
> I have a soccer ...Caption Issue
Currently working with Publisher 2003 Newsletter. I
selected a left to right gradient background. The
photograph in one column has a caption under it. The text
in the caption box has a white background. I want the
caption text to have the same gradient background as the
newsletter. I see now option to do this. Advice is
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from firstname.lastname@example.org <email@example.com>...
> The text
> in the caption box has a white background. I want the
> caption text to have the same gradient back...Cell Wrapping Help
I changed the default height of the cells on my spreadsheet to 17.25. I
have a cell "Comments" set to wrap text; however, it does not. If I
double-click on the far left column (e.g., the bottom of the cell in
question) it automatically adjusts.
I need this "Comments" cell to grow and enlarge as if the cell was at a
default height of 12.75.
Any ideas without having to double click on each cell? I have over 5,000
Thanks for the help!!
Nevermind, figured it out.
...HELP... Outlook Dissapearing Folder!
One of my folders in Outlook has just disappeared. I did not delete it and
am familiar with the prompt that appears when you delete a folder, asking if
you really want to remove the folder and move its contents to "Deleted
Items." I have checked the "Deleted Items" folder. I have confirmed that
it was not dragged anywhere. I have tried running scanpst.exe. I am out
of ideas and have lost of ton of e-mail... HELP!
WillW <WillW@att.net> wrote:
> One of my folders in Outlook has just disappeared. I did not delete
> it and am familiar with the pro...=?Utf-8?Q?Urgent!_Can=C2=B4t_add_outlook_to_exc?= =?Utf-8?Q?hange?=
In control panel I dont have the option of email profiles, just internet
mail. We are using OL2000 as a Pop client and now starting to use exchange.
What do I have to do (install/reinstall) so I can connect the OL2000 to
exchange. This behaivour is found on win2000 and XP
You'll need to change your installation mode from IMO to CW.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Properly back-up and restore your Outlook data
-Creating a Permanent New Mail Desktop Alert in Outlook 2003
"Tomppa&q...CRM 4 Mail Merge issue
When we are trying to do an email via mail merge with a marketing list
through a quick campaign we get the following error message right at the end
of the merge.
'The e-mail must have at least one recipient before it can be sent. Do you
want to send the e-mail? If you click Yes, the e-mail will be sent out, but
no corresponding activity will be created in Microsoft Dynamics CRM.'
We find we are having to click yes for every single marketing list member.
Any ideas on why this is occurring?
...Losing Database connection - Error Message inside
Just upgraded to 2.0 and...Losing Database connection on all of the machines
once or twice a day....error message below. Any ideas?
Database connection lost, application will be closed.
Error # - 2147467259
[DBNETLIB][ConnectionWrite (WrapperWrite ()).] General netwok error. Check
your network documentation.
(Source: Microsoft OLEDB Provider for SQL Server)
(SQL State: 08S01)
(Native Error: 11)
No Help file available.
SELECT GETDATE () AS Current Date Time
Are you using a wireless network? If so, you probably want to switch to a
wired network (wireless can have interference issu...CRM 4.0: Adding New User Issue
I just added new user to CRM 4.0, and assign specific role (Customer
Service Representatives) and default business unit to the user.
However, when the user tried to login, there's error message mention
something like the user doesn't have permission to view record. The
assigned role and business unit is the same with existing other user
that is able to login without problem. Then, we try to assign new role
(CSR Manager) to the user, and after that, the user is able to login.
So, we assume that something wrong with Customer Service
Representatives (CSR), although other CSR able ...Drop Down Menu Help #2
Leave a blank row? How would I do that? For the drop down, I use th
validation function, and it lets you list what you put in to the dro
down and you have to separate it by commas. a,b,c,d, ect. How would
do what you are suggesting
mcr1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1549
View this thread: http://www.excelforum.com/showthread.php?threadid=27475
Then you follow Debra's suggestion.
I took for granted that you were using a list contained in a named range,
where ...Countif, Sumif, If
This returns #Value. I don't think I need to sum the number of bul
deals - what I am looking to do is count how many of the bulk deals w
have done are over �10,000
Angel160's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1550
View this thread: http://www.excelforum.com/showthread.php?threadid=27494
Oh dear! I used the following data to model your query:
Non Bulk �1,000
How can I handle the WM_PASTE/CUT/COPY/CLEAR messages in a CRichEditCtrl when
the user click CTRL+V/X/C?
BOOL CMyRichEditCtrl::PreTranslateMessage(MSG* pMsg)
if (pMsg->message == WM_KEYDOWN)
if (pMsg->wParam == 'V' && GetKeyState(VK_CONTROL))
"Illuminator" <Illuminator@discussions.microsoft.com> wrote in message
> How can I handle the WM_PASTE/CUT/COPY/CLEAR messages in a CRichEdi...variable coding help
Dim Divis as string
Dim strWhere as string
Select Case optDivision.value
Divis = "Property"
Divis = "House"
Divis = ""
StrWhere = " WHERE qryExpense.Status = ""Expensed"" AND qryExpense.Div = " &
I get a message box asking me to input House, when that is what I would like
the criteria to be.
Teach me to fish! Thanks for the help.
Hi m stroup,
try in this way
StrWhere = " WHERE qryExpense.Status = ...SUMIFS help page online?
I don't have Excel 2007, so I cannot use offline help to learn about SUMIFS.
I've tried Google searches, but I have not found a canonical source of
online help for Excel SUMIFS per se.
I do find a tech ref page for the WorksheetFunction.SUMIFS method. That
should be the same. But that description is ambiguous; it does not answer
my question (below).
In another thread, T.Valko (Biff) wrote:
> The SUMPRODUCT equivalent:
That is the form of SUMIF...Help: Mutiple conditions
I have a problem about calculate bonus of the following condition
which bother me for a long time. Can anyone help me?
What foumula should be used? Thanks
How to satify with Bonus scheme 2 (showsin the following), I have trie
to use AND(OR(),OR()), but it will give a repeated answer.
I think using If funtion seems reasonable, but my answer still can no
satify Bonus scheme 3.
Name Qtr1 Qtr2 Qtr3 Qtr4 Annual Total
Mary 300 463 300 400 1000
John 430 530 510 503 2050
Tom ...microsoftoffice outlook2003 HELP
I just purchased Microsoft Office Outlook 2003. I
cant get it to display Newsgroups. I followed the
directions to configure it and nowhere is the word News
or newsgroups found. Help?
Outlook isn't a newsreader; it uses Outlook Express for this. To get the
news cmmand back set Outlook Express as the default newsreader in Control
Panel-> Internet Options-> tab Programs.
Also see; http://www.howto-outlook.com/faq/news.htm
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Navigation Pane Tips & Tricks
-Create an Office 2003 CD slipstreamed with ...Lookup / Match help ???
I have workbook down loaded from a training program and I would like to post
the date under a header for this person if he/she has taken this certian
training. I want to have this in a different workbook but link to the
training download book.
A B C D E F
1 SS# JOB# LNAME FNAME TRAINING DATEASS DATECOMP
2 the data for above header names in rows 1-7137
ALL THE DATA IN THIS FORMATE, 7137 ROWS. Each person will be listed many
times but with different training names.
Now on my sheet I...