Is there an Excel formula to round a date to the end of the month
User enters a specific date, I'd like to round that entry to the end of the
With a date in A1:
step into the next month and then back one day.
Gary''s Student - gsnu201003
> User enters a specific date, I'd like to round that entry to the end of the
This requires the Analysis ToolPak add-in be installed for Excel versions
prior to Excel 2007.
A1 = some date
Format as Date
Microsoft Excel MVP
��� ����� access?
��� ���� ������������ access?
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5167 (20100602) __________
The message was checked by ESET NOD32 Antivirus.
...how do i plot this kind of data using excel
need a help in plotting data presented in class form, e.g; variables for A in
condition 1 ranges from 67-89, in condition 2they range from 52-67, in
condition 3; 65-87, in conditon 4, 62-83.
Variables for B in condition 1 60-77,in condition 2, 50-64, in condition 3,
54-73, in condition 4 51-70
Try setting your data up like this:
A1 67 89
B1 60 77
A2 52 67
B2 50 64
A3 65 87
B3 54 73
A4 62 83
B4 51 70
Then, plot it using either a clustered column chart or a stacked column chart.
> need a he...Cannot access more than 250 items in a folder
My company has a custom Outlook form for handling vacation and sick time
requests. The form has fields for start date/time, end date/time, name,
I'm trying to write some code that will process a bunch of saved requests
and display some totals, but I'm having trouble. The code simply stops
working after about the 250th item in a folder. Any attempt to get at
the custom properties of any item after the 250th is a blank.
Here's some very simple code I wrote to illustrate the problem. It loops
through each saved item and checks if the "requestor" property contains
...Cannot access CRM
We have just migrated from Groupwise to Exchange 2003 as part of our move to
CRM. The migration had some issues but those have been resolved. There is one
user whose mailbox was deleted and recreated as part of the troubleshooting.
His Exchange account appears to be functioning correctly now. The problem is
the user is now unable to access the CRM website, whereas he could before the
migration. I discovered the problem when trying to install the CRM Sales For
Outlook client on his workstation. When I was prompted to enter the URL of
the CRM website, I received an error message saying &q...Triggers on Extender windows
Is it possible for writing a Trigger on any of the Extender windows which we
I tried with one Extender screen, but the trigger fails to register, saying
Any immediate response would be great.
Thanks & Regards,
Extender uses multiple identical generic windows with multiple sets of
generic fields of the various data types.
You will not know which window is being used and what it is being used for,
or what fields will be shown at any time.
I am yet to see anyone successfully write a customisation (Dexterity or VBA)
against ...Unable to upgrade to Access 2000 from Access 97 and preserver Access 97
I have a workstation running W2K Service pack 4. On the machine is
Access 97. When I load Access 2000 to a unique directory it skips the
part on asking me to preserve Access 97. After the install 97 is
I removed Access 2000 and installed Access 97 again. I tried to
install Access 2000 into the same directory as 97 and it still skips
that step of asking me to preserve.
Anyone know if this is a registry setting that is having me skip this?
I tried both an upgrade version of Access 2000 and a full version of
If you do a *...Excel
Can someone please help me. I have been trying to figure this one out all
day. It seems so simple, I guess I'm brain dead.
I'm trying to write a formula that will return results for the folowing
aaa A A B B A
bbb C A B B C
ccc A A B B B
aaa C C A A B
bbb C A B B C
ccc A A C C A
I need a formula that will count the total number of times each of the colum
results (A,B and C) appear for e...Update the taskbar when minmized
I am looking to implement a feature that will update the text in the
status bar when my application is minimized.
Basically, when performing a long operation, if the users minimizes the
application, I want to display the current progress as a percentage
I'm using XP / C++ 6.0 and my application is a dialog-based.
I've tried the following code but nothing changed on the taskbar.
CPaintDC dc(this); // device context for painting
SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);
// Center i...Require approval of out-going e-mail messages
I am looking for a way to provide Exchange 2003 users
outbound e-mail, but to configure it so that it cannot
leave the server until it has been approved by another
party. My client wants to read, and approve, all
outbound e-mail from their server. I know that something
like this exists for placing appointments on a shared
calendar. In that situation, the moderator must approve
the appointment before it can be added to the calendar.
I am looking for something similar for outbound e-mail.
Does anyone have any idea?
If you use a smart relay host at the gateway, you...Access 2007 and Windows 7 11-22-09
I just got a new 64 bit computer with winodws 7. I moved my access 2007 file
over to the new machine and opened it.
I keep getting undefined errors for the right and left functions. Any ideas?
Check to make sure all of your references are what they should be. I don't
know what "standards" windows 7 may or may not have but the errors you
describe are almost always a reference issue.
"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
...exchange and directory access
I have 2 dc in a domain, in exch2003 system-administration, [server
name]/properties/directory access, i could see both dc are set to DC&GC, and
PDC is set to type(configuration) also.
If i shutdown one of dc(not PDC role), i couldn't open system-administration
console in exch2003.
Is this normal, i mean, whether it's possible to open SA console when i
shutdown one of or both of dc?
You can't open Exchange System Manager? What happens when you try?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
&q...Can anyone work out the ED50 value on an graph on Excel?
I need to construct log dose response curves. I can do this by converting the
values on the x axis into log10 values.
I am stuck to how to get the ED50 values... (ed50 is basically the median
On Mon, 26 Nov 2007, in microsoft.public.excel.charting,
naf <firstname.lastname@example.org> said:
>I need to construct log dose response curves. I can do this by converting the
>values on the x axis into log10 values.
>I am stuck to how to get the ED50 values... (ed50 is basically the median
Don't work out ED50 using a chart, work it out using sprea...Can't open my Access files after conversion from Access 97 to Access 2003
After I converted my MS Access files from ver 97 to 2003, I cannot open them
How can I resolve this problem?
I run Windows XP Pro SP 3.
It isn't clear what's happening when you try ... more information, please.
Are you attempting to open them with Access '97 or with Access 2003?
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereo...IE not installing ActiveX under Windows 2003 ...
I have an ATL ActiveX Control (a dll). IE6 can download and install it fine
with IE default security settings. But under Windows 2003, I have to set IE
Security Settings to "Download signed ActiveX controls" to "Enable" for the
IE to be able to download and install the control; it prompts for installing
the control but after that it does nothing.
Any thoughts is appreciated. Thanks in advance!
Is the control signed? Do you enable active scripting? Has the control been
marked safe for scripting?
...How do you save and share "user-defined chart type's" in Excel?
...Problem accessing OWA from other domains.
We have a problem with users from different domains
trying to access mailbox using OWA 2003 located in our
domain. User gets prompted for credentials, it looks like
is being authenticated but after a minute or so Explorer
shows "page cannot be displayed"
User from our domain use OWA without any problems.
This is our setup:
Domain A is our w2k3 root domain.
We have 5 child domains B, C, D, E, F
Each domain except for A (root) has an Exchange 2003
server, but only my domain - B has the OWA installed on a
front end server.
We have trusts in place between all domains a...OE removes access to attachments
I am having a problem with receiving attachments to my
emails. If I double click on some of my emails, the tag
line for the attachment reads: OE removed access to the
following unsafe attachments to your mail: Insert Name
How do I turn this off? The last one it happened to was
from my sister, so I know it was safe and I have a virus
program to take of scanning for problems.
Thanks to anyone for help with this.
LeAnn <email@example.com> wrote:
> I am having a problem with receiving attachments to my
> emails. If I double click on some o...WOA Access Permission
I'm running SBS2003 with exchange 2003 server. I already have setup Web
Outlook Access for my exchange 2003 server. I have about 20 account users, is
there a way to set so that only certain user can use web outlook access ?
Thanks in advance
I'm not positive that this applies to the SBS version, but to allow
(or disallow) access for any single user to any of the supported
services and protocols in Exchange 2003, you need to change the
settings on the actual user account in ADUC that has the Exchange
extensions (usually the Exchange server itself)
The setting you're look...Launching Excel Using .bat file
I'm trying to launch "File.xls" with "Auto_Open.mac using
a .bat file. This works fine if I run it directly on the
sever but If I launch this remotely from an iseries OS400
the .xls sheet says that it has been modified but does not
Has anyone come across this sort of remote control access
A file is in the "access 2.0 file format"
How can it be changed to "access 2003 format"?
Have a look at the Access 2.0 Converter:
Arvin Meyer, MCP, MVP
"Khalil Handal" <firstname.lastname@example.org> wrote in message
> A file is in the "access 2.0 file format"
> How can it be changed to "access 2003 format"?
Download...120 day moving graph window
I have a 600 row long data set. I have several graphs set up to look
at this data.
I have put scroll bars on a couple of them. This allows me to reduce
the number of points being looked at.
What I would like to do is create a graph that looks at 120 data
points at a time. I would like the scroll bar to move the 120 point
refereneces from the top of the data set to the bottom of the set.
The idea is to be able to view any 120 consecutive data points within
my data set.
Can this be done with worksheet formulas?
I've been able to generate the 120 ce...is office 2003 compatible with windows 7
I have a new computer - still in box
I use office 2003 student teacher edition
I have the disc but is now 7 years old (all those updates since!)
Can I put it on new computer? Is there a quicker way - for example norton
have given me a product key to install direct from web
Be grateful for help as support wants £46 to answer :(
Compatible, Yes (having first uninstalled any Trial & its Activation
Assistant & rebooted)
Norton has got nothing to do with it, other that depending on version of
Norton it can cause problems with various Office components
Office 2...OWA: Embedded URL access error
When I use OWA, everything works ok except that
- When I click on a URL embedded in an email (say www.yahoo.com)
I get a user login prompt (instead of a new browser window with th
- Similarly, when click on the Logoff link, I get the same use
Any help in debugging this will be appreciated
...I have 2 Access DB with linked tables
In DB 1 is frmTokenDelivery and in DB 2 are tblImageBuild and
tblHardwareRequest. I link to the tables from DB1. The DBs belongs to two
seperate departments. The two departments perform seperate operations that
must be completed before hardware is delivered to the user or to another
dept. for further action.
I want to display a date in DB 2 on frmTokenDelivery in DB 1. Field in DB 2
is ProDate (i.e projected dated). Sorry for the long explaination. Any
assistance will be highly appreciated!
> In DB 1 is frmTokenDelivery and in DB 2 are tblIm...