Change Attribute Properties Before Installation
Is there any way to change ADAM so that the Locality-Name, Postal-
Code, State-Or-Province-Name and Street-Address attributes are multi-
valued on a new build? Our CTO wants us to create a customer ODS
using ADAM and some of our customers have more than one address. He
wants us to use x.500 attributes as much as possible. Based on what I
have seen regarding this standard, these are the attributes that I
should use, if I want to store the parts of the address separately.
unfortunately there is no supported way to do this as isSingleValued is
system only and so cannot be...Change default file location?
I have been looking , unsuccessfully, to figure out how to change the
location of my outlook .pst files from the default C:\ Docs & Set, etc.
location to my D: drive.
This is the only Office XP component that I have not been able to get
moved to a more "common" area.
Could someone please tell me how to get this accomplished?
I am running Office XP on Windows XP Pro, SP2
Thanks for the help.
You can use the ForcePSTPath registry value to force the creation of new PST
files to an alternate location.
If memory serves me right, this v...how to change toolbar in session expiary
Actually I have created a toolbar for IE which will be changed after
user loggs into our site and will be changed again after he logs
out.These things I have done ,but the problem comes when it is session
expiry.if the user does not do anything for 20 minutes in our
site,then the session will expire and according to that the toolbar
should also be changed again.How can I achieve that?My idea was to get
the cookie value for that user when he logs in and firing a MySql
query with the cookie value to our database each time when there is a
page navigation or page refresh.If my query returns wi...The future of FRx
Can somebody please clear this up for me. Currently we are using Dynamics GP
10 and FRx 6.7 for our financials. We are looking for a Business Intelligent
tool that will let us create BI reports [we are an investment banking firm].
My research on Microsoft's site indicates that FRx is being phased out and it
will be replaced by Management Reporter. I took a look at MR and it looks
like a dupe of FRx. Also we are looking at Enterprise Reporter - can somebody
confirm if ER can generate the same financials as FRx? I then hear that ER is
being phased out. Which products should we be loo...Has COleDatabase changed since VC6 ??
I posted a question the other day about a COleDatabase problem. I have now
created a dummy project and brought all my various lines of database code
together into 1 method and narrowed it all down to one simple chunk of code.
The following few lines works perfectly in debug mode, but in release mode,
hits an exception, which causes a crash. Firstly 2 lines creates a database.
Then I create a table called "table1" and then I try to create a field in
that table called "id". This line causes an exception, "System resource
exceeded". I have been using code that...Numbers change into date.
I have excel 2003 and am doing a project for my school in it. The problem is
that every time I write something like 18,4 it changes into 18.apr. It only
happens in some rows in one of my Sheets so i guess it's something to do with
the settings. Because of this i cant finish my homework, but i don't want to
Begin by typing an apostrophe (single quote):
Gary''s Student - gsnu200779
> I have excel 2003 and am doing a project for my school in it. The problem is
> that every time I write something like 18,...Changing Template on existing Workbooks
is it possible to change template on existing Workbooks in Excel ?
I have ten workbooks based on Default template and I would to apply them a
new customized template created by me. I didn't find how to make this change
in Excel or by VBA Excel.
Does anyone know it?
Once the new workbook is created from the template, there is no tie back to the
You'll have to make the change to each of the workbooks.
> is it possible to change template on existing Workbooks in Excel ?
> I have ten workbooks based on Default template and I...how to change font size of datalabels of two charts in a sheet
i have two charts in a sheet
how to change the font size and AutoScaleFont of datalabels in them
amrezzat's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28766
View this thread: http://www.excelforum.com/showthread.php?threadid=540051
The required syntax is discoverable using the macro recorder. The final
result would look something like this:
For Each chtob In ActiveSheet.ChartObjects
For Each srs In chtob.Chart.SeriesCollection
If srs.HasData...Changing the cell color due to results.
I saw this feature on a spreadsheet before, but I was unable to figur
For example, the total assets must equal total liabilities an
shareholder's Equity. So I have in cell A2 the sum of all Asse
accounts from another tab, in call A3 the sum of all Liabilitie
accounts from another tab and in call A4 the sum of all Equity account
from another tab, then, in cell A5, the result should equal zero if
have no mistakes. "Assets minus sum of Liabilities and equit
(A2-SUM(A3,A4))". If I have an error in the other tabs, the cel
returned a background color, which was...Insert Blank Row with data match change
I'm trying to figure out a way to evenly space data. Where I don't have a
repeat value in the row directly below the current one I want to insert a
blank row. Some of my data series looks like this.
Column A Column B
Part Number Description
(Cell A2): AC011000 (Cell B2) FUEL TANK, CARTRIDGE ADAPTOR
(Cell A3: AC011000 (Cell B3) FUEL TANK, CARTRIDGE ADAPTOR
(Cell A5) AC011001 (Cell B5) XX55 Assy, Li-80 Adaptor
AC051000 KIT, XX25 MANUALS
AC051000 KIT, XX25 MANUALS
I want a blank row to be i...FRx
Running FRx 6.5 w/ Great Plains 7.5 on Windows 2000 Server via Citrix.
We are having trouble with FRx and it appears to be a file sharing problem.
When we have multiple users working at the same time, the financial statement
called up by one user will be presented to another user and override what
that user was working on. Also, in one case, a user printed a financial
statement only to find out that FRx tagged another user's financial
statement to print.
Would appreciate any assistance or suggestions.
Are the users printing the same report? If so, FRx uses a single fil...How do I change the scale of part of an axis in a graph on Excel?
I have a graph that needs to use a large scale up the top, but down the
bottom I was wondering if I could 'squash' the scale. I think it's possible
to do this in another application (Datastudio) where it inserts a 'squiggly
line' between parts of the scale it collapses/squashes.
This is in Excel 2003.
http://peltiertech.com/Excel/Charts/BrokenYAxis.html may help ?
"Secateurs" <Secateurs@discussions.microsoft.com> wrote in message
>I have a graph that needs to use a ...can i change the part of the data in a colum?
i need to know if i can change the last 2 digit's for an entire colum. it
currently has 8-10 digit's but i need to alter the last 2 for all rows. Is
this possible and how, if it is?
If you have your list of numbers (8 to 10 digits) in column A, put this
=MID(A1,1,LEN(A1)-2) &C1 in column B (copy formula down to last
corresponding entry in Column A).
In Column C, insert the numbers that you want added.
The formula in column B will extract the numbers in column A (except the
last 2 numbers) and add the numbers that you have placed in col...FRX
error 3050 when starting FRX any thoughts?
Hmmmmm..... Doesn't appear to be a Pervasive error.... Could be a SQL error.....
Could be an OS error.....
With a lack of any other pertinent information, could it be a Windows error
relating to not being able to lock the database..... Could occur if the user
only has read access and therefore the database engine cannot write a lock....
How about the entire error message and more info about the version numbers for
Greaat Plains, FRx, database, etc....
Just some thoughts.....
On Mon, 19 Jul 2004 13:45:29 -0700, "Shannon" <sh...shape of cursor does not change over command button on second monitor
I am using Excel 2K SP3 with Win XP pro SP2.
I noticed that the shape of the cursor does not change when I move it over a
command button. This only occurs on the second monitor, on the primary one
everything is ok. Any clues or solutions to this problem? Does anybody know
if this problem is solved in later Excel versions?
With a Radeon 7500 dual monitor card, and Excel 2002, The mouse turns into
an arrow when over a command button. But if one Excel window (in one
monotor) is active, and I move to the other, it's an arrow whether I'm over
cells or...Business Portal Electronic Requisitioning "Change Approver"
I have selected "Change Approver" on the "Manage Users" page on Electronic
Requisitions but I cannot change approver when doing a requisition on "Show
More Options". It defaults to the person next on the hierachy. How can I sort
this out? I have read the Requisition Management and User's Guides and have
not found anything new except that the option "Change Approver" on Manage
Users have to be ticked.
In order for the user to be able to change apporvers they have to be in the
tree in multiple paths.
...FRX Error #3
FRX for Great Plains - SQL Server\MSDE will need a registration number in 30
Also another error about evaluation period has expired for this product. We
bought the product with the license.
Some users can access FRX fine, others getting this error.
Any suggestions appreciated.
It appears that the clients are not using the same sysdata folder.
Charles Allen, MVP
> Getting error
> FRX for Great Plains - SQL Server\MSDE will need a registration number in 30
> Also another error about evaluation period ...Change Format
Another Question from Andrew.
I have a table [Contracts] with a field [Contract_Number], text field, no
duplicates. This table is maintained by in house (Back end). Users of the
database (Front end) fill out routine data on forms which fill up several
tables. Queries are used to compile data for reports, most of which is the
same however depending on [Client] the format of the form must change. I have
designed several forms to meet their “Particular needs”. Is there a way to
fire off the info to the right form (using a print form button) based on
Any h...Calculate Year Correctly
I am developing a spreadsheet to help me with employee vacation tracking. I have varying vacation amounts, depending on the number of years of service. To help calculate what vacation is due, I put their hire date in and in another cell I have today's date. The problem is, when I tell it to calculate by the year, it is wrong because the (Year(F2)-Year(F1)) type formula looks ONLY at the year, not the whole date. Therefore, an employee beginning on 12/31/1999 would have 1 year of service on 01/01/2000, according to this formula. I can't figure out how to account for the enire 360 days b...FRx Tree Question
This is a part of my tree:
I have the following formula:
Description: 5610 Some Revenue, Fmt Code: CAL, Related Rows/Unit: IF
@UNIT(SUMMARY^R^21) THEN @691*3
This will give me an amount for SUMMARY^R^21 only. I want an amount to
appear for SUMMARY^R^21^150, SUMMARY^R^21^160, and SUMMARY^R^21^170. In
to do this I have to add 3 more formulas(e.g.IF @UNIT(SUMMARY^R^21^150)
The thing is that my tree is big and i will need about 150 formulas t...FRX Multi Currency
Is there any work around when FRX DAX is not working as it is used to work
with FRX Currency Translation Reporting?
When using more than one data/record in DAX Table in one month/year -
Historical eg. Retained Earnings Account. FRX is always returning an error
message that the Balance in DAX Table is not equal to Great Plains computed
Balance. This is causing discontentment from the client since the software
can not deliver what it is intended to do. Instead of effeciency in
Reporting, you have to manually compute the translated balances of Financial
You can define onl...Change from wmp 6.4 to wmp 9 series in my ocx
Really hope someone here can help me out .
I have a nice old ActiveX in one of our ActiveXes, namely the wmp 6.4. Sadly
there's seems to have occured some problems with the compability layer in the
9 series. Videos doesn't behave as expected anymore, so I'm thinking
switching to wmp 9 in the code might help, but I can't find any good
documentation on how to fo this.
I've tried the exampl in the SDK:
m_wndView = new CAxWindow;
m_wndView->...changing colours of multiple items in Publisher 2000
Does anyone have any idea how I can change the colour of multiple items on a
page? It is so time consuming to have to select and change the colour of
each item individually - it would be so useful to be able to select all the
items I need and change the colour en bloc.
Do the newer Publisher packages have this facility (2003, 2007?)
What items are you trying to chage?
MVP Microsoft [Publisher]
How to ask a question
"Fluffbrain" <Fluffbrain@discussions.microsoft.com> wrote in message
news:0B67BD6A-B0E8-45A9...How to make the color change stick in a PivotChart
I have a PivotChart (bar chart). When I format a data series and chang
the color of the bar, it changes color OK. However, when I refresh th
PivotChart, the color reverts to the default. Can you help
Message posted from http://www.ExcelForum.com
> I have a PivotChart (bar chart). When I format a data series and change
> the color of the bar, it changes color OK. However, when I refresh the
> PivotChart, the color reverts to the default. Can you help?
For the "parent" table, uncheck AutoFormat in Table Options.
Thanks, but that didn't work.
I did not...Universal Change from 12 pt. to 8 pt.
Operating System: Mac OS X 10.6 (Snow Leopard)
I have written a 300+ page book on Scripture. Throughout I have use Garamond 12 pt. for each verse and the number that precedes each verse. My publisher believes it would be less confusing if the number before each verse was Garamond 8 pt. Is there any way to universally change all numbers to 8 pt. without also changing the text? I doubt it, but one never knows. Thanks
In article <59bb5e51.-1@webcrossing.JaKIaxP2ac0>,
> Is there any way to uni...