global macro instead of specific workbook
If I create a macro and toolbar to call it
while i'm in spreadsheet "a",
when I close spreadsheet "a", the toolbar still shows in excel
but if I click on it it opens spreadsheet "a" (in order to run the macro)
How to make toolbars be "generic"... not tied to a specific spreadsheet?
I exported the module to my code folders but don't see how to de couple the
code from the original spreadsheet.
You can place all your macros in Personal Macro Workbook which makes them
available for all open workbooks.
Assign the macros on your Toolb...Access 2003 Developer Extensions 06-04-07
It doesn't seem to be available anymore. I can read about VSTO 2005,
but get an error if I try to buy it. Is it possible to get this still?
I know Access 2007 Developer Extensions are supposed to be free, but
they don't seem to have been released yet. Will I be able to package
and distribute an application built in Access 2003 with the 2007
"Toxalot" <firstname.lastname@example.org> wrote in message
> It doesn't seem to be available anymore. I can read about VSTO 2005,
> but g...Excel bug: conditional formatting
When using conditional formatting with more than more
formula, the formatting ceases to go through all
conditions once one condition becomes true.
This isn't the same behavior as when cell values are used.
This to me is a bug, but if this is intended, it should
at least be an option to continue through all conditions.
The behaviour is the same when cell values are used. For example:
Condition 1: Cell Value Is greater than 10 Format: Bold
Condition 2: Cell Value Is greater than 20 Format: Red
Condition 3: Cell Value Is greater than 30 Format: Italic
A cell that contains a...Reminder Date in Outlook 2007
I would appreciate help with this problem. I often set reminders on e-
mails using the Right click on the e-mail in my inbox and selecting
Add Reminder... My problem is that the default date for the reminder
is:01 January 4501 at 08:30 am. I am perfectly happy with the time,
but cannot find where to change the default date for this option. My
computer date and time are correct, and so is my calendar in Outlook
working on the correct date. I am running Windows XP Home SP3 and
Office 2007 SP1.
...Mailbox restrictions not working?
client: Outlook 2000
server: Exchange 2000
Alright gang, I really need your help. I have a mailbox for our
conference room setup as a resource. Here's a list of things I've
1. Created new mailbox for conference room
2. Entered the mailbox through outlook and turned on the Auto accept
meeting invites and cancellations.
3. I also set the auto decline conflicting meeting requests.
4. I made the additional step of Setting the Permissions of the
calender (within outlook) to give the Default user only Reviewer
permissions, and a select few (managers) Author permissions.
5. For...Pivot table question #9
I recently had a problem with values not showing properly in my PivotTable,
until it was poited out to me that I was using Text in some cells instead of
Ideally, I would like to include text. Is there anyway at all that I can?
My data comes from an Access Table by the way
the data in the pivot shows scores overall of several years competition, and
each meet has 2 reserves, who can step in for an excluded competitor.
However, the reserves might not compete, but still need to be recorded as a
competitor at the event.
Rather than showing zero (0) as their score, I'd r...Outlook accessing wrong server for public folders.
I have an Exchange 2003 routing group with 4 Exchange
servers. I have created public folder replicas on each of
the Exchange servers, however, when any Outlook client
accesses the Outlook Security Settings public folder (or
any other folder?), it always connects to the first
Exchange server where the Outlook Security Settings
folder was created.
I found this by checking the connection status window in
Outlook 2003 and noticed that it is connecting to the
first server for public folder access.
I checked that the default public folder store on each
server is set to itself.
Th...Bug: Hotfix 911829 malformats HTML in replies
Installed hotfix 911829 for Microsoft Exchange Server 2003 (fixes some issues
with Outlook Web Access) the other day. Discovered that when an OWA user
replies to a message, the HTML in the message is malformatted. Specifically,
the closing </HEAD> tage is messed up, so there is no apparent closing tag to
Most email readers don't seem to have a problem with this (they'll figure it
out), but Entourage X and 2004 for Mac will display the message as blank.
Uninstalled the hotfix, and the messages were properly formatted.
Reference: http://support.microsoft.com/k...Office 2007
I am replacing my PC and have Office 2007 on it. I cannot find the original
CD and am wondering if I can run it from an external disk, because I plan on
pulling the hard drive out of my old PC and using it as an external disk for
my new PC. Will Office 2007 run from it?
In article <26C00CCD-2C28-4685-BB55-71E97B4789C4@microsoft.com>,
dnar <email@example.com> wrote:
> I am replacing my PC and have Office 2007 on it. I cannot find the original
> CD and am wondering if I can run it from an external disk, because I plan on
> pulling the hard dr...using outlookweb access
Hi, i don't know if any one can help me on this. Here it
is. I am using microsoft Outlook webaccess to access my e-
mail from the office while i am at home. But i also want
to be able to browse my company's network at home also,
and have access to files and folders,so that i can do work
from home. Is this possible. Please resond, this is very
They could set up VPN for you...
"Anna" <firstname.lastname@example.org> wrote in message
> Hi, i don't know if any one can help me on this. Here it
> is. I am using micros...Cash Flow option won't work PLEASE ADVISE
When I click on the Cash Flow Option I receive the
Please create at least one checking, savings or cash
account before you go to the cash flow forcast.
This is Money 2004 but information was taken from 2001.
Any ideas on how to get rid of that and utilize the cash
flow feature. I have applicable accounts.
Thanks in advance.
You might do an advanced search for newsgroup microsoft.public.money at
http://groups.google.com. Others have seen this. I'm not sure if there have
been any fixes reported.
"Jeff" <email@example.com> wr...How to replicate Excels' numeric "Accounting" format in Access Rep
How to replicate Excels' numeric "Accounting" format in Access Report
client want's Access report to output values in format identical to Excel's
numeric "Accounting" format
if I try to difine it as such it converts the 'Format' definition to >>
and strangely dosen't give the desired result
I'm using Office 2003 on Windows 2000
Have you tried Currency with 2 decimal places?
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom...PowerPoint 2007 Printing issues
This issue has been driving me crazy: we have presentations that have linked
excel tables and pictures, and everything looks awesome in print preview and
presentation mode, but when I print, some linked excel tables and pictures
just show blank.
I have played around with it, and the only way to guarantee it prints is to
paste everything as Bitmap picture, but we need the linked Excel table
function to save tons of time cutting and pasting.
As I said, some of the tables will print, but some of them don't, which is
driving me nuts, and everything is fine electronical...Access product activation page
I have a trial Microsoft Office on my laptop. I have bought Microsoft Office
Home and Student 2007 from PC World.
The Instruction says to 1.Start Word 2. Locate the Product Key on the back
of the Media Holder. 3. Enter the 25 digit Product Key to unlock the
The missing stage in the process is : How do I access the Product Key
activation screen with the box in which to enter the Product Key?
I seem to recall that the trial provides the option to change the product
key from Word Options > Resources, but as you have bought a full version on
disc, it might be wiser ...IP Sec with DPM 2007 or DPM 2010
Hi, we are about to implement IP Sec for a group of servers which will be
backed up by DPM. I wanted to find out if there are any restrictions
regarding backing up IP Sec hosts vs non IP Sec hosts in the same domain. Any
info will be appreciated. Thanks!
There is no restrictions on IP sec policies on DPM as IP sec policies
work at much lower layer than what DPM uses. But the policies should be in
such a way that both DPM and Production servers should be able to
communicate with each other, like network share browsing etc..(any windows
applications between these two machines...To unlock the access of my Excel sheet
I have forgotten the password who locks the access to my Excel sheet.
Could somebody explain to me the way to unlock this Excel sheet?
Thank you in advance,
You can download the free Utiliities program from
This includes a password breaker by the wizard Bob Bovey.
remember, if this helps click Yes
> I have forgotten the password who locks the access to my Excel sheet.
> Could somebody explain to me the way to unlock this Excel sh...Opening and Refreshing a Crystal Report from Access
The Access database is not secured. I am trying to hyperlink a Crystal
Report - it will open the report, but when I try to refresh the data, it says
I have to log in. I am not a developer. I simply want to connect some
Crystal Reports to a form in Access for my team's use. Is there an easy way
to do this?
Carrie L. wrote:
> The Access database is not secured. I am trying to hyperlink a Crystal
> Report - it will open the report, but when I try to refresh the data, it says
> I have to log in. I am not a developer. I simply want to connect some
> Crystal Reports t...Large Excel file size caused by a bug ? I really tried everything
I have an Excel file of 1 worksheet, containing data in about 20 rows by 20
columns, which is 310 kB ! I noticed copying the range of cells A3:E7 and
pasting it doubles the file size, but I cannot find anything wrong in those
cells. I tried the following:
1) If I copy all worksheet and paste it in a new worksheet file, the new
file size is the same, > 300kB
2) If I copy and paste all the data column by column, the new file size is
16 kB !
3) If I copy all worksheet and paste values only, the new file size is 14 kB
4) If I delete all the data and the cell formats in the original wor...Access Accounting Software Needed
Can anyone recommed an accounting software package that has been written in Access. I have be assiged the duty of finding a new accounting software package to replace our old outdated AS400 system, for a very small manufacturning plant. Basically to keep up with sales, inventory and shipping. I need a package that I can get the source code with in order to may modifications as needed. The only thing I can find is a package made by Database Creations. I like the program except for the somewhat outdated screens. Any recommendations would be greatly appreciated.Thanks,Terry "Terry&quo...Macro Xcel Windows
Every time I open a xcel file contains macro. A Micro xcel
window pop up with message of "Macro may contain viruses.
It is always safe to disable macros...."
How do I get rid of this popup and go right into the xcel
without this pop up
you can set the security settings to 'low'. Goto 'Tools - Macro -
Security'. Though I wouldn't recommend doing this. This feature should
prevent macro viruses.
If you have a Excel file with this popup though it does not contain
macros, you may go in the VBA editor and delete/remove all modules for
this specific...Two-Axes Pivot Table Chart
Hi Folks - Here's my dilemma ...I have a pivot table that looks like this:
Unit1 SumOfCatCount 50 60 70
CountOfCat 1 2
Unit 2 SumOfCatCount 55 60 70
CountOfCat 3 4
Unit3 SumOfCatCount 75 75 80
CountOfCat 2 5
I can make a nice...Size of file with pivot table
I have a file that was 8MB when I started. I created a pivot table pulling 7
fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot
table would cause the file to be so large when the 8MB file already had pivot
table sin it?
When it was 8MB, it had 6 pivot tables.
Now it's 20MB and it has 7 pitvot tables.
Why is this one table so much larger?
Were the 6 PivotTable independent, or did they all use the same cache?
If you build PivotTables that use another PivotTable as reference (for when
you're reference the same raw data, just taking a different...Call for opinions on Visual Source Safe with Access 2007
I am at a point where I think that a solution like Visual Source Safe
may make sense for my mult-developer environment. I did dabble with it
back in the late 90's and found that it often resulted in corruption
and other issues. (Damned if I can remember any specifics.)
In any case, I am looking for any feedback on the current state of
this product from actual users. I am expecting migrate to Acc2007
soon and think it might be a good time to put the project under better
source control. I am most interested in what limitations and/or
problems you may have encountered as users and ...vbTab or Chr(9) not working
Im trying to use the vbTab or Chr(9) in order to get a tabulator character.
The result is always a single space instead of a tab. Any ideas why?
="test1" &vbCrLf & "test2" results in "test1 test2"
is the tab character not supported???
Thanks for any help
...Running an Access 95 application
I have to run an Access 95 application for testing purposes. On my machine
I only have a later version of Access. I don't mind installing Access 95
also, but I was told that this will give conflicts with the later version.
Is this true? Can I expect conflicts? What can I eventually do to prevent
Message posted via http://www.accessmonster.com
AFAIK, you can run Access 95 and other versions of Access on the same
machine without any problems (other than the fact that Access 95 was
probably the worst version of Access ever released...)
Just make sure you ins...