Problem with komma versus period in Excel
I am have problems with the use of period in Excel. I
Denmark komma is the decimal seperator.
If I convert (from within VB Editor) the content of a cell
from "6340,00" to text and replace the komma with period I
get "6340" (I wanted "6340.00).
If I make the convertion in Excel and record the macro at
the same time I get the desired result i my sheet. BUT
when I put in my code in VBA and run it from here I still
get the wrong result, "6340" and not "6340.00".
I know Excel (VBA) transform "." to "," probably acording
to...Report Writer Text Spacing Problems While Modifying a PO form
Due to Report Writer static text field size limitations, I am forced to try
to use two adjacent text fields to complete a sentence. I am having an
inordinate amout of problems trying to get words to align in sentences with
the correct amount of character spacing between words that span the text
field boundaries. And, the process of toggling between Report Writer and
Dyamics to get the Purchase Order form to reprint is time consuming. What am
I missing (besides patience)?
1) Setup a calculated field for your static text. Set the result type to
String, and use the Constant...Outlook 2003 Imap Auto Purge wish list
I hope someone at Microsoft can code in a auto purge Imap
deleted email function into there next Service Pack. I
can see a problem rolling this out to our employees.
There going to delete messages and those messages are
going to stay on the Email server until they do a Purge.
I'm afraid they just won't do this.
We use Imap.
No auto purge means emails staying on the server which
over time just takes up hard drive space and makes tape
backups take longer.
You should send suggestions to email@example.com as the newsgroups are
not monitored for feature request...Help! Setfocus problem
i ave a dropdown field on the first tab. I use setfocus so that it selects a
different field to stop users scrolling down and changing the selection on
the load event.
When a user changes tab and come back to the origional tab the setfocus
doesnt run as the form is already loaded. How do you get around this?
This is driving me and users mad at minute...please help before i open
another bottle of dark rum!
Check out following URL; how to fire onclick event on tab click. It may help
PLEASE do click on Yes or No button if this post wa...outlook 2003sp3: applying the inbuilt junkmail filter on existing messages?
would like to apply the outlook junk mail filter, with settings set to
'high', on emails already in my inbox. is there any way of doing this?
apologies if this has been posted before, I've made a couple of
searches but can't find anything...
No, there's no way to apply the spam filter to already downloaded items.
<firstname.lastname@example.org> wrote in message
> hi all,
> would like to apply the outlook junk mail filter, with settings set to
> 'high', on emails already in my...Safe Pay Check Amount Problem
I am trying to setup Safe Pay. Everything seems to be working fine except
for one annoying quirk. Our bank's Positive Pay data format gives us 12
characters for check amounts ($$$$$$$$$$¢¢). The file that Safe Pay
generates is working perfectly except for those checks that are greater than
$9,999,999.99 (9 characters). If the check amount is greater than that (say
$10,000,000.00), the value that the Safe Pay file shows for that check is
002147483647. And, even if none of the individual checks exceed
$9,999,999.99, if the total of the checks in the batch exceeds that a...AOL IMAP account
I have set up AOL email account as IMAP type and keep getting pop up in outlook " your IMAP server wants to alert you the following: Can't read attachment for message 6438.
this pops up for many times and each time the number is different.
new profile same issue.
Office Version:Office 2007
Operating System:Windows Vista / Windows 7 - same issue.
Submitted using http://www.outlookforums.com
Do you have a virus scanner installed which integrates itself with Outlook?
Uninstall this integration part of your virus scanner and try again; you'd
still be sufficiently p...Exchange Patch (KB912442) causes problem w/ share login accts
Exchange2003 std SP2 w/ Office 2003 & XP clients. We have several users who
shares a computer, so instead of logging in w/ different users accts, I set
them up w/ a shared logging and access Outlook w/ multiple Mail profiles.
However, after installing KB912442, it blocks these users from sending
emails. It gives them an message that the shared login doesn't have the
right to send emails on behalf of this user. I checked the mailbox rights
in AD Users and Computers, the shared login has Read & Full mailbox rights
permissions. Any idea how to fix this.
Thanks in advance.
...Internet connection problem
Hi. I hope someone is able to cast some light on a problem. We have a
home network (all computers running XP) some wired and some wireless.
For about a month now we have intermittent connection problems in that
any one computer (randomly) will not connect to internet. I think all of
the computers have suffered from the problem. Rebooting the affected
computer makes no difference but rebooting the router can sort it until
the next time. Even my mobile phone occasionally cannot connect. In
Firefox the message is just "server not found". Pinging an IP address
results in a time...imap
I have win2k SBS server providing email for about 20 users. Their internet
connection, to the office where the exchange server lives, is 512k
guaranteed up and down I believe. The clients that have desktops are set up
as exchnage clients via Outlook 2k and XP. The laptop users are set up as
imap clients via outlook because they will be using a dial up connection
most of the time on the road or away from the office.
My problem starts when an imap client's mail box gets over 100mb and then
they start to get time out issues even if they have a high speed connection
at the time...Problem with charting Net income vs Year
Im having some problems with my Excel chart. It will not plot Net Income vs Year. It keeps trying to treat Year as a different data series. It will work if I use text i.e. a1990, a1991, etc. but it refuses to use 1990, 1991... Any Ideas???
Use an "XY (Scatter)" chart, instead of a "Line" chart.
> Im having some problems with my Excel chart. It will not plot Net Income vs Year. It keeps trying to treat Year as a different data series. It will work if I use text i.e. a1990, a1991, etc. but it refuses to use 1990, 1991... Any Ideas???
Delete the co...Problems opening/saving attachments
I am unable to open or save any .rtf file attachments - this started
happening today, previously there were no problems with .rtf files.
When I try to open such an attachment I get this message:
Can't create file: xyz.rtf
Right click the folder you want to create the file in, and then click
Properties on the shortcut menu to check your permissions for the folder.
What folder is this? I am trying to open the attachment not creat the file!
Also, when I try to send an rtf file as an attachment, in the email message
the file does not show in the attachments section but the receipient
actu...Excel hyperlink problem
I have a strange excel problem and it's driving me nuts - I would be
seriously grateful if someone could help me out!
A colleague has this excel document with a huge number of hyperlinks in
it, well over 1000 (don't ask me why she wants to use excel - she just
does). The hyperlinks are in this format and are using DFS:
Whenever she clicks on a link, a pdf from another area of the network
is opened. Quite simple and no problems so far. However, as of
yesterday, whenver she makes any kind of change to the excel fi...securety problem
I start an app in vb with this code:
I always get a warning about hyperlinks that can be harmfull to
How can I bypas this warning.
I �ve put my macro securety on low and trust all installed add-ins and
templates + trust acces to visiual basic project.
Is there a way so the warning won�t show
climax's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30816
View this thread: http://www.excelforum.com/...wire transfer download problems
I made an international wire transfer of $5000 from my US bank. The receiving
bank in Panama took $15 as a service fee and credited my account with $4885.
Somehow my US bank now wants to show the amount as $4885 during downloads
to my checking account. But some genie reminds Money 2004 that the original
amount was $5000 which triggers a discrepancy. As a result, this transaction
wants to download each and every time, whether I change, accept, or whatever.
Thanks for help.
In microsoft.public.money, lanecito wrote:
>I made an international wire transfer of $5000 from my US bank. Th...Interesting TIF file problem
At the company I work for, we have someone that exports AutoCAD drawings to a
TIF file, then inserts the TIF file into an Excel spreadsheet. We have quite
a few of these.
Other users can open this spreadsheet, view it, do a print preview, but when
they try to print the file the inserted picture does not show up. All that
prints is a box with the broken url red x document image.
It seems that the problem is with Office XP. The Excel files are created
with Office 2000, and they print fine from Excel 2000. On Office XP and
Office 2003, the file won't print properly (all systems are ru...Does SuspendTimer exists?
in my programme I use some timers.
SetTimer(TIMER1, 60000, NULL);
SetTimer(TIMER2, 60000, NULL);
In OnTimer I catch the timers.
if (nIDEvent == TIMER1)
SetTimer(TIMER1, 60000, NULL);
else if (nIDEvent == TIMER2)
SetTimer(TIMER1, 60000, NULL);
In the beginning, the timers run parallel. Some time later there is a time
gap because of the function calls.
Now I want to suspend TIMER1 in my TIMER2-block. The things in do2() depend
on results from do1(). I don't want the results overwritten.
I only s...Annoying problem with lookup field
On a client, I have a MOSS 2007 portal with two lists which are not
wroking as expected. One contains people and the other one contains a
lookup field based on data from the first list. When someone which
hasn't got administrative rights logs in and tries to see the
properties of any element in the second list (on DispForm.aspx), they
can't see the lookup field value, and if they try to edit the element,
the dropdown control used to choose a person from the first list
appears empty. Administrator don't have this problem.
The users having the problem have collaboration rig...Problem with vba code to export query result in excel
I have a access report that exports to excel with click of a button after
choosing parameters. This works well. However I have to modify couple of
fields to utilize formula in the export module. I am not sure how to do this.
I am writing the above code which seems to cause problem. I appreciate any
help to resolve this issue. Thanks.
If lngColumn = 12 Then
xlc.Offset(0, lngColumn).Value = =([UnitPrice]*[OriginalShippedQty])/1000
It seems the fields UnitPrice and OrigianalShippedQty are not being
>I have a acces...re install Pub 2000 problem.
Hello and I hope I'm In the right newsgroup. My problem is I've had to
re install my Office 2000 Disc2 and now when I want to start publisher
the message box tells me I am trying to access a program that needs the
cd. When I installed it, I checked for Publiher to "run all from my
computer" I've un installed and re installed, still need disc. what am
I doing wrong? Thanks for your help, John :)
> Hello and I hope I'm In the right newsgroup. My problem is I've had to
> re install my Office 2000 Disc2 and now when I want to start publis...Uploading problems
Hi all, I hope someone can help me with a few difficulties i'm having
uploading my website.
1. When I upload, only the first page is uploading - so pages 2-7 don't appear
2. Images do not download with the webpages so when you type in the url, you
simply see a blank space where a photo should be with a small icon at the top
left courner which sometimes offers the option of 'show picture'.
3. The webpage is positioned to the left of the window when it appears and
doesn't centre itself to the page so there is a huge chunk of white space to
the right of the window.
Can ...Volume License copy of Windows Server
Is there anyway anymore to get a full Volume License copy of Windows Server
(e.g., version 2008) which does NOT require Internet activation?
Start with Vista/Windows 2008, your options to activate are by Internet or
Phone. I believe the command that kicks it off is:
"Spin" <Spin@invalid.com> wrote in message
> Is there anyway anymore to get a full Volume License copy of Windows
> Server (e.g., version 2008) which does NOT require Internet activation?
..."Archive all messages sent or received by mailboxes on this store" option problem
I want to backup the all message sent or received by mailboxes, I find that
there is an option "Archive all messages sent or received by mailboxes on
this store " in Exchanger 2003.
I had selected this option and forward to public folder. But I found that
not all message will be archived.
- All message sent by mailboxes can be archived
- Some Messages come from mailboxes will not be archived
Eg: yahoo, hotmail, and other company
Is this option not archive this message ?
Any other setting need to configure ?
...CHtmlView shutdown problem
We created an MFC regular DLL whch is loaded by an old MFC-app (built with
but we dont have access to the source of this app, just an DLL-interface.
our regular DLL loads several MFC extension DLLs.
one of the extension DLLs uses a CHtmlView based object which is used within
a docking pane,
we dont use document/view-architecture.
when I shutdown the app, it takes more than 1 minute till the CHtmlView
gets detstroyed. this effect doesnt occur when we load our DLLs from within
new MFC app, built with VC++.NET, everything shuts down fine.
due to the fact that there is n...Inventory Adjustments with problems
In this moment I have some journal entry in financial module with
transactions that i never saw before.
The bachumb is something like 'GLTRX024134', they are not sequencial.
In the descriptn, this has a link to a transaction from inventory
adjustment, but with a change... if for example the transaction from
inventory is AJ00000007, in this reference is IVAAJ00000007, this is
happening with the transfers too.
Any idea is welcome!!!
Thanks in advance