default appointment times problems
When i re-open outlook and go to the calender, all the appointments times
have changed to 1am on the start day - 1am on the day after it waqs meant to
finish. So a 12 day appointment is now shown as over 2 days.
How do you change the default appointment time settings so an appointment
which is just typed into the day is from 9am - 5pm for example and will stay
as a 1 day event when opening and closing outlook?
All day events are 12 -12, not 9-5. If you want it 9-5, you need to make it
All day appointment change to 1 -1 if you change the time zone or DST
settings aft...Help with functions
If I have the following formula in a worksheet to bring up a message box
How can I use a function to transfer some information from different cells
to a new worksheet
if the formula above works?
You can't have a function transfer information to another cell, it will
return it's info in the cell where it's located, you would need a formula(s)
in the cells where you want this information. Otherwise you would need VBA
> If I have the following formula in a worksheet to bring up a me...Help from Dave Peterson
Please see thread headed "Copying multiple sheets from one book 2 another
and undertake special " dated 2/8/05.
I have added some more text in there as I have finally got round to doing it
and have experienced some problems. My name shows up as "Ann" rather than
Pank as my good lady has been using my account.
I am getting alot of spam sent to my domain that does not have an actual
email address. The problem is that the server then tries to send a message to
the sender (who is bogus) with a delivery failure.
My ISP has since shut down may mail once already.
How can i stop the server from responding to mail coming in with incorrect
adresses. I am using exchange 2k3 and windows enterprise edition 2k3.
I am new to exchange and still in the process of learning it.
Any help would really be appreciated.
Are the SMTP addresses incorrect or are they blank? You can configure
Exchange's Sender F...multiple outlets centralized Inventory needs POS solution
One of our customer has multiple outlets. Selling is conducted through the
outlets. they have a centralized warehouse. A POS solution is required
Contact your local RMS dealer he can help. Store ops in each location then
HQ in warehouse.
"Haresh_ahuja" <Haresh_ahuja@discussions.microsoft.com> wrote in message
> One of our customer has multiple outlets. Selling is conducted through the
> outlets. they have a centralized warehouse. A POS solution is required
You need a HQ for the warehouse and store op...Help please, can't start up!!
When I start the PC, after the loading bar for Microsoft thing
finishes,instead of going to login screen it gives me a blue screen, and
it says Page_fault_in_nonpaged_area.
This just happened overnight!!!!
Help please. :(
Here are some hints ( 'Bug Check 0x50: PAGE_FAULT_IN_NONPAGED_AREA'
(http://msdn.microsoft.com/en-us/library/ms793437.aspx) ). Try starting
the system in safe mode (keep tapping F8 after power-on).
- I use Spyware Doctor scan every few days
- I left my computer on for the night like always,and ...help need to match a string
Hope someone have a solution for me.
I have a table with product name and price in column a & b in sheet1
I have the formula in sheet2 where I input the product name in A1 an
it search the product and give me the price.
It works ok.
Here my problem:
I have a product name called "HK-2859 plus" and I need this product t
be identified if I enter any portion of this product ("HK" or "2859" o
appreciate your help
Message posted from http://www.ExcelForum.com
one way: Use t...Please help me solve my problem
Hi, I Have a cell say a1 that has a continuously changing number it
in and I want to track the highest number that it prints, and the
same for the lowest number in cell a2. I would like these results to
show up in the cells below them
Im very new to programming and your help would be much appreciated
On Mar 5, 1:01=A0pm, Sacha David <sach1...@googlemail.com> wrote:
> Hi, =A0I Have a cell say a1 that has a continuously changing number it
> in and I want to track the highest number that it prints, =A0and the
> same for the lowest number i...Help needed with the last hurdle on this project
I've finally reached the limits of my Excel knowledge (what littl
there was) and need some help to complete my project.
What's missing now is some automation to make what I need to do a lo
more user friendly.
My problem (for anyone generous enough to tackle it) is posted below.
It's a lot of text but it's the most concise way of explaining what
want to be able to do.
I've attached a file with the Excel work as far as I have been able t
Thanks to anyone who gives this a crack - it's very much appreciated.
Take the data from Column A and Co...SBS 2k and Exchange 2k Help
I'm having a problem with Exhange 2000.
I support an office of about 5 people, and they are running SBS2000
with Exchange 2000, during the past couple of days they haven't been
able to send/receive e-mail, and they haven't been able to browse the
I initially thought the server was being used for Relaying, however the
queues are not very high (about 14 e-mails) and the Telnet tests
suggest it can't be used for relaying.
When I got there last night the server was fine and after a quick
re-boot I sent numerous e-mails to my home account which I received,
and I...[Help] OnPaint Skipped?
I have an CTestWnd defined as follow
class CTestWnd : public CWnd
afx_msg void OnPaint();
and i create an instance of CTestWnd as a child window of hWndParent
lpClassName=AfxRegisterWndClass(CS_VREDRAW | CS_HREDRAW |CS_GLOBALCLASS,
::LoadCursor(NULL, IDC_ARROW),(HBRUSH) ::GetStockObject(WHITE_BRUSH),
m_Wnd.CreateEx(NULL,lpClassName, _T("TEST"...Management Reporter
Please can you explain to me why if MR is run on IIS why it cannot be
accessed as a website and instead seems to need a MR client installed?
If it is possible to run \ view reports via Internet - how do I go about
doing this please?
I ask as my client wishes to have MR incorporated into their Sharepoint
website - please advise if this is possible and if so then how?
...Sales Pipeline Report #2
Anybody had problems with this report in terms of the group by Date function. Cannot get the date order of the report to work in terms of ordering by Estimated Close date.
Am posting here in the attempt to get anyone out there to help me please... have been pulling my hair out in looking at the query in this report to work out how to order by Estimated Close Date!
Thanks in advance,
Absolutely. The CRM 4.0 Sales Pipeline report group by Date does not work
correctly when using non-US CRM date formats.
I have logged this as an issue with MSFT support, who accept there is a
...VBA Help #4
I have a list of clients with their associated outstanding dollar
amount and their return (%). I would like to know if there is code
that would allow me to break up these clients by return (%) groupings.
For example, I would like to group below 10%, 10% to 17%, and above
17%. So at the client on the list that is just before 10% I would
like to add two rows and put a dollar subtotal in the immediate row
and sum the dollar amounts.
Can anyone help?
Public Sub ProcessData()
Const TEST_COLUMN As String = "A" '<=== change to suit
Dim i As Long
Dim LastR...Stock Option Reporting
I am trying to run a Capital Gains report but my Stock Options are not
showing up on the report. Does anyone know a work around to report on Stock
In microsoft.public.money, shaunx4 wrote:
>I am trying to run a Capital Gains report but my Stock Options are not
>showing up on the report. Does anyone know a work around to report on Stock
If you are looking at Reports->CapitalGains report in Money 2006
Deluxe, why would your employee stock option be expected to show up
on that report?
Maybe I should have clarrified. I am trying to view stock options th...We would love To Help You With Your Microsoft Dynamics GP Issues
If you are having issues with Microsoft Dynamics GP- reports, need
training, upgrades, ongoing support, or anything of the such- please
feel free to email us at firstname.lastname@example.org, or call us at
888.869.4090 ext 705. We would love to assist you. We provide install,
implementation, ongoing services, training, customization, report
writing, troubleshooting and much more.
...Nightmare Bug. !! Plz Help
at once when i try to edit or open some forms i got such error msg
"There isn't enough memory to perfrom this operation. close unneeded programs
and try the operation again."
I have 1GB Ram so it is sure silly msg !! what to do
Message posted via AccessMonster.com
What version of Access are we talking about here? By any chance does this
involve moving from one version to another?
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2...asp programmer needed...
Looking for an ASP/SQL programmer to interface RMS to Shopping cart
email me email@example.com
That is just the type of work my company specializes in. If you have any
questions or would like more information please give us a call at
Retail Information Technology Enterprises
"Brent" <firstname.lastname@example.org> wrote in message
> Looking for an ASP/SQL programmer to interface RMS to Shopping cart
&...Z report total
How do I print a total z report that has all the batches for one day?
This is not functionality that is present out of the box. We have created a
customized solution called the consolidated Z report. If you are interested
in learning more, please give me a call or drop me an email.
Retail Information Technology Enterprises
"Terry" <Terry@discussions.microsoft.com> wrote in message
> How do I print a t...Help, my views got messed up and "folder options" is now restricted
I have no idea what has happened here, I think vista somehow messed
something up when I connected to a file share, but even that seems odd
since I've been doing this for 6 months. I'm using Windows 98SE and
have files shares on a LAN to a Vista 64 Home Premium machine.
I can't choose "folder options" in the My Documents folder or any
random subfolder. When I try to do so, I get a message "This operation
has been cancelled due to restrictions in effect on this computer.
Please contact your system administrator".
I _AM_ the administrator, and there i...Find and loop help-multiple columns
I an trying to write a macro to search for a cell value in one column and see
if it occurs in other columns
I'm having 2 problems:
1. How can I look from the last used row up to row 4 in "myrange+5" as set
2. How can I look in all other columns beside the "myrange+5" column named
Am I completely off track??
'Find the last used column
myrange = ActiveSheet.UsedRange.Columns.Count
ActiveSheet.Cells(1, myrange + 2).Select
'find the last row
therow = ActiveSheet.Cells.Fi...Report Header Question
Hi, hope someone can help me with a problem I've run into whilecreating a report.I have a report where I must use three different Headers to obtain theinformation I need (Downtime, ProductNumber, and CustomerLotNumber).The information is in three headers, but in different locations ineach header (which if combined, could be in a straight line). Theclient wants totals for the information pertaining to Downtime,ProductNumber, and CustomerLotNumber, but he doesn't want them bydetail. The only way I could think to accomplish this was to createseparate Headers which would give the informa...Duplicate messages ++++ HELP....
I am using Outlook 2002. Setup with one email account only
as on offline user to 5.5 Exchange. When I do the
send/receive via dial up I pull down whatever messages are
on the Server down to the .PST file. Yet when I dial in
again I get the same messages over and over. Again I only
have one email account setup on the laptop. And it is
setup to work offline with a .PST file. Everything I have
read and found pertaining to this is if you have multiple
acounts setup under the send/receive. This is not the case
here. Getting tired of Microsofts constant change and lack
of documentation of ...Neede SmallIf or MinIf function
I have two columns, not necessary next to each other.
In these I have someting like
Now I need to find the minimum value in column 2, for a certain value, et 2
in column 1. In this case the alue im looking for is 1.
I have tried different combinations of SMALL and MIN, SUMPRODUCT and so on
with or without Arrayformulas, but I can't find the right way to do it. Any
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap...Deleted Items #7
When a message gets deleted from a mailbox and the default item retention
time has expired, Is there a way to access the database from any source or
third party application and retrive the item.
Also when the message is purged from the database what happens to the space
it occupied and is it possible to read the database area to retrive the
Thank you in advance
once it's purged, there is no way I know of to access the message, except by
restoring the DB from a time frame before the message was purged...when it's
purged, that space is now considered "whitespace&...