#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 ...Can you insert a picture into a specific cell?
Or do they only "float" on the page.
They float over the worksheet, but you can adjust the size so that it seems to
fit a cell exactly.
If you insert a picture, you can hold the alt-key down while you move/resize the
picture. When it gets close to the edge of a cell, it'll snap-to that edge.
> Or do they only "float" on the page.
...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...Can't insert Char(1) into SQL Server from Stored Procedure
I am trying to insert a char(1) field into a table from an ASP.Net/C#
At first I was inserting rows into the table but none of the columns that I
was inserting the rows into were char(1) columns, they were mostly int and
Then I found out that there was one column in the list that was not supposed
to be an int column but instead it was supposed to be one of the char(1)
columns into the table.
So I replaced the int column in the list with the char(1) column and since
the value of the char(1) column resulted from a CheckBox ('Y...CFile (delete file)
How can I delete all files that end with ".temp" in some folder?
"Petar Popara" <firstname.lastname@example.org> 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" <email@example.com> 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...Attachments in Outlook 98
Hi there, my Organisation are using Exchange 5.5 SP4 and the client is
Outlook 98. A mail is sent from an external source into our
Organisation to 10 people. The mail has an XLS attached. For some
reason 9 of the recipients get the attachment but the last one has no
attachment and no reference to it in the mail she receives. I've
checked all the Outlook settings I can think of, but am puzzled as to
why this happens - checking the imc data from our Exchange I see that
the correct RFC headers are present and that the user has the same
reference as all the others in the header. Anyone any ide...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...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?
...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; ...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 ...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...Outlook rule to move read message from Blackberry
I have Outlook configured with a Blackberry server and want to set up a
rule to mange messages marked as read: For example.
1. I'm away from the office, Outlook is closed.
2. I read an email on my Blackberry, which marks the message "read"
3. When I return to the office and open Outlook I want to:
a. Apply a rule to my inbox that states: If message is marked as read,
move to folder "read messages"
b. All unread messages will remain in the inbox.
I'm a heavy user of rules but I can't find a way to identify
view360@gm...Couldn't Find c:\windows\system32\system.mdw Message
Loaded Access 97 on my new Vista Machine and got the above message when I
tried to start Access. How do I fix this ?
Vista has more stringent rules about who, and how you can write to the
System32 (or Windows for that matter) folder. If you have another machine
with and unsecured system.mdw file try to copy it to your new one. If it
lets you, you are fine, if not you'll need to work with someone in a Vista
newsgroup to figure out what the problem is.
Arvin Meyer, MCP, MVP
"JWalker" <JWalker...Duplicate Messages
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 <firstname.lastname@example.org> 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...attachment previewers not installed?
I have a newly installed Office 2007 and cannot open several attachments ie
WMV as I get a message "no previewers installed" How can I resolve this
do they open if you double click them? The previewer error is because they
can't display (or play) in the preview pane - you need to open the
Are you using Vista or Windows XP?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
daily...Shortcut for inserting names?
I am building many formulas, each with many named cells as part of it.
Currently I have to go to Insert | Name | Paste with the mouse each time I
want to insert a name. I looked in Walkenbach's Excel Bible but couldn't
find any mention of a keyboard shortcut or other shortcut. Is there one I
could take advantage of?
I've got Excel 2002.