Keep a running total while using a clearable formI have a form that I am able to clear with a macro reset button. How can I
keep a record of the values within the form and add them to the previous
values that were in that same form before I press the reset button? I want
to keep a running total log is what I guess I'm trying to say.
Hi
Have a look here:
http://www.mcgimpsey.com/excel/accumulator.html
It is well worth reading the intro, as it mentions the lack of traceability
should you enter an incorrect number.
Hope this helps.
Andy.
"1vagrowr" <1vagrowr@discussions.microsoft.com> wrote in message
news:A93475...
Can't open email messagesThe layout:
Exchange 2003 SP2 w/OWA
Outlook 2003 SP2
I can connect to the email server with my Outlook client. I can open all
emails prior to Tuesday and perform all email functions (reply, forward,
etc). Since Tuesday, I cannot open or perform any email functions with any
messages. I see who the message is from, the subject, and date/time stamp.
The message is gray'ed out in the Preview Pane and states "This item cannot
be displayed in the reading pane...". Likewise, when I try to open the
message, it states "Can't open this item". I'm leaning towar...
personalized mailhello, i'm using outlook xp.
how can i do to personalized my outgoing mail with my logotype and other
graphical informations?
thanks
denis
Hi Denis,
You can either use an HTML file, or create a signature. The latter is
probably easier.
Tools >> Options > Mail Format tab.
Click Signatures at the bottom, create a new sig. Give it a name. Once in,
if you want anything jazzy, pressing Advanced Edit will open up either
FrontPage or Word, depending on your PC config. You can add lots of pics and
other more complex components from here.
Hope this helps
Piers
"denis" &l...
People sending me mail get mailbox full messageI know my mailbox is not full, it's a brand new computer and i maybe have 10 messages. People sending me email get the message yet I don't get any such message on my end. Where can I go to see if I'm actually out of space and/or increase the space? Help anyone.
On Tue, 27 Jan 2004 07:31:06 -0800, "Tony"
<anonymous@discussions.microsoft.com> wrote:
>I know my mailbox is not full, it's a brand new computer and i maybe
>have 10 messages. People sending me email get the message yet I
>don't get any such message on my end. Where can I go to see if...
imap security problem ?I recently ran a port scanner /tcp viewer on a win2k server that has
exchange configured on it. An MX record was created for that machine at the
ISP so that all emails get delivered directly to it.
Now the port scanner / tcp viewer is reporting a constant TCP connection
between port 143 on the server and another machine -which is NOT the ISP.
What am I seeing, a security hole ? Should port 143 even be open ? Where can
I look for that in the exchange setup ?
If you're not using imap you should stop & disable the
IMAP sevice. You should also deny 143 at the firewall.
>-----Origi...
Strange problem #2User is running Excel 2002. Her normal routine is to open
Excel, then open 8 different files (all linked to other
files). As worked is completed on each file, files is
saved and closed so Excel never has more than one file
open at any given time. Excel shuts down every morning
after she runs the 3rd or 4th file with various errors.
If she runs this routine by opening Excel and then closing
it after each file - the errors don't occur. So as long
as she closes Excel after she runs each file and starts a
new session for the next file - everything runs smoothly.
Any ideas?
Do ...
Why does my computer keep freezing?When I am playing games on face book,, my computer freezes up.. WHat can I do
You can try posting your question in an appropriate newsgroup. Your problem
has nothing to do with Word. I would suggest starting with Facebook's tech
support.
--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"nana" <nana@discussions.microsoft.com> wrote in message
news:B1513814-8C77-4419-BA1A-51760CB802B6@microsoft.com...
> When I am playing games on face book,, my computer freezes up.. WHat can I
> do
...
In Outlook 2003 how I keep IMAP messages for long?I set up an IMAP folder which keeps only the last week's mails and does NOT
display older ones. Incidentally it's the only account that does this to me
while other IMAP accounts dont. There's no apparent setting in Outlook 2003
that I can use, is there?
I'm probably off base, but it sounds like you set a view to only display the
last weeks worth of e-mail. Did you do something like this via the view
menu?
"lamdig" <lamdig@discussions.microsoft.com> wrote in message
news:00CDB83D-DB26-484A-B14D-3F4DD69FB64F@microsoft.com...
>I set up an IMAP...
Modifying a hosted SRS-Report (.rdl) -> subreport could not be shoHi,
- MSD 4.0, hosted.
- I downloaded "Invoice Sub-Report.rdl" (via Edit Report|Actions|Download
Report)
- Edited that in VS2005,
- (could have been a text editor as well)
- for grouping on product
<CommandText>
SELECT
FilteredInvoiceDetail.productidname,
FilteredInvoiceDetail.productdescription,
.
FilteredInvoiceDetail.quantity,
/*SUM(FilteredInvoiceDetail.quantity) AS quantity, */
.
FROM FilteredInvoiceDetail LEFT OUTER JOIN FilteredProduct
ON FilteredInvoiceDetail.productid = FilteredProduct.productid
WHERE (FilteredInvoiceDetail.invoiceid = @CRM_Qu...
outlook XP: blocking email messages with a certain hyperlinkI have gotten my main e-mail onto a spammer's list that
does not respect wishes to be removed. It is casino,
pills, etc, all from one spammer, using multiple free
addresses to spam me. One common factor is the
unsuscribe link in the html email always leads
to "vpillz.globalofferz.biz". Is there any way to tell
Outlook to trash any messages containing a link to that
page?
...
Keeps saving a CD copyThe last time I saved a back-up file (of my Money 2002
file), I was out of floppies, so I saved it to a CD. Now,
every time I open Money it places a copy of the same file
in the CD burner, even though I select "Do not back up"
and there isn't even a CD in the drive. HOw can I make it
stop this?? Thanks -- this is a great forum.
In microsoft.public.money, Connie wrote:
>The last time I saved a back-up file (of my Money 2002
>file), I was out of floppies, so I saved it to a CD. Now,
>every time I open Money it places a copy of the same file
>in the CD burner, ...
Xpath problems #2Hi,
I'm trying to display the data from my typed dataset on a page using
the Xml web control.
I have the following code:
Xm1.Document = new XmlDataDocument(ds);
Using the debugger, I found that the xml representation of my dataset
looks like the following:
[code:1:877c35039f]
<dsData>
<Entry>
<Title>Test</Title>
<Description>This is a test</Description>
</Entry>
</dsData>
[/code:1:877c35039f]
My xsl file looks like this
[code:1:877c35039f]
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet...
Case Statement ProblemHello,
Can someone please help me with my Case Statement
Public Function FEE_TYPE(DET_REF As String) As String
Dim strRef As String
Dim strFeeType As String
strRef = DET_REF
Select Case strRef
Case "LP*"
strFeeType = "LP"
Case "PP*"
strFeeType = "PPP"
Case "Prop*"
strFeeType = "Prop Tax"
End Select
FEE_TYPE = strFeeType
End Function
Query
SELECT FEE_CATEGORY: FEE_TYPE(DET_REF)
FROM tblFees
I do not get any results when I know there are many of them :(
Try this:
Pu...
A really interesting Outlook problem!Hello everybody!
I've got an interesting Outlook file (112 KB RAR-ed) which shows the
following behavior: when you open it (i tried Outlook 2003), it shows up OK,
but no item could be deleted or moved. It tells "Errors have been detected
in your Outlook data file, close all programs and use the Inbox repair
tool". But scanpst (Inbox Repair Tool) finds absolutely no problem even
with -logv 9, the most detailed one.
What can you suggest me to do?
Here is the link to the file: http://www.anovikov.com/StrangeFile.rar
Are there any Microsoft people out here?
By looking at...
Index and some other web page problemsI have had occasional problems with index publishing on filezilla. My
webhost doesn't think frontpage is secure with extensions. I have no
extensions according to them but I must download from filezilla. What is
baffling is that my index doesn't always update to them. My webpages do,
sometimes, sometimes not. I have tried save as the filename to my
f/documents/website/index and still when I update filezilla it shows the
previous date still. Even after reboots the next day. What can I do to know
that my frontpage is updating to my downloader? I'm really a novic...
Sync CRM 3.0 with Outlook 2007 problemHello.
At synchronization CRM of the client with Outlook, in added contacts in
Outlook the organization to which this contact concerns does not appear in
Outlook card.
How it can be corrected?
Hi Dmitry,
this should be able to help:
http://www.workopia.com/howto/DisplayParentAccountOutlookContactForm.htm.
If not then take a look at
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=85B6BEED-3212-48C1-9634-BAACAC74A16A
Hope this helps
--
George Doubinski
CRM Certified Professional - Developer
"Dmitry" <Dmitry@discussions.microsoft.com> wrote in mes...
Problem when registering OCXThis is a multi-part message in MIME format.
------=_NextPart_000_000A_01C3EA6F.B5037D00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a problem that occurs when building an ActiveX OCX that uses MFC. =
What happens is that after the OCX is linked, VS.NET 2003 attempts to =
register the OCX via regsvr32 and fails with a very unhelpful message =
stating...
Project : error PRJ0019: A tool returned an error code from "Performing =
registration"
An important thing to note is that this ONLY happens when statically =
linki...
Design problem: Excel publishing data back to a web siteHi All,
This is a request for advice on Excel and data connectivity over the
web.
I am looking to add a feature to a web site (& web service) that has a
large but simple data set (imagine 5000 rows of data). I want users
to be able to download this dataset to their client machine (in some
form such as xml or even csv) where they can manipulate this data
locally, and then _upload_ this modified data back to the web site.
One unsatisfactory approach to doing this is to present the user with
a url where they can download the data, modify it and save it to a
local file, then upload this fi...
I cannot read forwarded messages. I only get an email addressFor some reason, when someone forwards a message to me all that shows up is
the email address of the person who originally sent the message. Any ideas?
Change your View>Encoding setting.
"Michelle10000" wrote:
> For some reason, when someone forwards a message to me all that shows up is
> the email address of the person who originally sent the message. Any ideas?
...
personal.xls won't open when I start ExcelRecently, the personal.xls file won't open when I start Excel. The box for
"Open all files in " on the general tab under tools/options is blank. When
I've tried to change this to the Microsoft Excel startup directory
(C:\Documents and Settings\MyName\Application Data\Microsoft\Excel\XLSTART),
which does have the personal.xls fiel in it, it won't let me. As soon as I
click OK, it reverts back to a blank box. Any ideas? This is a recent
phenomena, as it worked fine for the past 9 months and don't really have any
idea as to what I might have changed (if anyth...
Add-in problemOn trying to create the first email message each time after starting Outlook
2007, I get the following message:
The Add-inn "FaxExtension" (C:\Windows\System32\fxsext32.dll) cannot be
loaded and has been disabled by Outlook. Please contact the Add-in
manufacturer for an update. If no update is available, please uninstall the
Add-in.
After clicking the OK button on the messsage everything works fine.
I have looked at the Add-ins in Outllook (Tools>Trust Center>Add-ins) but
don't see this add-in, nor can I find the fxsext32.dll in the System32
folder.
I had tried ...
No Messages in InboxI can send email, but cannot receive it. The Exchange
account is valid, but I am not receiving any email. Any
ideas?
Need more info - if you're using Exchange, are you opening up the Exchange
mailbox directly? what services do you have loaded? What version of Outlook?
Have you checked your view settings on the inbox? Have you asked your
Exchange admins for help?
Brian wrote:
> I can send email, but cannot receive it. The Exchange
> account is valid, but I am not receiving any email. Any
> ideas?
...
Problem with Local time to System time conversionHi,
Any help would be much appreciated, and here's my problem:
I've used the function SystemTimeToTzSpecificLocalTime() to convert a UTC
based time to a local time and everything works fine. However,when I try to
do the reverse, that is, from a local time back to a UTC time. The function
TzSpecificLocalTimeToSystemTime();
is not supported under windows 2000 (only supported on XP/server2003)
So I tried the function FileTimeToLocalFileTime() as a work-around but my
time is always off by one hour because of daylight saving.
Are there any easier alternatives besides making my own timezo...
Excel VBA-vlookup combo box problemHi can someone please help me.
I have created a worksheet in which i have Vlookup formulaes reading o
another worksheet which has combobox with drop down lists and linke
cells. Everything works apart from the comboboxes whose populate
linked cells are not being recognised by the v-lookup function. Th
Vlookup is as follows:
vlookup(e18,'policy'!c5:098,7,false)
The data within the combo box is a mixture of text and numerical e.
L32H11-1, EM2H11-1
I have put a double minus sign in front of e18 and it returns
#value!
Can someone please help me.
thanking you in anticipation
Saik
...
Latitude and Longitde problemHi all
Just wondering if somebody can help me with a problem.
I need to calculate the distance between two latitude and longitude
co-ordinates. Is there a function I can use? The lat. and long.
co-ordinates are expressed as decmals and not deg, mins and secs.
Any help will be appreciated.
Thanks
Francois
see www.cpearson.com where Chips has lots on lat & long.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Francois Ashton" <francois@vitria.co.za> wrote in message
news:%23OAAW7uCGHA.4016@TK2MSFTNGP11.phx.gbl...
> Hi al...