calculate how many 'work days' in a month / week
currently i have a formula (thanks to this NG) that calculates how
many days there are in a month. is there a way to extend this formula
to calculate the number of work days (mon-fri) there are in that
Use the NETWORKDAYS function:
Microsoft Excel MVP
"Chuck" <firstname.lastname@example.org> wrote in message
> hi guys,
> currently i have a formula (thanks to this NG) that calculates how
> many days there are in a month. is there a way to ...Passwords work only when issued from the GP instance they're set f
Database is: "Microsoft SQL Server 2005 - 9.00.4035.00 (X64) on Windows 2008
Build 6002: Service Pack 2 64-bit.
Dynamics is deployed via Terminal Services on a Windows 2003 SP2 32-bit
Dynamics was installed on both servers using the base v10 CDs and then
upgraded to the lates pre SP4 hotfix 10.00.1328 (KB971014) on both servers.
Now the weird part. I can log in as 'sa' on both servers no problem.
However, if I login to Dynamics on the TS as 'sa' and reset my password, I
can log into the TS with my username & password but can't login from GP on
...Hyperlinks Don't work in SAW VML IFRAME
Visio 2003 Prof
1. Hyperlinks in SAW to VML (no IFRAME) work OK.
2. Hyperlinks in SAW to VML (with IFRAME) do not work OK (blank IFRAME)
3. Hyperlinks in SAW to SVG (no IFRAME) work OK.
4. Hyperlinks in SAW to SVG (with IFRAME) work OK.
(Hyerlinks are to other pages within the same document):
not correctly form their hyperlinks when they are within an IFRAME.
Has anyone fixed this?
Are MS going to fix this?
You don't list the options you are selecting when using the Visio 2003 Save
as Web featu...Money 05 cuts off data
B of A (Washington) using Yodlee & msn to sync data.
The problem I'm experiencing is that the Payee field is being cut off. I've
used /using the Payee Rules Manager, which has been working to a certain
extent. My question is... What is the size limit for the payee field? A
typical transaction from bofa(WA) looks like "PURCHASE 5xx29xxx658xxxxx3 ON
12/30 AT CASTLE ICE RENTON WA" When synced as configured above all i get is
a very small portion, maybe part of the actual name.
Second question is when trying to do a manual export from bofa (Wa) website
I have the opt...macro for comparing fields in two work books
I have two excel spread sheets (say A1 & A2). A1- is the master sprea
sheet and A2 is smaller spread sheet with very few details.
Suppose Column B in A2 has 100 partnumbers and Column C in A1 has th
superset of partumbers (1000) and corresponding details for each par
number, I need to:
1. Check if all the 100 part numbers in A2 has a corresponding match i
2. Extract the info for the matched partnumbers from A1 and list in
3. Even if there in no match A1, let's say for 40 of them, it shoul
still list those parts in the new sheet.
Can anybody help me with t...Not working...
I tried to do it, but it is still not working.
But, I noticed something strange today.
If I open my application, then I move to another application, or
minimize it - and when I retore my application, it looks fine!!
I don't know what is going on...
Any help will be appreciate!!
Just a thought...
If you explained what the problem was, you would probably have a much better
chance of getting someone who could figure out why it is happening.
I don't know if you've already discussed it in a thread somewhere but this
post was not connected with any previous posts.
Jona...Will Publisher 97 work with later versions of windows?
just wondering if publisher 97 will work with later
versions of windows such as XP or ME and suchlike?
Mary Sauer MS MVP
"belly483" <email@example.com> wrote in message
> just wondering if publisher 97 will work with later
> versions of windows such as XP or ME and suchlike?
Whilst attempting to develop brick-based storage technology, Ed reads a
message from belly483 <firstname.lastname@example.org>
> just wondering if publisher 97 will wo...Rules Not Working
Is there any reason why none of the rules I created in WLM work??? They're
for my ISP email, not Hotmail. When I "apply" them, WLM goes through the
motions but none of my emails mentioned in the rules get moved to their
designated folders. I don't have Outlook on this particular computer nor do
I have any intentions of installing it. I'm using Vista as well.
Thanks In Advance
This is a multi-part message in MIME format.
Content-Transf...Conver Numbers to Log 10
How do I convert column of numbers (n=3000) to log 10 column of numbers?
Assuming that your column is column A, one way:
In an unused column, enter
and copy down 3000 cells.
Copy the column, choose column A and choose Edit/Paste Special,
selecting the Values radio button.
In article <0CDE6301-FC9C-488C-9D9F-3AD26B46EFCE@microsoft.com>,
"Fishfan" <Fishfan@discussions.microsoft.com> wrote:
> How do I convert column of numbers (n=3000) to log 10 column of numbers?
...Does Multi-Field Index Work For Date/Time Values Only
I created a MS-Access DB table with the following 3 columns:
ColID - PRIMARY KEY
Col1 - Number
Col2 - Date/Time
Next I created a multi-field index using Col1 & Col2. I entered the
following row in the 1st row:
Next when I tried to add the above row again, as expected, I wasn't
allowed to enter the same row. Next I entered the following 2 rows:
Both the rows were accepted. After this I deleted the 3 records, went
back to the design view & changed the data type of Col2 from Date/Time
to Number keeping the multi-field index...Calling VBA subroutine from a query?
Can I call a VBA subroutine from within an Access query? I wrote some English
to Metric conversion routines in the Access VBA code and would like to run a
query on the data that will return coverted values. I need to be able to
execute this from outside the database (run the query from another program).
Yes. The function must be a Public Function in a standard module. You use a
calculated control to return the results of the query.
Dave Hargis, Microsoft Access MVP
> Can I call a VBA subroutine from within an ..."with <string> in sender" clause works on substring (matches on too many senders)
Outlook 2002 SP-3
I don't send myself e-mails but spammers would like to pretend that I
do. They often must put something in the From header to be RFC
compliant, so they throw in the same e-mail address as they shoved in
the To header.
Say I have an account called email@example.com. I define the rule:
Apply after receiving a message
with firstname.lastname@example.org in sender
stop processing more rules
Looks good until you realize the match is on a substring rather than an
exact match on the sender's full e-mail address. The messages do get
deleted if I sen...Custom Report 03-19-10
There is no way for me to run a report on Buydown Pricing, is there anyone
who has a report for this option?
If not, can someone write a custom report for it, and how much might
something like this run me?
I would like it to do something like buydown quantity greater/less/equal and
same for buydown price...
please contact me at nagarra @ yahoo . com or respond here with your contact
...WLM Stopped working 02-20-10
I'm running Vista Home Premium, SP2, 2 GB of RAM, Firefox, WLM, all WU's
I was in WLM mail newsgroups earlier today and things just stopped. WLM
stopped responding. Now I cannot log into WLM. It used to log into window
Live by itself (password and all) from my desktop icon, but now the only
thing that happens when I try to open my WLM app window is I'm taken to IE
(7). Then when when I try to sign in Windows live it won't do it.
I've already ran SAS, MBAM, CCleaner and Avira in Safe mode but found
nothing. Then I did a system restore back to a fe...Button on Form to Run Report based on Query with Parameters
I am busy working on a stock control database (and job control).
When I have a Form Open, it shows several fields, including JobID (Which is
the PK for that job) (frm_Invoicing)
I also have a Query that when Run, it prompts for the JobIDNo.
I have a report based on that query. (rpt_CustJobsInvStock)
I have added a button onto the form (onclick -> DoCmd.OpenReport) to open
and automatically print the report,
But I just cannot figure out how to get it to get my JobID from the form,
and to Automatically add it as a Parameter for the que...Email server 02-13-10
The smtp outgoing email with VISTA cannot be authenicated.
Vista is not an e-mail client. Please post the error message in its
entirety. You can left click on it to highlight and then right click to
copy and then paste it into this thread.
Imperial Beach, CA
"Charles" <Charles@discussions.microsoft.com> wrote in message
> The smtp outgoing email with VISTA cannot be authenicated.
I had wanted to set up a separate identify to get my work e-mail as Windows
Mail, rather than the webmail from my ISP; didn't know until after completing
the process that Windows Mail combined both personal and work e-mail into one
account. If I "undo" it, popup says I'll lose all of my work e-mail. How can
I save it and undo the dual identities?
Windows Mail doesn't have identities.
You can add multiple accounts, via Tools - Accounts - Add, but Windows Mail
doesn't have identities or a password option.......print preview does not match page i am working on
In this white space (not the subject line), let us about the problem in more
If print preview is showing only part of the worksheet, then you need to
reset the print area in the File | Print Area dialogs
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"gillygalloo" <email@example.com> wrote in message
...Reply button doesn't work in Outlook 2003
I just re-installed Office 2003 on my Windows Server 2003 SP1. Outlook kept
refusing to open, wanting to send an error report to Microsoft and then ask
to open in safe mode only to refuse to open in Safe Mode as well. So I
installed SP1 which didn't help. Then I installed SP2 which fixed that
problem. But I cannot reply to any messages. After I open an email I click
the Reply but nothing happens. Can anyone help?
Sounds like office was installed before terminal services. Try uninstalling
and reinstalling office.
Your Termi...User login failed on the customized VBA project after GP 10 upgrad
After GP 10 upgrade, I am getting the login failed error for all useers who
tried on working on my customized Dynamics VBA project.
Error # -2147217843: Login failed for user 'sa'.
Procedure: frmDateEntry - cmdProcess_Click
Source: Microsoft OLE DB Provider for SQL Server
Thanks for help.
You might need to re look at your connection in VBA
"Kevin Zhou" wrote:
> After GP 10 upgrade, I am getting the login failed error for all useers who
> tried on working on my customized Dynamic...Customization 10-13-04
I want to add a field "Company" to my contact information.
I have entered a new field called "Company" in the
attributes of the schema "Contacts" and it is listed
there as "CFSCompany" as a string.
I then went to customization in crm settings and edited
the "Contact" fields by removing "Middle Name" and
adding "Company". I then save this new layout.
However when I go to "New Contact" the "Company" field is
not there and "Middle Name" is still there.
What step am I missing to publish this...Complusory Work Order
I am trying to make qork order as the default input screen.
That is when a sale is done instead of it being a invoice or receipt it
needs to be a work order. I know this can be achived via macro or using the
WORK ORDER fuction already avaiable. But i was hoping if there was a way to
actually get the POS started in Work order screen by default.
It can be done with an add-in. Ask your reseller for help with this...
Tiber Creek Consulting
Please DO NOT respo...How to have margin-left: 10%; margin-right: 10%; only sometimes??
My website is created so that the width is not fixed. I adapt to the width
of the browser. If I have a page of text I do something like:
<div style=" margin-left: 10%; margin-right: 10%;">
so the text is set off by margins.
That's nice on my monitor's 1600 pixel wide screen.
But on a laptop (or as a user option) I'd like to change that to no margins.
Can you suggest a way of doing that without having two .css files?
On May 16, 10:25=A0pm, " Cal Who" <CalWhoNOS...@roadrunner.com> wrote:
> My website is c...Formula Not Working Properly
I have the formula below and have tried copying it down column in macro. It
will calculate the first cell "Q2" properly, but copies the same calculation
from Q2 to all other cells. If I click in the formula and then the check
mark to the left of formula, it calculates properly in the cell.
How can I make it calculate properly from the macro? Also the range will
change with each import to the worksheet the macro is applied to. How can I
write the macro to apply to all cells in column Q where there is data in
other columns in formula?