Switching from Powerpoint to Access
Help!I have used the following VBA code to open MyDatabase.mdb from a button onmy PP Presentation which has the advantage of not exiting the presentationto use database illustrations.Private Sub ViewDatabase_Click() Dim stAppName As String stAppName = "C:\Program Files\Microsoft Office\Office\MSACCESS.exeC:\MyDatabase.mdb" Call Shell(stAppName, 1)End SubHowever, I would prefer to directly open a specified form (MyForm) within the databasefrom the said button.Can anybody suggest the code I need to add ?Would appreciate help.Dick Troy There are two options.1 is to go under To...Use a picture as text
I recently saw a brochure made with MS Publisher that had text that was made
from a photograph. Does anyone know if this was done in publisher and if so
how it's done? It was a picture of a truck on the road seen as several
letters to form the picture. The letters looked like word art. Thank you
>I recently saw a brochure made with MS Publisher that had text that was
> from a photograph. Does anyone know if this was done in publisher and if
> how it's done? It was a picture of a truck on the road seen as several
> letter...Link Worksheets
I want the user to select which worksheet to work on..i have a total of
39 worksheets in the workbook.I dont want the user to be able to use
tabs found at bottom of worksheet.
This sheet is kinda front sheet..
For instance if user wants to go to 39 sheet..
IS it possible to select it from a combo box list and then jump to that
I hav 13 wards wit 3 option breakfast,lunch ,tea....13 *3 = sheets
Anyway you can select one of 13 wards from combo box and then select
one of three options and then jump to that worksheet..
Closest thing is having a hyperlink on worksheet that links to a...Publisher 2003 files try to open in Publisher 97 #2
Back again, but with a different Pub 2003/Pub97 issue
Have Office 2003 with Publisher 2003 and Publisher 97 both on my XP Pro system
Recently I find that files created in Pub 2003 are being saved as files with
the Pub 97 Logo, and when you try to open them from the file listing, they
open Pub 97, which correctly posts a box telling me that it cant open the
If I use Publisher 2003 to open the same files from within the application
the work fine.
When I select a 2003 Pub file which contains the Pub 97 icon, the file list
does not contain Publisher 2003, but when I browse and locat...Publisher 2003 Printing Problem #2
I am experiencing a problem printing to printers from
If the printer is added via printui.dll as a Per Machine
Printer connection publisher will not print to it. All
other printing from windows works fine.
If I add the printer just to the user's profile, then
printing appears to work just fine.
For some reason Publisher 2003 is unable to print to per
machine printers setup from a network share via
Any help or suggestions? I can find nothing in the
knowledge base to help. Why is Publisher affected in
this way? The rest of Office prints fine...How do I make door hangers using publisher?
Is this even possible?
Mary Sauer has a website with a generous collection of goodies including
Take a look at just above George Washington's portrait (way down the page)
Don - Publisher 2000�
"medinapie" <email@example.com> wrote in message
> Is this even possible?
I have a sample on my web page. Scroll down -- on the left.
Some cute ones here that you could mod...Telephone format of Contacts in Outlook (public folder).
I've got lots of contacts stored in a Contact folder in my Public folders.
All of these contacts have the phone specified with multiple format (UK,
International.. other) depending who did enter the contacts at a given
I now have to uniform that to one single format (eventually reject and flag
for manual update the contacts with non-recognizable number)
I'm totally novice in Outlook / contacts / PF scripting, and I'll be glad to
get any tips here.
It's still better that if it would have been worst...Public Folder Replication not running
We have two exchange 2000 servers in the same exchange organization, same
active directory domain. We have one set of public folders that have been
configured to replicate to both servers. We would create public folders on
one server and then they replicate to the other server immediately
(replication interval set to "always"). But last week the replication
suddenly stopped for new folders, although existing ones still appear to
replicate their contents. When we create a new folder on one server, and
set it in system manger to replicate to the other server, replicas never
appear ...Missing Public Folder Store
In Exchange 200 server System Manager, the inherited permissions on the Public Folder Store under the First Storage Group were accidentally removed. After doing this, the Public Folder Store does not show up anymore, but the database files pub1.edb and pub1.stm still exist in the MDBDATA folder
Is there any way to reset the permissions on this object. I would expect it to still show up as an unmounted database but it does not show up at all
Use ADSIEdit to add the inherited checkbox back.
ADSIEdit can be found by installing the Windows 2000 Support tools off of
the Windows 2000 CD.
ADS...Sharing Categories in your Public Categories with Other Users.
Is their any way that you can share the Category information that
you've tagged a certain contact information and other users on your
network can see that category you've assigned it (since it's in a
For instance, we have a public folder which has a list of our
contacts, we want to categorize them since their is a vast number of
them and it's become unmanageable.
If I click on the contact and assign it a category, it seems that I
can only see the category that i've assigned it on my workstation, but
i can't see what I assigned it on my colleagues comput...SQL Back-end / Access Front-end using linked tables????
I have a backend that contains tables that I pull Driver information,
Customer information , etc. (these are MAS 200 accounting software
tables that are exported nightly to the SQL backend). I also have on
the backend tables that I push information to; information that we
enter on the forms located on the front end. I might not have this
up correctly, but I'm linking all tables on the back end to the
database on the front end. When trying to set up an Auto Lookup off
a query I've created in Access it says I need to go into the table
change Data Type to the Lookup wizard,...Excel sheet truncated after copying to powerpoint slide
We are using Office 2000 with sp3. When we copy excel sheet to power point
slide, some of the rows and colums are truncated. Also the font size is
changed. We can see only some part of the sheet.
Let me know if anybody faced this problem..
Thanks in advance
Debra Dalgleish posted this link that you may want to review:
> We are using Office 2000 with sp3. When we copy excel sheet to power point
> slide, some of the rows and colums are truncated. Also the font size is
> changed. We can s...Can't see public folder in ESM
I want to add a public folder and mail enable it (as I did many times before)
but when I go into ESM there is nothing under the Public Folders. The only
thing that has changed is that I just installed SP2 for exchange. I can't
find the solution to this.... any help would be great. thank you.
On Sat, 11 Mar 2006 13:06:27 -0800, Joe J.
>I want to add a public folder and mail enable it (as I did many times before)
>but when I go into ESM there is nothing under the Public Folders. The only
>thing that has changed is that I just inst...Can I link Notepad text file to Visio Standard 2002 SR-1?
I have two questions:
A. How to have Visio Standard 2002 SR-1 move a notepad text file fro
one directory to another directory?
B. How to pull notepad data with Visio Standard 2002 SR-1 int
I have a PC with Entivity Studio; this same PC is going to have
process analyzer dumping a Notepad text file to the C drive. Th
analyzer adds new data to this file about every five minutes, or i
will create a new file if one is not there. Somehow I need to grab thi
data and display it on the Entivity HMI.
To make sure I always grab the most current data, I was thinking o
moving the entire text ...Publisher 2003 Viewer is needed
Can Microsoft create a free viewer program for .pub files like they have for
the other programs in Office?
Can they? Yes
Will they? Unlikely
Larry M. in Illinois wrote:
> Can Microsoft create a free viewer program for .pub files like they have for
> the other programs in Office?
Larry M. in Illinois <Larry M. in Illinois@discussions.microsoft.com>
was very recently heard to utter:
> Can Microsoft create a free viewer program for .pub files like they
> have for the other programs in Office?
Could they? Yes
Is it profitable for them to do so? Probably not.
W...Linking Combo box to pivot table?
I have a pivot table which has teams on the left, months on the top and a
count of the calls in the data area.
What I would love is that if I could have a combo box on a worksheet which
when I select a team from its list it only shows me that teams data in the
Is this possible please??
Windows 98 + Office Pro 97
You could move Team to the page area of the pivot table.
Select a team, and the pivot table will only show its data.
> Hi All,
> I have a pivot table which has teams on the left, months on the top and a
> c...links are breaking ??
We have a few excel files which link to other files. Several people use them
each month. We are experiencing broken links (like someone chose to break
the links or copied/pasted values).
Is there any excel reason this could be happening, or is it definitely user
I've never seen excel convert formulas to values without someone asking for to
I'd start the investigation with the users!
(And you're sure there are no macros lurking that could be doing this in
> We have a few excel files which link to other files. Several people...HELP ME! Outlook Express Freezes When I Click On A Link
All of a sudden when I click on a link in an email message in Outlook
Express, not only does the link not open, but my whole Outlook Express
program freezes up.
I'm running Win XP Professional, Service Pack 1.
Does anyone know a fix for this? It's driving me crazy.
You should probably ask this "down the hall" in one of the Outlook Express
newsgroups. This group is for Outlook from the Microsoft Office suite which,
despite the confusingly similar name, is a totally different product.
Ben M. Schorr, MVP
Roland Schorr &...Publisher 2007, file too large.
I have recently installed publisher 2007. When I try to save any files bigger
than 1.5MB it takes a long time in trying to save it and then gives the
message: The file is too large. Delete some objects and save again. I never
experienced this problem with Publisher 2003.
Any suggestions/help will be appriciated.
How much RAM are you running?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Mr. E" <Mr. E@discussions.microsoft.com> wrote in message
>...Copying and Pasting Between Published Documents
I have created a 132 Document in Publisher 2007
I needed to make a highly customised and intelligent Index so I created a
second document and typed the index in that, having both documents open on
extended Windows Pages
I thought it would be easy to move the index from the second document into
the first document containing the text
It does not appear possbible to copy and paste table pages between the two
Is there any way I can accomplish this task without retyping the Index in
the first document
1. Create on your 132 page document a bla...Navigation Bars
I put Navigation bars on my publisher website document. When I try to publish
to a file or to the web, the Navigation Bars do not appear on the page(s).
How do I resolve this??
Answer found in the web group.
"Tom Snyder" <Tom Snyder@discussions.microsoft.com> wrote in message
>I put Navigation bars on my publisher website document. When I try to
> to a file or to the web, the Navigation Bars do not appear on the page(s).
> How do I resolve this??
Tony, did you get an answer to this...HELP!! PUBLIC FOLDERS E2K3
I am running Exchange Server 2003 on a standalone Win2k3
server, both are Enterprise version.
Earlier today, I rebuilt and defragged the public folders
for both the default public folder store and a secondary
public folder store.
After rebuilding and defragging, the secondary public
folder store was fine, but the default public folder store
was no longer listed in the First Storage Group.
The .edb & .stm files are intact and are consistent
(eseutil /mh), but for some reason the First Storage
Group, which uses pub1.edb is not listed in the First
Storage Group. If I attempt to...Guides not visible over images in Publisher 2003
i am using publisher 2003 under XP with SP2 and am having the following
i am creating a flyer. i want to have an image going across the entire
background. when i try to pull the layout guides out from the ruler, i don't
see them (yes, they are on, too). as soon as i delete the image, i see them
again. i would expect the guides to be on a meta level...above everything
else, since they aren't really objects meant for printing.
any ideas on how i can get them to show?
thanks brian... don't know why i didn't think of this myself. instead, i let
...Problem replicating Public folders
We have two Exchange Servers in the organization. One is running Exchange
Server 2003 Enterprise (Server A) and the other has Exchange Server 2003
Standard (Server B), both fully patched.
Contents of some public folders are being successfully replicated between
the two folder. For some reason, the other folders are not. When go to the
Replication Tab of these Public Folders, I get the following error message:
An unexpected, unknown error has occurred. MAPI, or an unspecified service
provider. ID no:...Publisher 03, how do I apply a change to all pages in a calendar?
I created a 12-page calendar - a full page per month. How can I change a
font and have it apply to all 12 pages? Similarly, how can I add a graphic
and have it show on all pages? Thanks!
Click the font scheme, it should be on the calendar task bar, if not open it from the
format menu. Select a font scheme or create one of your own.
The graphic is simple enough, insert it on the first page, paste it on the next 11.
It should paste exactly where it was placed on page one.
Mary Sauer MSFT MVP