I am using access 97 and tried to import a csv file to the mdb table. I run
a code as following:
DoCmd.TransferText acImportDelim, "Specification4", "input",
DEFAULT_PATH & "online.txt", 1
In online.txt, there is a field which is 10 digit number and I specified it
as a double datatype in the specification4. After the import, I found out
that the 10 digit number data in the field get empty in the destined table
while other fields are all right. Therefore I import manually using
specification4 instead of running code. This time the 1...Window panes in Outlook 2003
Just got 2003 and find a third window pane on the far right which is a
preview pane for the selected e-mail, evidently. I can find no way to
eliminate the window pane. Is there a way to remove this pane? How?
I've tried every VIEW combination with no success.
View > Reading Pane > Off doesn't work?
"jay" <firstname.lastname@example.org> wrote in message
> Just got 2003 and find a third window pane on the far right which is a
> preview pane for the selected e-m...windows messenger 09-24-06
have a friend's contact card popping up at any time saying they want to be
added to my list.
this was done a long time ago but the message keeps coming up at various
times when i'm on the computer.
how can i stop this?>
this is a CRM newsgroup, you may get a better response if you post in XP
> have a friend's contact card popping up ...SQL deadlock problem
I am currently having a big issue with sql deadlocking on the
The last few months I have been working on a synchronization process using a
Biztalk orchestration. The sync uses the crm webservices to create and update
account and contact records in CRM. But now deployment to the production
environment gives me some problems. It seems that when trying to update
account records (which is one of the first actions in the sync process) the
webservice gives me Generic SQL errors and SQL timeouts. After extensive
profiling and tracing in SQL I found that there are...multiple Domain name delivery problem
hi, I currently have Exchange Server 2003 Build 7638:2 SP2,. We have multiple
domain names being delivered to the exchange store. I have nothad any
problems, but i currently have one user that is not receiving emails with
attachments from one certain "internet" sender to one of her email addresses,
but the other address works fine & if they send emails without attachments,
everything works fine from either address. I have had the user send them
message with attachments to me & the user with the problem & i get the
message, but not the other user! I even use message...Exchange update problem
I have tried to upgrade exch2k3 sp1 to sp2, but the update fails with "the
file pcproxy.dll is in use, and setup cannot identify the app or srvc. setup
Any clues/ideas/suggestions? Please.
This message has been checked for all known viruses.
The information contained in this e-mail and any attachments is confidential
and may be the subject of legal, professional or other privilege. It is
intended for the named addressee only and may not ...Lookup based on criteria in 2 columns
I am trying to use a vlookup or other function to return the value in the
amount column based on the location and date. Here is a sample of my data:
Location Date Amount
101 9/15/8 10
101 9/16/8 20
101 9/17/8 15
102 9/15/8 50
102 9/16/8 75
102 9/17/8 67
For example if I wanted to return the amount for location 102 on 9/15/8,
what formula would I use? I tried using variations of vlookups but had no
Peo Sjo...MS Money 95 data files
I hope that some one can answer this for me.
I have used MS Money 95 for years, and it works just fine for me on Windows
XP, however, I now have to reformat my hard drive, and have discovered that
I can nolonger find my original install disk. Will the latest versions of
Money still read the MS Money 95 data files. All that I have ever used the
program for is to track my investments, and am unlikely to do any different
in the future.
In microsoft.public.money, Stan Banner wrote:
>I hope that some one can answer this for me.
>I have used MS Money 95 for years, and...Rollup 2 and Office 2007
I already have Roll Up 1 and the Office 2007 compatibility patch installed.
If I now install roll up 2 will I have to reinstall the office 2007
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. email@example.com
> I already have Roll Up 1 and the Office 2007 compatibility patch installed.
> If I now install roll up 2 will I have to reinstall the office 2007
...Microsoft POS #2
I have a group of customers that I am working on setting up A bundled POS
I have looked at RMS and Microsoft POS. The customer's are small bulk food
stores. They package all of the bulk food in various containers and weigh it
with a Hobart scale producing a label with an system 2 price enbedded
barcode. These are UPC A formats. They are for the most part simple single
store installs and donot require the complex RMS system.
I have setup the Microsoft POS version 2.0 and found it will work perfect
for these customers. The only problem when you programed the system you
l...Outlook 2003 keeps crashing #2
I get this message when I look in System information. Outlook keeps
crashing quite often. I cannot for example delete two messages without
outlook crashing. My colleagues do not have this problem. We are using
the Microsoft mail exhange server.
Faulting application outlook.exe, version 11.0.5510.0, stamp 3f1380f0,
faulting module mso.dll, version 11.0.5606.0, stamp 3f334cce, debug? 0,
fault address 0x003b6e16.
Does anyone has a solution?=20
1) I would definitely apply Service Pack 2for Office 2003 + applicable
critical security updates.
2) Have you tried starting O...cant start outlook pst file to large
Hi I hope somebody may be able to help im new to outlook and now I cant start
outlook message says cannot open your default email folders pst file its too
large as I cannot open outlook I cannot delete old folders
See if this helps: http://support.microsoft.com/kb/296088
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's Guide to Microsoft Outlook 2007:
"Ray" <Ray@discussions.microsoft.com> wrote in message
news:B3B824DC-3C9B-4B1B-8EF3-61...Unexpected error message on closing an Excel file
Suddenly I am getting the following message when I try to close a workbook:
"Your formula contains an invalid external reference to a worksheet.
Verify that the path, workbook, and range name or cell reference are
correct, and try again"
The mysterious thing is that it does not happen consistently and that, after
I click OK after the above message, I can still save the file.
What might be the cause of this error message and can the "invalid
reference" be tracked down using one of the utility add-ins such as J.
If it only happens when you close ...Strange Access Denied Problem with Windows 7
I got a new computer about six months ago that came with Windows Vista
Home Premium 64bit. Before that I had done all of my .NET development
either on an XP Pro VM or my former XP Pro computer at home. Shortly
after getting my new computer at home, I also got a license for VMWare
to be able to test my software on multiple platforms and
I had wrote an application originally in VB.NET that was a simple
backup utility. It supports mutiple backup configurations. Any given
copnfiguration would define a backup which would be a list of files to
backup, a list of folders to ...Where is the workspace file stored?
I was given a project folder containing several dozen files. So where
is the workspace file normally located? If I don't have a workspace
file how can I cerate one? Using VC version 6. TIA
I haven't used VC6 for some time, but if I remember right you can just open
the .dsp file and it will create a .dsw file for you. It typically goes in
the same folder with the code.
"Phisherman" <firstname.lastname@example.org> wrote in message
>I was given a project folder containing several dozen files. So where
> is the wor...Change File Locations to Private Drive (not Folder)
I know that I can use "File Locations" in "Options" so that whenever I use
the "Open..." command in Word, it will open to a specific folder. I'm
wondering if there is a way that this can be applied not to a folder but to a
specific drive on a network.
Our company has a main public drive and has also assigned each of the Staff
their own private drive. Is there a way to access the "main page" (for lack
of a better term) of my private drive each time I use "Open..." in Word?
Right now it goes to "My Computer" or ...Drag and Drop file/directory names on Tree Control.
I am writing an application in which i have one Tree control.
Now i want that , when user drag & drop any file/folder on tree
control the file name/folder name should be add in the tree control
User may drag and drop file from desktop or may be from
I just want the path of that file/foder name nothing else.
so plz tell me will it be possible ...
Plz Help me.............
> I am writing an application in which i have one Tree control.
>Now i want that , when user drag & drop any file/folder on tree
>control the file nam...opening .bak file
I hope someone can help!
I recently was performing a compacting operation on my outlook express
My computer shutdown due to a power failure and I lost some emails from a
few of my folders.
I was however able to get the .bak files (of the .dbx files that were lost)
out of the recycle bin.
If I could open one of these .bak files or convert it back to the .dbx file
from which it was created I would retrieve these emails.
Can anyone instruct me as to open this .bak file?
Thanks for any help!
How did you get the bak files out of the Recycle Bin?
All e...Pop Up Windows
Several sites pop up smaller windows with advertising. The opop up blocker
does not stop these smaller ad windows. How do I stop them?
"Larry" <Larry@discussions.microsoft.com> wrote in message
> Several sites pop up smaller windows with advertising. The opop up blocker
> does not stop these smaller ad windows. How do I stop them?
They LOOK like a pop up to you, but the designer that wrote the page made
them not conform to the rules that define the...Border problems
Not sure why all of a sudden all my borders in my tables created with
Publisher can only be white. No other color will show when selected. Opening
a pub file done on another computer where the borders show color, shows white
only. I have attempted to do a repair on publisher, which gave no help.
Have attempted to uninstalled and reinstall Publisher without clearing the
problem. Anyone have any ideas or suggestions?
Look in the Accessibility Options in the control panel, display tab, disable
"use high contrast."
If that doesn't solve the issue, read the third FAQ here....matching contents #2
E1 thru E10 contains sequentially-sorted data. B1 thru B6 contains
sequentially-sorted data which matches SOME (but not ALL) of the data
in Col A. For example.
1 1 1
2 3 2
3 4 3
4 5 4
5 6 5
6 10 6
I need to move the data in the cells in Col B next to the cells in
Col E that have the same contents. For example:
1 1 1
3 3 3
4 4 4
5 5 5
6 6 6
10 10 10
Besides dr...Trying to read XML file into dataset
Developing a web site in VS2005, SP1, VB, .NET 2.0, ASP.NET 2.0 on XP Pro,
I eventually want to use a gridview table to view xml data, but right now i
can't seem to get my xml data into a dataset so that i can use it.
I have an XML file and can open it in IE. There is no XSD or XSL file to go
I can't seem to get the XML data into a dataset. I tried using the
following code, but it just does nothing. It doesn't give an error. It
just executes the code and does nothing.
Dim dataSet As DataSet = New DataSet
dataSet.ReadXml("...Please ignore #2
Testing a posting problem
...office 2010 and windows 7
word 2010 is hanging (seems on autosave) a great deal, especially with larger
(>3MB) files. it hangs the system and I have to do a hard reboot (power
down). any idea as to why? system is windows 7 ultimate, office 2010.
Right-click My Computer, Disconnect Network Drive.
Mary Sauer MVP
"KPTools" <email@example.com> wrote in message
> word 2010 is hanging (seems on autosave) a great deal, especially with larger
> (>3MB) files. it hangs the system and I have t...Excel Problem
I have a 23.8 meg excel 2000 spreadsheet set for manual calculation saved to
my local hard drive. Every time I try to open it, it takes forver and
sometimes never opens but I do not get any error messages, let me just tell
you that I am running a P4, 1 GB memory, Office 2K with SP3, and nothing else
running when I try to open it. As I said it is set for manual calculation,
and it is cleared to not auto calculate when opening or closing. Any idea's
as to why this is happening?
I don't know why you're having this problem but I would like to point
something out for w...