#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...Linking a Chart with graphics to ppt
when I create a chart with scatters, which carry graphics like
and link this to Powerpoint, the graphics are shown there in a very low
quality with large pixels.
Any ideas how to improve this?
Thanks in advance,
...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...Can E-mail recipient policy be linked to the OU membership?
Running Exchange 2003 (mixed mode) and Windows 2003 server (Windows 2000
I'd like to create a e-mail recipient policy that is linked to the different
OU's that are created on the system.
Is it possible to link the policy to a specific OU or do I need to create
groups on the AD to control which recipients a policy applies to?
Yes, you can create a recipient policy that looks to just a specific OU. It
is done through LDAP queries. Here are some references to articles and
whitepapers that discuss how to work with recipient policies.
HO...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
...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...publishing
I'm trying to REMOVE the publishing funtion of
a "previously published" excel document. I can't see
where to remove the function. How do you remove the
option. I've tried resaving the document and looked at
all options I see.
From the Excel Help
Modify and republish data on a Web page that was previously saved by Excel
When you publish or save your Microsoft Excel data as a Web page, Excel
creates an HTML version of the file (with the extension .htm). If you want
to update that data on the Web page, and you saved or published a worksheet
or items on a wor...Printing double sided brochures in publisher
I am trying to print a tri-fold double sided brochure in Publisher - my
problem is that the 2nd page prints upside down - how do you get both sides
of the brochure to be printed the same direction?
> I am trying to print a tri-fold double sided brochure in Publisher - my
> problem is that the 2nd page prints upside down - how do you get both sides
> of the brochure to be printed the same direction?
If you're manually duplexing: Rotate the second page through 180° before
reinserting it into the printer.
If you're auto-duplexing: Change the options on ...Opening publisher 97 with a later version
I have publisher 97 on my windows xp and it works fine. However, I had someone refine some work I had done and apparently they used a later version of Publisher because when I loaded their CD, I got the message "Publisher cannot load files from a different version"
What can I do--does this mean I have to buy a later version to match the version he used, or do I have to buy one of those programs that can open other programs. If I do the later, will I be able to use my 97 version to make changes once I get the files open on the later version
http://www.mvps....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...Help me identify my missing permission (Cannot open public folder) -2147217843 (Maybe Authentication Fails?)
The following snippet of code throws an error number -2147217843. When
I googled this error code, I see many references to authentication
failed. I am assuming my problem is some kind of permission related
problem on the "MyNewFolder" public folder.
-- start code ---
Dim objFolder As New CDO.Folder
Dim f As ADODB.Field
'sURL is like: file://./backofficestorage/mydomain.com/Public
objFolder.DataSource.Open sURL, , adModeReadWrite, adFailIfNotExists
--- end code --
I have code that runs before this that actually creates the
"MyNewFolder" publ...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 firstname.lastname@example.org>...Publisher 2007 frequently crashes
I'm having some difficulty with Publisher 2007. Whenever I try to open a
particular file, the program crashes. I get no error message, except that
Publisher needs to close. I've run Office Diagnostics (twice), with no
results. I can open other Publisher files. The file that I am trying to open
is an internal website for the company I work for. This file began acting
strangely a couple of weeks ago - it wouldn't insert a duplicate page for a
while, but I found a workaround, so I didn't worry about it. However, now I
think that it may be a part of a larger probl...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...Need HELP! for Linking data
Could someone please direct me to where I can learn how to link date in a
work book. i.e., I have individual pages for each subject but I need the
data that is entered in these individual pages to transfer to the Master
without having to manually in put it.........TNX
There are not too many bits about linking worksheets or workbooks that I can
But have a look at the links below, in case they give you the information
I think it is frustratingly one of those things which is very easy when you
know how, or if you can get someone to actually show you, but if you hav...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 ...