XP: copy/paste from Access into Excel
I am converting lots of Access/Excel apps to the XP version and I hav
problems with the most stupid issues.
Here is one of them:
in the previous version (under NT) I could just copy and past
tables/queries from Access into Excel (Crtl C/Crtl V) and everythin
Now the numbers are all formatted as text in Excel unless I past
I know I could use the Tools--> Analise it with Excel (from Access t
Excel) but this opens the results in a new sheet and sometimes I nee
to paste in a specified region of existing spreadsheets.
Yes, I could also use pass through query ...I cant see pictures inserted into word/publisher
On reopening the files I can't see pictures inserted in Word or Publisher.
I'd suggest start by updating your graphics driver.
MVP Microsoft [Publisher]
"Ahsan" <Ahsan@discussions.microsoft.com> wrote in message
> On reopening the files I can't see pictures inserted in Word or Publisher.
...file share access to w2k8 host needed from image
i am currently using vs 2005 r2 sp1 on a windows 2008 host machine (secured
by ipsec). i now want to have file share access to my host from any image.
when i try to run "net share \\<hostmachine>\c$" i do receive an error as
following: "the network path was not found".
- either image client can access shares on different computers
- i can access my host from any other client in network (no virtual one)
using "net share \\<hostmachine>\c$"
- stop ipsec on host does not change anything
so the problem probably has to do with some f...vlookup problems
My vlookup of customer information is working fine until I add a
customer to the list. The vlookup formula looks fine and it's
referencing the proper worksheet (customer info). The range is fine
(I'm assuming if the data range encompasses the entire worksheet it's
fine) and the column indexes are correct. Yet, no data is returned to
the destination cells. This only started happening after I added some
customers to the customer info sheet. I'm not sure if this matters,
but I've manually updated the source links also, hoping this would
help. It didn't. Are there an...Publishing to the web through Publisher
i've just downloaded a trial version of publisher and love it so far except
it will not publish to my hosting provider, Godaddy.com.
I have completed all of the steps required per directions found at:
Everything is great until I get to the end when I get this message:
Publisher could not save the file to the web. Check your your url or network
connection and try again.
If there is any advice or technical support that someone can give please let
me know. I would love to purchase this product but I don't want to sp...Outlook Attachment problem
I have windows 2000 exchange server with service pack 3 and with all the
hotfixes, some of our clients complaigning that thes attachments are
corrupted when they receive emails from us , it works perfect some times and
some times we need to resend the email to them which is very irritating to
client and our users,
Any AV/Content Filtering/Gateways between your mail system and the
external world? I would look there if its indeed happening on your
On Thu, 3 Feb 2005 13:23:02 -0800, "Deeps"
can I repeat an image in publisher? like a line every 1/4 inch for example.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"MargaretK" <MargaretK@discussions.microsoft.com> wrote in message
> can I repeat an image in publisher? like a line every 1/4 inch for
Copy the line, place your cursor where you would like the line to paste,
right-click, paste. It could be helpful to create guides. Or select the line,
press...Installing Publisher 2003 gives an error
I am trying to install Publisher 2003. Even before it comes up with the
Product Key, it gives the message "This patch package could not be opened.
Verify the patch package exists and that you can access it."
I have Office 2003 Basic Edition installed. I uninstalled the Office and
then tried to install it but still it comes up with the same message. Did
some research and used the Windows clean up utility but to no avail.
Any help appreciated.
You receive the "This patch package could not be opened" error message in Office
2003, in Office XP, or in Office 2000
http://...access 2007 01-29-08
Is Access 2007 still in beta or fairly new? I just downloaded a
trial. I am wondering if most enterprise level companies are still on
Access 2003? Would you suggest developing a database in 2007 if
the customer doesn't have a preference? It looks like it just has a
new interface but it is basically the same as 2003?
The other question I have is about quality assurance. Is there any
tips on the MVP's site or is it in any books. I have the access 2003
inside and out book which was good but it is slow reading through
examples. Should I get the 2007 book?
...Sending Publisher Files
Just got this software last week with no manual, so Im
kinda flying by the seat of my pants here.
The question is Ive put together some promotional flyers
I need to send to my customers, but I feel confident that
most would not have publisher to read them.
Can I format them another way and still keep the flyer
looking like it should?
Check out the following link on sharing Microsoft
Microsoft Publisher MVP
>Just got this software last week with no ma...owa not access from outside
i have an exchange server 2003(sp1) with windows server 2003(sp1) , the
network scenario is that first i have router and then pix firewall and then i
have smtp filter for exchange, on smtp the port 25 is open , on pix i have
made a DMZ for exchange , means that from outside , first mails are comming
to smtp filter through the dmz on pix and then came to my exchange server
which is not F-E, internaly i am able to use the OWA through the
URl"http://servername/exchange" and on pix the port 80 is open and one thing
more is that my domain controller and excahnge are on same m...CTreeCtrl Focus Problem (is this a bug?)
I have a Dialog witha tree control and an edit control, in
a configuration window type setup.
Each item in the tree view has a type and some data
assosciated with it, which can be edited in the edit
Because the value can be a string or a number, I need to
do some validation in the edit control. Essentially, I
want to hold focus until the data is valid.
The problem I am having is that when I click on another
item in the tree view, the KillFocus event for the edit
does not fire (or rather not at once).
The order of messages seems to be:
EN_...problem in use money files after change of hard disc
I have using money since 1990 with constant updates, my latest update was in
2005. Recently my hard disc crashed and I have to change for a new hard
disc, after install money, I was unable to open my money files which run
satisfactorily before the crash. When I try to run openthe file it always
says "the file is created by an older version of money, money will save a
copy of the file and upgrade you file for use by the program". Then after a
while a message apear saying that "money is unable to acess your file .....".
Can any one help me.
I have run the same file...Confused as to publishing a web site with Publisher
I apologize for using the "General Questions" forum, but the Web Design area
doesn't seem to get much response to questions (as I have previously posted
there), and this area does and I could really use the help.
Here are the steps I've gone through.
I created a site in Publisher.
I have acquired Yahoo as my web hosting provider.
I attempted to upload my files the way Yahoo, and many other "help" sites
say, by using Publish to Web, but kept getting firewall errors.
Therefore I installed SmartFTP and uploaded my .pub file successfully.
Then I realized I can't...Digitally signed Excel project problem
When trying to save a digitally signed Excel project in Office 2000, I get
the error message "Excel cannot sign VBA macros when saving to this file
How do I fix this problem please?
...outlook blocks access to my attachments! WHY
does anyone get this stupid microsoft msg:
oe removed access to the following unsafe attachments in
This was in outlook express. I have attachments and they
are greyed out and unable to be opened! WHY is that?
HOW can i fix it and override microsoft's idiocy?
Next time, post this in an Outlook Express group - this is not one of them.
Having said that, tools->options->security.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail ...Publisher 2000 #23
After adding a new profile on a Windows 2000 box,
Publisher decides not to work (Publisher has been working
many years previously on this desktop).
I'm getting the message: "This application must be
installed to run. Please run Setup from the location
where you originally installed the application." I tried
the resolution to Article 269276 but that did not work.
If anyone has a suggestion or resolution, it would be
very much apperciated.
...Can you solve my problem?
How can I randomly select six different numbers at any one time i.e lottery
numbers. I have tried using the formula below,
=INT(RAND()*49)+1, which works OK but I get repeated numbers in a line of
six, can anyone
For one way, see:
Usage: Select six cells and array-enter
In article <boA7e.20406$Uc7.email@example.com>,
"Keith Robinson" <Keith.Robinson28@ntlworld.com> wrote:
> How can I randomly select six different numbers at any one time i.e lottery
> numbers. I have ...how do I open up publisher 2003 files in publisher 2000
I received an e-mail with a pub2003 file and am unable to open it with
pub2000. Please help
Contact the person who created the file and ask them to save it as a Pub
2000 file. There is nothing *you* can do other than to upgrade to Pub 2003.
MVP Microsoft [Publisher]
"jeanrix" <firstname.lastname@example.org> wrote in message
>I received an e-mail with a pub2003 file and am unable to open it with
> pub2000. Please help
Outgoing mail is certified Virus Free.
Checked by AVG anti-viru...Publisher 2003
I recently uninstalled norton, added macafee, did a compression and defrag
and may have deleted a file or two . . . :P Anyway, now when I try to open
Publisher or a Publisher file from explorer, I get the error 1304 message
asking if I have access to program files/microsoft
I have access to this file and can see it from explorer. How do I correct
this issue so I can run Publisher again?
Thanks in advance for helping this noob!
Operating System? Publisher Version?
By the way, left the frying pan (Nortong) and jumped into the fire (McAfee)
"...splitting of Access database
I have created one mdb file using MS Access 2003. After splitting this, the
back end of this file is migrated into sql server (Express 2005) using SSMA
for Access. The front end containing tables and forms are in mdb file.
Is it possible to create an exe file on the basis of this? If it is possible
please let me know how it can be done. Earliest response will be highly
On Thu, 6 May 2010 09:41:01 -0700, Nandini <Nandini@discussions.microsoft.com>
>I have created one mdb file usi...Problem with Data Migration Framework, nothing is migrated....
I am trying to get some data into CRM with Data Migration Framework,
but I have some problems. I have followed the guide, but when I am
doing the migrate process the data fails to migrate. To eliminate some
issues I have tried to manaully insert a testrecord in the cdf_mscrm
database using the SQL enterprise manager. The only data in the
database is a single record in the cdf_account table with corresponding
records in _ext and _info databases. The fields AccountID, OwningUser
and Name has data, the other fields are empty. OwningUser has a value
wich corresponds with a SystemUserId in the...upgrade publisher
I have a similar question to Issac. I want to upgrade my
Office 97 suite to the latest version, but Office XP does
not seem to contain Publisher (?), how can I get my
Publisher version, off of my Office 97 Pro Ed up to date?
I am getting Publisher files from newer eds that I cannot
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from dfran <email@example.com>...
> I have a similar question to Issac. I want to upgrade my
> Office 97 suite to the latest version, but Office XP does
> not seem to contain Publisher (?), how can I get my
...Sign on/off problem
my mother was using her system and while trying to change her background her
system did a restart and on startup asked for a password ( she never had to
use a password before) now when she gives it the password it log her on, the
microsoft music starts then it logs her off, and then the password window
I went into safemode tryed the administrator account but a blank password
doesn't work. Neather does any of the passwords she has used for outlook or
Question 1 why is it loging on then loging off.
Question 2 Can I use Safemode with command promt to res...Access 97 to Access 2003 DataBase conversion 08-30-07
We work in a mostly french environment. We have a standard image using MUI
Microsoft products (XP and Office 2003 are MUI) Since the convertion of an
ACCESS 97 BD into Access 2003, we experience a sort sequence problem when
DoCmd.Openform or DoCmd.ApplyFilter
A selection on a name like "Cot�" will return no record. Asking for "Cote"
will return all records including "Cot�".
I suspect a problem with MUI (multi-user interface) but I did not find any
recommandation at Microsoft.
"Jacques Tr�panier" <firstname.lastname@example.org>...