#Delete Mark in Bound Memo filed
I have form that has bound memo field, sometime, no sure how it happen, the
memo filed is filled with #Delete. My application is a stand alone program.
Kindly advise what can cause this and how to avoid it from happening.
When was the last time you performed a compact and repair?
Is you db split? Does each user have their own copy of the front-end?
http://office.microsoft.com/en-ca/access/HA011865661033.aspx - No very
helpful but directly from MS ...Caption Issue #2
The newsletter has a colored gradient with columns. The
caption in the column has a white background. How can one
include the gradient in the caption to match the overall
>The newsletter has a colored gradient with columns. The
>caption in the column has a white background. How can
>include the gradient in the caption to match the overall
If you set the fill to "no fill" would that give you the
effect you are looking for (the background will show
fill> fill effects and ...CSV File Problem
Can any one explain why the following problem occurs please?
A colleague has a small list of data which is a csv file exported from SQL.
Column One is a serial number from 1 to 29.
Column 2 is a number of transactions which have occurred.(it should look
like example A below in Excel)
1 475 1,475
2 1732 21,732
3 1670 31,670
4 2176 42,176
5 608 5,608
6 1579 61,579
7 43101 743,101
8 54512 854,512
9 51258 951,258
10 61050 1,061,050
If I double click on the csv file, it opens in Excel but c...Leading and trailing spaces trimmed with SQL XML
I am inserting data into a table using xml bulk insert. One of the
field is of string type and contains data with leading and trailing
spaces. But on insert the spaces automatically trimmed off. Can you
please tell me how to avoid this trimming of spaces, as i have to
insert data using xml.
EXEC sp_xml_preparedocument @hDoc OUTPUT, @InsertLines
INSERT INTO tblLine WITH (TABLOCKX) ([Text]) SELECT [Text] FROM
OPENXML (@hDoc, '/Lines/Line', 1) WITH ([Text] nvarchar(max))
EXEC sp_xml_removedocument @hDoc
bad_clone (firstname.lastname@example.org) writes:
...CFile (delete file)
How can I delete all files that end with ".temp" in some folder?
"Petar Popara" <email@example.com> wrote in message
> How can I delete all files that end with ".temp" in some folder?
SHFileOperation() will and it supports wildcards! DeleteFile() will operate
on one file at a time.
"Petar Popara" <firstname.lastname@example.org> wrote in message
>...Opening an *.MSG file with it's respective attachment.
The file *.MSG is a message file. This can be viewed by any editor, like
Notepad. However, when there's an attachment to it, we see garbage.
Is there a way to open the attachments present inside the *.MSG files ?
Yes, by opening it with Outlook.
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully customized Toolbar
-Creating a Classic View in Outlook 2003
Subscribe to the newsletter to receive news and tips & tricks in your
mailbox!...Can't open 2005 data file after reinstalling Money 2005
I am experiencing a recurring problem. I have had to reinstall Windows XP
and MS Money 2005. I am now unable to open my previously converted 2005 file
or restore any backup version. I consistently get the following error
"Money cannot locate filename or cannot open it, possibly
because it is a read-only file, you do not have
permission to change it, or your disk drive is write-
protected. If you have chosen the correct file and it
cannot be accessed, you will need to click OK and then
Restore your most recent backup file."
Any help or thoughts would be greatly ap...import a 123 file
My excel version cannot open a Lotus 123 file. Is there an import feature to
move the data from Lotus 123 to Excel?
No, you need to convert the file either from Lotus 123 or get commercial
"Frank" <Frank@discussions.microsoft.com> wrote in message
> My excel version cannot open a Lotus 123 file. Is there an import feature
> move the data from Lotus 123 to Excel?
...Where is the cache files folder located for windows media player?
Does windows media player have a cache files folder? Where is the cache
files folder located for windows media player? Or how do I find the cache
files folder for windows media player?
Thank You for your Help.
Background info: I have a desktop AMD 4400+ 64X2 4GB memory 320GB HD(way
bigger than I need) Acer computer (AM3100-U3201A) I purchased new February
2008 running 32-bit MS Vista Home Premium SP2 box. I use MS auto updates.
I think it has onboard shared memory for video and sound. My ISP is Comcast
12mbps with Motorola SURFboard SB5101 Cable Modem direct to...How Do I Import Stock Quotes to Money2004 Standard?
Does anyone know how to import stock quotes into Money.
Some of the ones I am interested in are not supported by
MSN for online update. I know I can enter the data
manually but I want to be able to update prices for
multiple stocks on a regular basis.
I have tried ceating a .ofx file for importing and Money
reports "Import Completed" with no errors but the price I
specified does not appear in the price history.
The extract from the .ofx file relating to price I was
trying to import is as follows:
<S...Messages Cut off
A recipient receives forwarded mail messages that are cut
off in random locations throughout the email. Outlook
2000 with latest SP. Any ideas?
...Public Folder link to Excel File
I have a user that claims that he had a shortcut to a spreadsheet "in
his public folders" at his old job. Obviously, he's an end user that
may or may not know what he's talking about.... I'm trying to figure
out the best way to accomodate him.
He basically wants an Excel file stored on a shared folder to be
available to all user as either a shortcut, or a link in the public
folders (can't post to a folder as he will be updating the sheet
regularly). When a user clicks on the shortcut/link, it would just
launch Excel and display the file.
Anybody have any ideas...Interface not registered message
when i try to send a e-mail message through outlook, i
get the message interface not registered ? and then
can't even save message. can anyone tell me why ?
...Outlook Hangs Reading Messages
I am running Windows XP Pro & Outlook 2003 via POP3 & Symantec AV
I had to reinstall everything on my pc and now find when I double click
an email outlook hangs for roughly a minute and then it finally opens,
I have tried a data compact, reinstalling outlook and creating a new
pst then importing but it still happens
Does anyone have any ideas? It's driving me mad
Try deleting and recreating the profile as one of your steps in
Thoughts lead on to purposes; purposes go forth in action; ...Corrupt "Deleted Items" folder
I am unable to empty the "Deleted Items" folder. The
error that comes up tells me that the "Outlook.pst" file
has errors in it and to use the "Repair Inbox Tool".
I've tried using the repair function under the "help"
menu...to no avail.
I have also tried opening the "Outlook.pst" file in MS
Word, but the file is 129 megabytes! It crashes MS Word
when I try to open it.
Look for scanpst.exe on your local drive and run it
against your outlook.pst file
>I am unable to empty the "Del...Opening pub files created with older Publisher versions #2
I have just upgraded to Publisher 2003 from 2000 and am having trouble with pub files sent to me for our chuch newsletter
which is using Publisher 97
The text is not wrapping around graphics boxes. Can I fix this? I really don't want to go back to Pub 200
Richard this is caused by Publisher 97 not been printer independent.
Even if you went back to Publisher 2000, unless you have the identical font
versions and printer driver you would have issues with formatting.
It sounds like the person sending you the file has a garbage HP inkjet
printer. Get them to install the HP5P laser p...Renaming Partial File Names
Is it possible to rename part of a file name? (almost like a find and
replace) My database pulls in the excel file names from a directory, with
it's subfolders and contents as well. Every file begins with "Kay Form".
Kay no longer works in our department, and I'd like to run a loop that
replaces "Kay Form" with "Featured Track". I don't know how to do a partial
Thank you in advance!
Message posted via AccessMonster.com
Checkout the Replace function. I...Isinteg Warning Message Question
I ran isinteg -pri -test alltests. I came up with 506
warnings. There are basically 4 types of warnings. They
are below. Are these something I need to worry about? What
should I do?
Warning: MsgFolder 165 (Fid=0001-0000000D1864, Mid=0001-
PR_READ_RECEIPT_REQUESTED(0029000B) prop in Messages table
and MsgFolder table do not match.
Warning: MsgFolder 4 (Fid=0001-0000086DC911, Mid=0001-
00000436F972, Inid=0001-000004A583F1): Error
JET_errRecordNotFound seeking to INID for this ...Wrong message with cascading deletes
A2003: Table Person linked 1 X M to table Activity. The relationship has its
Referential Integrity checkbox and the Cascade Delete checkbox both checked.
When I delete a person all related Activity records are deleted which is to
be expected. According to
http://www.informit.com/articles/article.aspx?p=26115&seqNum=5 I should get
the following message in this case:
"Relationships that specify cascading deletes are about to cause 1 record(s)
in this table and in related tables to be deleted. Are you sure you want to
delete these records?"
In stead I get:
I have just upgraded from Office 2000 to Office XP. Ever
since, i have been receiving duplicate email messages.
Every time i do a send/receive, about 80% of my emails
arrive twice (exactly the same ID, time, date etc.) I have
got some rules running but these are necessary. Any ideas
...printing imported gif files in Excel
When printing gif file with transparent background on the
grey(25%) background of Excel non-transparent part of the
picture has white border around it. Is there any way to
Thank you in advance...
...unknown .edb file
I have error messages in the log files that references a corrupt database
named C:\Program Files\exchsrvr\Exchangeserver_Outlook.edb. "Outlook" is the
name of the server. The problem is that this database is not listed in any of
the Mail Stores or Public stores. I want to run the repair utilities on it,
but since I'm not sure what it is used for, I don't know how I can restore it
if the repair goes bad. Does anyone know what this is used for or how I can
determine that myself? BTW, the database always has a current time stamp, so
I assume that it is used by something....Copying dbx files from a CDR back into Outlook
My computer was recently hijakced and I had to reinstall
everything. I did however save all of my folders in
Outlook onto a CD Rom and I do not know how to transfer
them back so I can use them. Also I had an animated
version of outlook where you could choose loads of
diffent stationery and I cannot seem to find that upgrade
Can you help me?
Tee <email@example.com> wrote:
> My computer was recently hijakced and I had to reinstall
> everything. I did however save all of my folders in
> Outlook onto a CD Rom and I do not know how to transfer
> them back so...VCard issue #2
This is a weird problem, but when I send a vcard to
someone, it shows up in my sent items as a vcf file, and
has a vcard icon on it, but when the recipient gets the
VCard, it shows up as msg file, with an envelope icon as
the attachment. When I open it, nothing is there - it's
empty. I can't find anything regarding this problem on
google or MS's website. Anybody have any ideas? Is it a
problem with Outlook? Do I need to do a detect and
repair, a reinstallation? Thanks for your help!
Does the same happen when you send a message to yourself? Is he/she able to
see it w...Forwarded messages are not being sent
One of our users is trying to setup his account to
forward all messages to his yahoo account. We setup a
rule that says keep a copy in his inbox and forward a
copy to his yahoo account. The yahoo copy never gets out
and message tracking says it is submitted to the
categorizer but never gets any farther. What do we need
By default rule-based forwards to external recipients are disabled. To
change this, go to Exchange System Manager, Global Settings, Internet
Message Formats.. There, you can either enable this for all domains (*), or
be specific and create a separate policy f...