#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 ...multiple flyers per page?
I need to make a custom template with publisher.
It will be one 8 1/2 by 11 paper divided horizontally into three parts so
that there are three fliers that can be printed. each flier needs to be
double printed so I need to make it a double sided project like a postcard or
brochure layout. I can figure out text and image stuff.
But I don't know how to make a basic custom project that is divided into
three panels horizontally (so 8 inches by 3.83 inches roughly)
Also an additional customization would divide each 3.83 by 8 inch flyer into
two parts so one 8 by 11 page would ...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...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...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...printing 2 charts on single page
Using Excel 2k, Win 2k
I was trying to print to line charts on a single page to demonstrate the
corelation between the two data sets.
I would like to print in portait mode with one chart on top of page and one
on bottom. Excel only seems to offer putting chart 2 on a separate page or
embedding it in chart one.
I am not very familiar with excel charting capabilites can anyone suggest a
...Help, I cannot Save!
I created a document and locked the worksheet to protect the formulars
before creating a template for the document. But now when I open th
document and insert a new sheet using the template I created, th
document will refuse to save.
Once I click on save, office assistant will say "doc not saved". Wha
could I have done wrong? PLease help.
computerfineman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3716
View this thread: http://www.excelforum.c...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....pdf save as settings
Hi, In Office 2007 Pro is there a way to change the settings such as
preventing content copying etc. when saving a file to pdf? I have been
trialling Open Office, alongside Office 2007 Pro (full version not a trial),
which allows access to these settings but I can't see a way to do it in MS
MS Office doesn't do that.
> Hi, In Office 2007 Pro is there a way to change the settings such as
> preventing content copying etc. when saving a file to pdf? I have been
> trialling Open Office, alongside Office 2007 Pro (full version not...Web query timeout setting.
I fill an Excel table using data that I take from an Internet
Unfortunately, this site is very slow and so I often get a "query did not
provide any data" error message.
How can I increment the default web query timeout limit?
Thanks in advance,
...I cannot get the pictures to show on screen in Publisher web previ
I have tried embedding and linked but nothing seems to work. Do I have to
apply a master page? It is to be a one page web site. This is probably so
basic but I am trying to teach myself how to use it. What do I have to do to
have them show in preview and once uploaded?
Are you using FireFox to preview or IE?
"rendul" <firstname.lastname@example.org> wrote in message
>I have tried embedding and linked but nothing seems to work. Do I have to
> apply a master page? It is to be a one ...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...Page setup for 8.5x11 calendar w/picture on tabloid paper?
How can I set up a calendar with 8.5x11 (landscape) pages with pictures for
each month to print on tabloid (11x17) paper so it can be saddle stiched? I
would like the picture on the top half and calendar on the bottom half. I
keep ending up with two of the same pictures on one page and two calendars
on the next page. Thanks, Bob
I assume you are taking this to a professional printer so why not just set
each page up as a landscape 8� x 11 and let your printer do the rest?
MVP Microsoft [Publisher]
"Bob at 4799" <Bob at email@example.com>...Budget Wont Save
I have have Money 2002 for awhile and have never been
able to save a budget and start a new one. I decided to
start over with a new file, but once I get all my info
back in there, it still won't save. MS has no info in
the KB about this. Anyone else have this issue?
...Hyperlink problem #3
I've got two workbooks on a shared drive with hyperlinks
linking the two. When a user clicks on the hyperlink on
the first workbook, it takes him to the second workbook.
Fine. However, when the user clicks on the hyperlink in
the second workbook to go back to the first, the error
message says that that workbook is already open and it
cannot open two files with the same name. Help is
I just tried a small test in xl2002 and it worked ok for me. I use
Insert|Hyperlink to create the links.
Are you sure that the hyperlinks point at the file you want--same folder and
e...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...View original Excel after saving over it
In error, i hit save instead of save as. I'd like to view the original
documents contents. is this at all possible. i use windows xp. excel 2003
Not very likely.
Try a Google search action if you haven't already, but I think it's
This underscores the importance of backups.
http://www.wimgielis.be = Excel/VBA, soccer and music
> In error, i hit save instead of save as. I'd like to view the original
> documents contents. is this at all possible. i use windows xp. excel 2003
In article <C2A3F0E7-24E0-43A5-809A-ECA719...How to save Japanese characters in CSV format of Excel ?
I would like to know, how to save the Doubly-Byte characters.For example,
Japanese in CSV of Excel.Here are the steps, I tried.
1. Open Excel
2. Copy pasted the Japanese charactesrs in a cell.It is displaying the
3. Save as CSV(Comma seperated file)
It is saving as ??????.
Thanks in advance for the info.
...DB_Backup.MDB file has appeared beside DB.MDB.
I have a local DB.MDB which accesses a DATA.MDB on a network drive.
I use a user-level security file.
It has been working AOK for a year or so.
Yesterday one of the users reported an error dialog when attempting to open
the DB.MDB (unfortunately the wording of the dialog was not captured!)
After this 'event', the database started working correctly once again.
The result was a DB_Backup.MDB file appeared beside the DB.MDB.
That backup file is created when ACCESS "crashes" during use.....
<MS ACCESS MVP>