Need help to read Pie Chart Series Range
Excel 2003, I have an existing Pie Chart and want to extract the Ranges
My code below returns with a "Type mismatch" error.
Dim mySeries As Series
Set mySeries = ActiveChart.SeriesCollection(1)
Debug.Print mySeries.XValues (errors here)
...need Help for Migration Exchange 5.5
we`ve the following Configuration :
- Exchange 5.5 with SP4
- single Winwos 2000 DC
- configured both side ADC
a new Hardware should be used for an Exchange 2003 and second DC.
next steps i would do as following :
- Update ADC Version with Exchange 2003 ADC
- running Exchange 2003 forestprep, then domainprep, an after all
running setup to install Exchange 2003 in the same organization, site
- replicate system Folders and public Folders
- moving all Mailboxes to the Exchange 2003 Store
- configure the Exchange 2003 virtual SMTP Server to send outgoing
- reconfigure the F...How to make Access 2007 Navigation pane invisible?
I have tried the Access Options. | Current Database | Navigation, uncheck
Display Navigation Pane, and the vertical "Navigation Pane" still displays
in a compiled .ade.
Something else yet?
"Dean Slindee" <email@example.com> wrote in message
>I have tried the Access Options. | Current Database | Navigation, uncheck
>Display Navigation Pane, and the vertical "Navigation Pane" still displays
>in a compiled .ade.
> Something else yet?
> Dean Slinde...Word Doc Macro help needed please!
I need to make a mocro that will work in a word doc. This macro would
start with  and count up one number each paragraph. For example
paragraph two would auto show  and so on. Any help would be
I have a word file which contains 100 pages. All the pages have name &
address of companies.(not in table) i have to transfer them to excel in
column format(for example first name, last name, address, phone etc)
can any one tell me code for this( i know how to open word & creat new
excel sheet) . I need code for how to reach to lines of word. r there
any thing like &quo...1099-MISC updates
Until this year, you have always provided the prior year 1099-MISC form
updates as a seperate Hot Fix or seperate Download.
This year, the 2006 1099-MISC form updates were included with the 2006 Year
End Updates for Payroll. We do not use the payroll for Great Plains so
downloading this update did not make sense for us. Also, the Payroll update
required Service Pack 5 be installed, and we were on Service Pack 3. We have
a great deal of custom Great Plains applications & there was no way I was
going to update without having the time to test our custom applications just
to get the...Writing to word 2007
I have a 2003 access database that writes data to text fields in a 2003 word
document, no problems,
I have now upgraded the database to 2007, and the same code although it
appears to run ok, does not actually update the word document fields, i also
tried converting the word document from 2003 to 2007. I data transfer using
code from within access
So no error message; it just doesn't seem top update, right. See this:
I do it with docvariables. Are you using docvariables? If so, read this:
http://w...Outlook 2007: "Cannot save free/busy information"
I have been getting the error message "Cannot save free/busy information"
from Outlook frequently these days. It started when we changed our
configuration from connecting to an Exchange server on the LAN to using a
proxy Exchange server that forwards (I imagine) to another Exchange server
on a different LAN.
I have my profile configured to deliver to a local PST file.
It seems that Outlook does successfully update free/busy info on the server
sometimes; the error message appears fairly randomly - e.g. sometimes when I
delete a meeting request, but not every time.
An...Unable to add custom field to a view/preview
I added a new attribute to the Quote and I am able to add
this attribute to the form but the new attribute does not
appear in the list of fields when I create a new view.
Further, the new field does not appear in the list of
fields if I try to add it to the quote preview. I am able
to store and retrieve the value of the new field using
the API. Thanks for any info.
I figured it out.
> I figured it out.
How do you solve the problem?
Publish and IIS reset don't help. I don't see custom fields in
"Customize views", but i can see custom fields ...Cannot open Money Deluxe 2007
New laptop, successfully using Money, then now I cannot open it. Windows
keeps shutting it down. Tried running as admin. Tried uninstalling, then
In microsoft.public.money, Karen wrote:
>New laptop, successfully using Money, then now I cannot open it. Windows
>keeps shutting it down. Tried running as admin. Tried uninstalling, then
What OS? Is there an error message?
Were you successfully using Money on that new laptop? Did the
problem occur recently? You might want to consider a system restore
point from before the pr...Do I need a licence to distribute MSFLXGRD.OCX?
I wish to use the MS FlexGrid control in my Access database.
Do I need a licence to distribute MSFLXGRD.OCX?
Paul H wrote:
> I wish to use the MS FlexGrid control in my Access database.
> Do I need a licence to distribute MSFLXGRD.OCX?
If you also use a VB application, the answer is no. But you will need to
build and deploy a VB application to distribute and register the OCX. You
cannot distribute it with an Office application alone.
Arvin Meyer, MCP, MVP
"Arvin Meyer [MVP]"...Field Service V2.0
I know that there probably isn't a lot of solid info avail about
feature set for V2.0 but I have seen a number of references to planned
addition of some type of Field Service functionality. My question
Does anybody have any insight or thoughts as to whether or not the
ability to schedule/dispatch techs and the ability to generate
invoicing for field service calls will be included?
There is something referred to as Service Scheduling in the latest
information that I have seen.
"SteveT" <firstname.lastname@example.org> wrote in message
news:1102972818.458191.150090@z14...Can I retrieve deleted email from the enlarged database
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Email Client: pop
My v.X database is 950Mb with very little email. I know this is because of the deleted emails of the past and that rebuilding the database would produce a new database the right size. I would like to know if I can get to the deleted emails. Can I get them back. I have run in to an issue that I need them.
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:12pt'>On 5/11/10 11:41 PM, in article <a href="59bb859f.-1@webcrossing.JaKIaxP2ac0&q...Run-time error 2465 after database import
I'm trying to tidy up a database by starting with a fresh, blank database
(Access 2000) and importing everything from the original database. Here are
the steps I've gone through:
1. Started with a blank database.
2. Set all the properties to be the same as the original database. I've set
the properties in:
- File / Database Properties
- Tools / Startup
- Tools / Options
- Visual Basic Editor - Tools / database Properties
- Visual Basic Editor - Tools / Options
- Visual Basic Editor - Tools / References
3. Selected File / Get External Data / Import and ...right align int fields
I would like to right align integer fields. I would like to do this in a
while/for loop in onLoad event, because I have many fields. How can I see in
...in creating a pie chart in excel 2007
How many rows or columns of data can the pie chart plot
I once tried 360 cells and got a wonderful Moiré pattern
Why not just experiment with 1, 2, 3 dozen and see for yourself if the
result is acceptable ?
Microsoft Excel MVP
"bsalohcin" <email@example.com> wrote in message
> How many rows or columns of data can the pie chart plot
According to MS:-
Data series in one chart 255 (max limit)
Data points in a...New CRM Database Views
I am need of creating a new CRM view to handle some report
requirements. I have read that views that use views are supported and
I have read that I need to create a new database adjacent to the CRM
database. How are any of youh hanlding New CRM Database Views?
If you scroll down the CRM tables in OrganizationName_MSCRM database
then you will see the ffiltered views of table.
I have created Reports in Business intelligence by using existing
views of CRM .
These views correspond to the security role of crm users.
It's a good practice to create a new database to hol...One Record Per Page Printing-Access 2007
Report for daily appointments for senior transportation drivers. Report is
grouped by Driver. Keep together is selected.
Detail band: Keep together-Yes; Force New Page-Before Section; Can
Grow-Yes; Can Shrink-Yes
Goal: Report generated so each driver has his/her own appointments.
Orientation: Landscape, paper size 8.5 x 14, column width: 13.5729"; column
When previewing in Print Preview one record per page is appearing rather
than all appointments for a driver for a given date. I have the bands as
narrow as I can make them. I am missing somethi...I need a list of command line switches for Microsoft WORD.
I am using a Shell command to execute Microsoft WORD 2003. I need to halt
execution of VBA code until WORD finishes it's task. Is there a command line
switch for WORD to cause it to pause the VBA function until it is finished?
Is there a VBA command to pause execution of code until WORD finishes? Thanks.
I am pretty sure the answer to your specific question is "No". If you tell
us exactly what you are doing, including from where the Shell command is
being executed, maybe we can suggest another way that will overcome the
Hope this helps.
Please r...Redefine field data type
I am trying to write a function in a module in MS Access 2000 that
will change the data type of a field called 'Start' in table
'bo_cpm_CS01ALL'. Here is the code that I have done so far but when I
run it nothing happens...no errors or changes to the table. The code
finds the table and field, creates a new field called 'temp' then
copys 'Start' to 'temp' then deletes 'Start' and renames 'temp'. The
field 'Start' has data type dbDouble.
Any help would be great!!
Public Function ChangeFieldType()
'Purpose: Changes a f...Need help converting Microsoft Outlook calendar to Entourage.... At wits' end here! Please advise...
I have a Mac at work which runs Microsoft Outlook 2001 client on an Exchange
server. I have a calendar on this machine (stored locally, not on the
server) which has a ton of reminders programmed into it - very useful! Now,
at home I got a new Mac laptop with Entourage X. Is there any way to move
all of the reminders (appointments) from my calendar on Outlook to my
Entourage calendar? I've tried two things:
1) I exported the calendar info as a CSV text file, and then tried importing
it in Entourage. The problem is that Entourage import function seems to
think it's importing an Address...cannot get BCM to work on Office Enterprise 2007 and Windows 7
I have Windows 7 and Office enterprise 2007 and tried to install BCM 2007 and
got it installed then opened Outlook and said it could not setup database. Is
BCM 2007 compatible with Enterprise and Windows 7. Is there a work around?
...How do I get a filter to "UPDATE" the rows selected?
I am using Excel 2002 and I have a speadsheet that has prices in it.
If I have the filter set to (the filter criteria is much more complex than
this though) prices for items that cost >$5.00.
Of I change an item to 4.59, it should not be seen. How can I get it to
re-update the rows shown, with out releaseing the filter and resetting it?
Is there something like refresh.filter or anything like that?
AFAIK you must release and reset but a macro with a worksheet_change event
could trigger this for you so that it would happen automatically.
SalesAid...center text when conditional format applied
Textbox control on Access 2007 form lost its centered alignment when
conditional formatting is applied. This did not happen in previous versions
I tried using format painter to apply conditional formats from a control
created in an earlier version, but this failed. The control created in the
earlier version then lost it's centering after saving in Access 2007.
Interesting. I tried to replicate this behaviour but failed, it all worked
as it should.
Try revisiting your form after applying the conditional formatting and
resetting the text box to center text.
...Restricting SubForm to One Record Entry Per Parent: Access 2007
I have a one-to-one relationship between two table. I have successfully
added the subform, but I get the option to add additional child records in
the Datasheet View. This means that when a user tabs to the next row and
enters data they get an error--and they should.
Question: How do I restrict the subform to show only one row in Datasheet
I hope I was clear. Feel free to ask for clarification.
Thank you in advance for your assistance.
You have two options here. If the records are already added to the source of
the subform you could set the &qu...import paradox database into excel
I have a database written in programme called Paradox and I would like to
fransfer it into Excel.
You may find this a bit tricky, depending on the complexity of links
between tables and queries within the original database. Tables hold
information, and queries manipulate that data; if you need data that is
the result of a Paradox query you will not, AFAIK, be able to import
that to Excel. You'll have better luck if you need data from tables.
In a quick web search I notice that converter software is available,
which might be a fallback position in case on-board export capability