Version 2002 - Org Chart - Creating using wizard with xls Data Source
I'm creating an org chart using xls spreadsheet as the data source. Is
there a way to sort the branches alphabetically automatically?
Unfortunately, the Org Chart solution generates the diagram using a random
Office Graphics - Visio
This posting is provided "AS IS" with no warranties, and confers no rights.
"u828576" <firstname.lastname@example.org> wrote in message
> Hi Guys,
> I'm creating an org chart using xls spreadsheet as...How can I add multiple source data data labels?
To be more exact, I require my original data labels (in an Area Chart in
Excel) to remain visible, ie £250,444; in addition I require to show on the
same drop line, either above or below this original figure, the Loan To Value
amount, ie 48%.
I am sure this is possible, however I am unable to discover the correct
process to enable this eventuality.
First you need to create a concatenated formula in the spreadsheet, then you
need to use a custom add-in to use those cells a data labels.
Assume you 250,444 is in column B and the 48% is in column C then in column
D enter thr...Auto generated item lookup codes and customer numbers
Is there a way to have Item lookup codes and customer numbers automatically
generated in RMS? Apprecite the help!
you can do so to create the trigger of database, but there is one issue, the
UI(user intereface) has it own validation in RMS. mean whenever you create
new item the UI of RMS> Item Screen give you warning that you must enter the
item lookup code. you can do so by entering anything may be one numerical
character but the system generate the code base on the below trigger as item
lookupcode : here is the code:
CREATE TRIGGER CreateLoookupCode ON Item
FOR INSERT ...Validation code not working with pasted data
I have a worksheet that has one column with data validation in place and
some other columns (I and V to AW) with some validation vba code in place.
Everything works fine when data is entered by typing it into the cells, but
neither the dv nor the vba is effective if data is pasted into the cells. Is
there any way I can get round this?
The vba validation code is below (if this helps).
Hope someone can help
Private Const WS_RANGE_PC As String = "I1:I999"
Private Const WS_RANGE_TIME As String = "V2:AW99"
Pr...Error code C00D11BA
ok - here's a mystery: i run windows mp10 and nero on a 64bit xp - sp3. both
players have performed very well up until last night. now when i attempt to
play a file, i get the error above - which makes no sense in the context of
my recent experience w/mp10. and i also noticed that my nero player just sort
of freezes up when i try to play a file as well - no audio no nothin.
interesting enough, under the sound and audio device properties window, the
options in the audio and voice tabs are grayed out. this was not the case
earlier, as these options were clearly available just ...Event 1023, Source IMAP4SRV
Exchange 2003 SP1 on Windows 2003 Server.
One user is causing a lot of the following entries in my servers Application
Event Type: Error
Event Source: IMAP4SVC
Event Category: Content Engine
Event ID: 1023
Time: 10:24:32 AM
Error 0x8004050a occurred while rendering message 0001-0000000ee9a0 for
download for user ESolley@netopia.com.
For more information, click http://www.microsoft.com/contentredirect.asp.
0000: 3e 0b 0d 00 >...
Aside from my log filling up, any idea what these are?
It could be a probelm w...Hide row code help
I am using the following script to hide or unhide rows. How do I code the
offset to only work when a row is being unhid. If we cant do this only
offset when it is being hidden or unhidden?
Private Sub Worksheet_Change(ByVal Target As Range)
'Application.EnableEvents = False' not necessary
If Not Application.Intersect(Target, Range("B9")) Is Nothing Then
Rows("10:11").Hidden = IIf(UCase(Range("B9")) = "", True, False) 'spelling
'Application.EnableEvents = False
...Reports source ?
Is it possible to get the source for the existing 3.0 reports to work out
from ? Not the rdl file but the project so it's possible to see how they are
made in Visual Studio.
Anyone has good links to report creation sites / webcasts
the rdl is all you need however go to the downloads section at this site for
more informatoin on reporting
Microsoft CRM MVP
"Jack" <jackdSPAM@jackd.dk> wrote in message
news:%236ckcF6vGHA.1772@TK2MSFTNGP...to help malicious code from running one or more objects in this fo
I was getting ( the custom form could not be opened) I cleared the cache.
Now it say' ( to help malicious code from running one or more objects in
this form were not loaded.) then it say's ( script error page
SBE.DataGrid1,line No:11 )
Looks like the scenario described here: http://support.microsoft.com/kb/223845
Is this really old data? Or a really old form?
FYI, there is a separate newsgroup for Outlook forms issues --
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Powe...Need to create a VB script for Microsoft Outlook
I am a newbie to VB scripting. I have this problem I need to solve in
Often we have seen when people reply to emails, they say "please see
my comments inline marked BlahBlah".
Whenever people do such inline commenting, I would like the script to
copy that info to the top of that email, along with a "link" to that
embedded line. When the user click that line, the cursor show point
the actual place where that comment was made. Pls let me know how can
I implement in a VB script.. When the user right clicks the mouse at
the end of of his embedde...VB.Net: how to carry SessionID(its value ) from 1 function to othe
If I get SessionID in 1 function how do I carry that SessionID(value of this
SessionID) to another function or another form within the same project
Winforms or webforms?
In Winforms, u can make the SessionID a public or internal property of the
form and in WebForms use the Session object to hold this value.
"XML newbie: Urgent pls help!"
<XMLnewbieUrgentplshelp@discussions.microsoft.com> wrote in message
> If I get SessionID in 1 function how do I carry that SessionID(value of
> SessionID) to ano...Creating Sources
I often use online databases to find information for essays and such. Which
option would be my best bet to plug in the information properly? I know there
IS something to use for journal articles, but those seem to be for print. Can
it apply for web versions too?
I'm not entirely sure, but I doubt any of the styles that came with Word
2007 add electronic information to journal articles.
What Word does is collect all the information you provided for a certain
source and pass it along to your style (an xslt file). Your style then takes
the bits and pieces it needs, formats th...Visio, VB Form, OLE control
I want to put a Visio drawing on a Visual Basic 6.0 form
and then want to control shapes at runtime (changing
colors, text, etc). I created a sample VB application and
on the form added an OLE control with a Visio drawing in
it. At runtime when I change any property of a shape on
the drawing, the whole drawing refreshes and it flickers
too much. Is there any way to avoide flickering? Is there
any other way to use a Visio drawing on a VB form? I tried
Visio Viewer 2002 control. But, it doesn't return the
Visio.Page object from its Object property.
Thanks in advance,
I...Dynamic change of chart source
We have a chart on one of our many reports that shows the last twelve months
of data presented in a bar graph.
Is there a way to have the source position change dynamically do I do not
have to move the sourcing information on the chart every month.
As an example, the data is formatted like:
A B C D
2006.... 01/2007 02/2007 03/2007 04/2007
100 200 150 175
The starting point of the last twelve months is dependant on the current
reporting month which is always 10 days after month end. The data starts at
2005 through...Creating an MDE database in code
I have arequirement to send out a database to be used by other personnel,
this database creates other databases for clients, I want the Client
databases created to be mde's so that no one can go in and mess with the code
or forms. Any ideas?
On Thu, 11 Mar 2010 12:48:01 -0800, Blondie
Microsoft Access MVP
>I have arequirement to send out a database to be used by other personnel,
>this database creates other databases for clients, I want the Client
>databases cre...Displaying HTML/XHTML from source XML file
Displaying HTML/XHTML from source XML file
i am having an xml file
i want to display the contents of the xml file in a web browser control
however i want to display it as html/xhtml after applying formatting.
how can this be done?
...95 Code Won't Work In 2000
I used to use Access 95 VBA but now have to do something in Access 2000.
The following in Declarations:
Dim dbs As Database
Dim rst As Recordset
Followed in a procedure by:
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("tblMain")
Would open the table for use. However, in Access 2000, this simply results
in error messages. As far as I can see the Database option in "Dim dbs As
Database" no longer works and is giving me Type Mismatch messages. How do
I do this operation in Access 2000 please? Oh, can you keep it simple
please, I haven't...tag tax schedules as customer or item only when appropriate
In many states various items are taxed at different rates. In this case
users create item tax schedules and customer tax schedules. In my many years
of working with GP - their design is great - but sometimes users get confused
between item and customer tax schedules. I would like at a minimum to tax
schedules taged as used on items only or better yet would be a toggle to tag
a tax schedule as item, customer or both.
Even better would then limit the results in lookup so in an item or item
class record you only see item tax schedules and in a customer or customer
class lookup you on...Excel Events Conflict with VB and C# AddIns
I have two com addins running in Excel. One is written in VB and the
other in C#. Both addins are interested in the Workbookopen event.
When the event is triggered the c# code captures the event but the VB
code does not. If i disable the c# addin then the vb code works. Looks
like the c# addin is somehow blocking the vb events.
Anyone know how to fix this?
There is only one WorkbookOpen event, so once one add-in hooks it, there
is nothing for the other one to hook.
If you are hooking the WorkbookOpen event in your add-ins, this is
likely your problem.
You may need...installing driver error code 1
I have a developed a driver for a usb device. I am able to install the
device, using my driver, on XP and Vista, but not on Windows 7. When trying
to install it on Windows 7, I get "installing new hardware" then "device
driver software was not successfully installed". When I go to device manager,
and look in the details of the properties of the device, the install error
says "device instance name is invalid".
Any ideas of what does that mean and why it is working on Windows XP and
Vista but NOT Windows 7?
Any ideas how to go around it?
Thanks!...My Publisher is "out of control writing 'gibberish' code .........
How do i fix this problem. When I open Publisher 2003, it
loads and then begins to write what appears to be code.
It is out of control, writong this 'gibberish',and then
at the bottom, where the pages are shown, it loads page
after page of this dang crap?!?!? Does anyone know what
is happening to me??????? M. Slowruner R.
Has this always happened with Publisher? Have you tried to uninstall and
MVP Microsoft [Publisher]
"slowrunner" <email@example.com> wrote in message
news:firstname.lastname@example.org...Charts not recognizing source data if original linked data is changed.
I am very frustrated by Excel (2003) at the moment. I'm relatively new
to using Excel in depth. I have always been able to work my way through
most intricacies and pitfalls. But now I have been working in a workbook
with linked sheets (and with linked workbooks too) and have two problems
that I cannot solve.
Right now, I have about 47 sheets that are set up as follows:
detail data: this is the raw data the the user enters
daily totals: this is calculated data from the detail sheets
summary sheets: further sums from the daily totals and a chart object
that charts these sums (a line or sc...How to hide sheets and VBA code in my Excel workbook?
I write VBA code to automate certain functions in my Excel file, and I use a
lot of "template" sheets to generate charts and save them as a new xls file.
My client wants to run my programs on their site, which requires that I give
them a copy of the main Excel workbook that contains my templates and VBA
code. Is there any way for me to hide them so that my client cannot copy my
code? Ideally, I want to be able to password-protect everything in my file.
(The client really just has to press the keyboard shortcut --- CTRL-M --- to
run my main routine.).
Thanks for your help.
G...Change Source Campaign on Invoice and Order
I need to change the Source Campaign on an Invoice and an Order but the field
is locked. I tried to enable the field on the form but still cannot make
changes. Any ideas beyond direct edit of DB?
...Any way to load VB persistence in C++?
I've re-written an old VB6 ActiveX control in C++ as a COleControl,
duplicated all its properties and functionality, and taken over its old
CLSID and ProgID.
Now I'm looking for a way to load the old persisted properties in the new
Our container supports an ASCII persistence mode which implements
IPropertyBag. In this mode, the properties that the VB control wrote out
via PropertyBag.WriteProperties map right in to my new control's
DoPropExchange PX_blah methods.
In binary mode though, when CreateControl( ) winds its way down to my
DoPropExchange, all the PX_blah me...