Exporting to MS DOS Text file
I have an Access Report which I am using to create a text file for upload
into a 3rd party application. When Access exports the text file it is
creating a carriage return (i.e., empty row) in the first row of the created
text file thereby making the file incompatible for upload to the 3rd party.
Is there a setting I need to select to prevent this from happening? Any
suggestion you may have would be appreciated. Thanks in advance for your help!
...linked file not found
I cut pasted some data in workbook sheet A from another workbook sheet
B and then deleted workbook B.
When I click on the cell it refers to workbook B, in fact gives me the
full path of the value. The file is no longer there. I cant find it
using windows search on the whole disk. Does anyone have any idea, what
is going on?
It appears that you have only copied a link to the data, not the data itself.
If you have not deleted the file from your RecycleBin, then restore it and
then Copy > PasteSpecial > Values again to re-capture the data.
Vaya con Dios,
Chuck, CA...upgrade #2
Is an upgrade possible from the 98 version of publisher to the 2003 version?
My office uses the 03 version and I have 98 on my personal computer. Even
though I have purchased a new computer it does not help me to upgrade to the
new 07 version because I can't easily move back and forth with the software
in our office.
I can no longer find a link that will give me a definitive answer but my
instinct says it will work. HOWEVER...you may find it difficult to
purchasing the 2003 upgrade. Pub 2007 has been out for several months and
fewer and fewer places are selling the older software....Help. Log files are killing me. Exchange 2000
I just installed exchange 2000 on a new machine on a 36GIG drive. I have
another empty 36GIG drive. I did not realize that log files take so much
space. I only 3 GIG of free space left.
1. How can I move the log files to my empty drive?
2. How can I delete these files w/o any problem on Exchange? I mean almost
20GIG of log files in one day. Give me a break.
3. Is there a way to do that automatically.
On Tue, 7 Sep 2004 15:19:49 -0400, "Dooma"
>I just installed exchange 2000 on a new machine on a 36GIG drive. I have
>ano...Posting to closed year #2
We need to make an adjustment to a closed year.
We have opened the year\period... and the accounts allow posting to history.
But when we post the transaction it errors out and states .
Transaction error-edit required
We cannot see where the transaction needs editing.
I cannot seem to find reletive info on the KB either.
Any one have a step by step to ensure we are not missing anything
Did you follow Article ID : 851423? The only thing I think that could be the
problem is that you are trying to correct a transactions that goes beyong the
first closed year. ...ask help for DLL Export Library Definition File
I got a problem when I build an MFC App which call a MFC
Extension DLL that has implemented some API, but I don't
know where is the problem, in DLL, in dll def file or in
the API like this:
extern "C" AFX_EXT_API long WINAPI PassThruConnect
unsigned long ProtocolID,
unsigned long Flags,
unsigned long *pChannelID
extern "C" long WINAPI PassThruConnect
unsigned long ProtocolID,
unsigned long Flags,
unsigned long *pChannelID
and its def file like this:
__...Problems importing pst file...
One of the users in our office tried to open Outlook & recieved an error
message that indicated that the pst was gone or corrupt. After running
the Inbox repair tool to no avail, as well as picking up a copy of their
pst from yesterday's backup, I'm still unable to do anything with it!
When trying to import it, I get the message "Properties for this
information service must be defined prior to use" & after hitting ok, I
get a message that the file isn't a personal folders file! I have read
several long-winded posts in other forums, which basically have given me
no...Relative Reference #2
My question is I have a row and a column of values. I am trying to multiply
the row by column and display it in a row format.
Row 3 5 2 5
I want the product to be displayed as
3 20 10 30
by using relative reference. It doesnt work for me. Pl. let me know if
anyone has any idea.
A1:D1 = 3;5;2;5
A3:A6 = 1;4;6;5
Copy across as needed.
"Hari" <Hari@discussions.microsoft.com> wrote in message
news:12430877-E274-482E-8F16-856C2...money 2005 #2
anybody seen screenshots of money 2005 yet??
No, there would not be any because I believe M2005 is still under
"Ivan Debono" <email@example.com> wrote in message
> HI all,
> anybody seen screenshots of money 2005 yet??
maybe some would have leaked out :)
"A.A. Fussy" <firstname.lastname@example.org> schrieb im Newsbeitrag
> No, there would not be any because I believe M2005 is still under
> beta-t...Paying upgrade price instead of Full version price... #2
Is there such of thing as an upgraded version that you can
buy intead of having to get a whole package when you
already own last year's?
Thanks a lot!
Not as such but by shopping around you can usually find an offer with a mail
in rebate that brings the price down. If I remember around the time M2004
was released people were talking about net prices of around 15 bucks.
Microsoft MVP - Money
"Bis" <anonymous@discussions....Help! Extract the subject of all mails in outlook to a text file
How can I extract the information, such as subject, sender, time of all
the mails in my Inbox into a text file?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Switch to a table view that contains all the fields you need the information
from, select all items, and press CTRL+C to copy. You should be able to
paste the data in columns into a text file. Note that not all available
fields will copy in this manner, but the ones you mentioned should work.
Jocelyn Fior...Outloo 2003 pst files
I upgraded office xp with office 2003 beta....on Nov 30th
when beta expired i went back to using office xp..all
works apart from i am unable to access the pst files i
created when i was using outloo 2003...any advice on how i
can access these files??
pls reply to my email: email@example.com
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick.com?
-Please post your Outlook version!
"Tahir" <firstname.lastname@example.org> w...Missing function in Excel 2003 #2
I have a user that is complaining about a missing function in Excel
2003. He calls it a "Coalition matrix", I have never heard of it
before. He used to have it in Excel 2000. Any ideas?
never heard about this. Maybe he has to install the Analysis Toolpak Addin
('tools - addins').
> I have a user that is complaining about a missing function in Excel
> 2003. He calls it a "Coalition matrix", I have never heard of it
> before. He used to have it in Excel 2000. Any ideas?
Never heard of a coalition matrix. The Analysi...attach file in Business Portal Project's Expense
I would like to suggest to include feature for attached file into the
Project's Employee Expense. Where employee submitting expense claim, the
superior would like to view the scanned copy of the resit, this is common in
order to verify the trueness of the claim.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then ...show duplicates of 2 tables
I have 2 table which have identical fields and I wish to create a table from
the duplicates found. The wizard does the opposite it takes out the
How do I go about it?
On Tue, 12 Feb 2008 15:37:00 -0800, Paul Wilson
>I have 2 table which have identical fields and I wish to create a table from
>the duplicates found. The wizard does the opposite it takes out the
>How do I go about it?
Create a Query joining the tables on *all* the fields w...XML File Size & Memory
I have an xml file that is 63mb in size. If I were to load this file
into memory, will it consume 63mb of memory or will it consume more than
That depends on how you're planning to load that document. If you are
loading it into an XmlDocument or an XPathDocument object then it will
consume more memory than the size of the file.
If you simply walk the document with and XmlTextReader then it will
consume less memory.
> -----Original Message-----
> From: Roshawn Dawson [mailto:udrag...HyperLinking PDF files in Excel
Can anyone offer any help on 1. is it possible to import pdf files into
excel as hyperlinks? and 2. if it is possible, how do you do it? =)
A hyperlink is as it says, a link to a file either on the local drive or a
network which is mapped to the local pc.
It is not an imported file, just an address which when pressed will open the
relevant PDF document with a PDF Viewer.
To insert a hyper link, select from the top menus.
Insert\Hyperlink (Hyperlink is at the bottom of the insert menu itme)
This will then show a pop up box which will allow you to identify where the
PDF file is to be ...Transfer MM to laptop
Currently running mm 2006 premium on desktop running xp. with purchase of
laptop want to transfer license. laptop running vista home premium. I expect
I'll need a vista compatible version for the laptop. how do I get it?
The retail licenses--you said Premium so I'm assuming--allow installation on
both a desktop and a laptop machine. That's not to say that they solve
problems assoicated with moving the file back and forth. M06 should work fine
with Vista. Do you have the installation CD?
> Currently running mm 2006 premium on desktop running xp....Transferring email addresses from Access to Outlook address book
Is there a way of transferring a list of email addresses with their contact
names from an Access Database Table to my Outlook?
...Opening file question
When opening a file direct from my documents excel opens
but the sheet does not get displayed. Although if you then
click print preview the content of the sheet is there.
Tried opening excel and then opening file and this works
fine. Not a major problem but annoying.
Any one shed any light?
I think xl is trying to help you.
Excel wants to keep the window settings the same way as they were previously.
If you saved your workbook in less than a full window, then the next time you
open it (via double clicking with no existing xl instance running), it will open
it the same win...Configuring Outlook #2
I have to configure my outlook while working in my
system everyday. I'm not able to view my mails which are
sent to me the previous day or week. Please help me how
do i configure my outlook in such a way that I get my
mails regularly without any difficulty.
send me a reply as soon as possible.
...RMS add-ons #2
We're considering purchasing RMS and are interested in what appears to be a
wide variety of 3rd party add-on products. Is there a place I can see all of
the RMS related products?
There is always Solution Finder, but you need access to CustomerSource which
is only available when you are an RMS customer. If you would like a list of
customizations for RMS produced by my company, RITE, please email me and
I'd be happy to get you some information.
Retail Information Technology Enterprises (RITE)
32...Line Feed XML File
I am using SqlXmlCommandType component to generate an XML file in a VB.net
Console Application. Everything ran perfect except one thing. I need to know
if there is anyway to make this XML file Line feed file. In other words, I
need to put each tag in one line instead of mixing them up.
Do I have to create an XSL file to do this transformation, or there is
another way on the .net framework to do it?
Nader Shahin wrote:
> I am using SqlXmlCommandType component to generate an XML file in a VB.net
> Console Application. Everything ran perfect except one thing. I need to know
> if ...Transfer Table Name?
RMS V 1.3.1006
What is the name for the Transfer (in/out) table within RMS?
I need to get after some xfers inbound to a closed location whose database
we do not have to flip to. I would like to get at these via HQ Admin and
delete them for the location specific.
These are stored in the PurchaseOrder/PurchaseOrderEntry tables.
New West Technologies
"jocelynp" <email@example.com> wrote in message
> RMS V 1.3.1006
> What is the name ...Error #8270 #2
Hello, everyone. O need some real help here...
Here is my case:
We have Win2003 network (one forest, 2 domains A & B) with Exchange 2003
running. Under domain B, we setup ca. 25 child domains.
We have setup Exchange server 2003 for domain A (but rarely used). We have
also setup Exchange 2003 for domain B where everybody'd email reside in. They
are all under same organization name.
Starting sometime ago, I noticed constant error message, event 8270 from
domain B's Excahnge server application log:
Event ID 8270
Category: LDAP operations
Description: LDAP ...