Pivot Table Cycling Through Page Fields Automatically
Hi. I am trying to cycle through a complete set of data in one of the
parameters in the "Page" field. For example, there are 500 investments, and I
want to compute the internal rate of return (IRR) for each investment based
on a series of cashflows for each investment.
The IRR is a function that is placed outside the pivot table. As each
investment number is chosen, the underlying pivot table cashflow data
changes, allow the IRR function to pick up these cashflows and compute the
IRR. However, if there are 500 investments, this becomes very time consuming
- especially if the...How to restore reports in CRM 4.0
I deleted all of the reports in CRM 4.0 from the GUI (using the X)
How can I restore these?
Try the command:
C:\Program Files\Microsoft Dynamics CRM Server\Tools>PublishReports.exe
"JamesE" <JamesE@discussions.microsoft.com> wrote in message
>I deleted all of the reports in CRM 4.0 from the GUI (using the X)
> How can I restore these?
Peter, I have already run this comand and the reports have been added to MS
Repo...Cannot access by OWA
we�ve two ex2k servers. First in domain 1 with internet connection. Second
in subdomain, connected by a dedicated line. Both servers are in same org
and site. When I try to access the second server by owa I can�t access the
mailboxes there. That�s only possible on the first server (SSL security is
Do I�ve missed to configure something?
Thanks for any advice.
Sorry, found it myself. Just have to configure the server as a
"J. Kuenzel" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Hi the...Access attachments don't work anymore
Outlook 2000's security update makes it impossible to
receive MS Access .mdb or .mde files. But I need to do
this to earn a living as an Access developer! Other than
have the sender rename the file there must be a simpler
way to override the security patch. Outlook Express let's
you turn off this feature but OL 2000 has no such setting.
(The feature is basically worthless anyway - any hacker
would know you just rename the file, put your hacker code
in it and send it. Access will open ANY file, regardless
of what you name it!!)
See if the information on the following page help...Add a specific Record to a Table based on a check box
I have a Table called ServiceTypes. Based on a User's input on a
ProposalForm, ServiceTypes need to be added to a ProposalServicesTable.
For instance, I have a Check Box on the ProposalForm. When a Check Box is
clicked Yes, Access must search the ServiceTypes Table, select a specific
ServiceTypeID, and add the ServiceType to the ProposalServicesTable.
How can I add the proper Service record from the ServiceTable to the
ProposalServicesTable based on the Check Box?
I wouldn't do it that way. I'd use a listbox (with multi-select set to YES)
that was sourced to the ServiceTab...Saving a calculated field
First, yes I have read the threads on storing a calculated field and that it
is bad mojo to do that. However, I have pay data that I calculate and input
to a database and it must be able to be reconciled with our ADP data. So I
need the ability to change and fix the data so it does not change as a result
of recalculations. I have a form with a field that calculates the pay based
on hours and pay rate. I have another field (the "copy" field) next to that
one that has the control source set to the database field. I have set the
default value of that field to be equal to the...frustrations with Access 2006
is anyone else frustrated with the number of time, when editing a
project..., Access 2006 crashes, leaving behind a corrupt, un-repairable
file (or somtimes just a corrupt form, never-the-less: frustrating)?
short of going back to an earlier version of the program, does any one have
thanks in advance...
"Mark Kubicki" <email@example.com> wrote in message
> is anyone else frustrated with the number of time, when editing a
> project..., Access 2007 crashes, leaving behind a corrupt, un-re...outlook 2003 add a dictionary
how can add a dictionary for spell checking ?
in outlook 2003 su tools / options / spelling
actually i have only English e French.
...Do you need Access to use an Access Database for data entry only?
We have an Access database completed. Now we will use it for reading as well
as for data entry. Do we need to install Access for every workstation
needing the database for data entry or reading?
No you don't necessarily need Access on every computer. You CAN use the
Access Runtime and if it is in Access 2007 you can use it for free. If you
are using another version then you would need to purchase the developer's
edition to be able to legally distribute the associated Access runtime.
If you do have 2007 and want to use the runtime, make sure your Full version
of Access doe...Access, average several fields in one row
I have several rows of data in a field, I need to average all the entries in
I have 12 fields for 12 months of data, I need the average of the sum of all
non blank entries.
For example 3 months completed, the solution in Excel is
I am looking for method to average the sum in Access
One way if you can't change your data is to use a VBA function. I've posted
one below. You would call it in a calculated field in a query. Assuming your
field names are the abbreviated month names the expression might look like the
Field: fRow...How do I add a hyperlink to an individual word in an Excel cell?
I am using Excel 2000 (not by choice) and I need to add a hyperlink to an
individual word within the cell, not the whole cell itself. For example in
the sentence "Click here or here to go to the appropriate web page." I want
the words "here" to each have a separate hyperlink.
Any ideas? I can manage some VBA too if necessary.
You can't do that in Excel.
You would have to use HTML or Word or some other means.
You could fake it, the entire cell would be a link, but you could
after assigning the hyperlink select another...Access 2007 Reports
I'm using an Access 2000 mdb (split ends) in Access 2007. I cannot up-
convert because other terminals don't have Office 2007.
It works as a database just fine except:
When I try to change a (front end) report from the default printer to
another specific printer in design view, page setup, it all LOOKS good
except it does not save my changes upon return and goes back to the
I never had this problem with earlier versions of Access and the
specific printer in questions works fine with other apps and
Any ideas people? Many thanks.
This is a known prob...want to add all $ in column c where column A is the same
I'm very new at Excel, and a real math dummy. I've
figured out how to enter a formula when all the $ I want
to add are together, but I can't figure out how to do
that when I want to select only the $ values for certain
items listed throughout the spreadsheet. For example:
I keep a running list of Architects, their projects and $
values of each project as they are assigned. I want to
automatically calculate the total current $ value for
each Architect without having to sort them in order, or
create a separate table for each architect. Can I do
Here's what th...pivot table -repeating "months or days" after grouping
I have data that includes the month, day, hour, min. When I run th
pivot table function to reduce the data to hourly I need the date t
repeat in the date column.
9/19/2002 0:00 2.7
9/19/2002 0:10 3.7
9/19/2002 0:20 3.8
9/19/2002 0:30 4.6
9/19/2002 0:40 4.8
9/19/2002 0:50 4.8
9/19/2002 1:00 5.6
9/19/2002 1:10 5.2
What I get when I group the Pivot table:
Sep 19-Sep 12 AM 2.7
- - 1 AM 3.7
- - 2 AM 3.8
- - 3 AM 4.6
- - 4 AM 4.8
What I want is:
Sep 19-Sep 12 AM 2.7
- 19-Sep 1 AM 3.7...Is store procedure always fast than Access linked table via ODBC?
I was assigned to upgrade one program from Access(using ODBC to connect to
SQL 2000) to ASP.NET(using store procedure in SQL 2000).
Finally, I tested them and found that ASP.NET is slower than Access.
The mojority job of program is select some data from SQL 2000 tables, modify
and then insert into some tables.
Is store procedure always fast than Access linked table via ODBC?
Message posted via http://www.sqlmonster.com
Stored procedures don’t add any overhead and they can save compile time.
It's the code in the stored procedure and the underlying tables / indexes
that ...IE8 can't access Microsoft Office site when all other browsers can
When trying to access the Microsoft Office page using IE8 I keep getting the
"Internet Explorer cannot display the webpage" message. If I use any other
browser (Firefox, Opera, Safari, Chrome) I have no problem accessing the
page. This happens whether running in normal or No Add-on's mode. Despite how
many people keep complaining about all the problems with IE8, neither the
MVP's or Microsoft acknowledge that they exist.
Intel E8400 Core2Duo 3.0GHz
4 GB PC2-6400 DDR2
Windows 7 Ultimate (with all the latest updates installed)
NIS 2010 (all up to date)...Unable to open Access 95 mdb in Access 97
I am trying to open an old Access 95 mdb in Access 97...I
didn't create it but someone who knew the database way
back when said that a system.mda file was created for
that particular database because it had a lot of personal
info in it.
(I am not familiar with mda files...the database folder
also had a system.ldb file there as well...I deleted that
file...but am unsure why it wasn't closed out to begin
I was able to open Access 97 and repair it...but when I
go to open it in Access 97...I get an Automation
Error...Cannot find VEENLR3.hlp file.
Do you think it may ha...Error in Detailed Sales Report
Have you encountered a strange scenario wherein in your shop you have sold 1
item in that particular invoice/receipt # but when it got connected and
process the WS401 and when you run the detailed report in HQ level , it was
added up with some items which is not in the original shop transactions.
Trx # item Qty
1023 apple 2
Store Trx# Item Qty
A 1023 apple 2
A 1023 orange 3
A 1023 banana 2
Which in the store A transaction, those items where not in that trasaction
but somehow when it was connected and process...Backup error Access Denied
I have been recieving the following error message for a while and can't
figure out how to fix it. It is only happening on one mailbox.
"Backup - \\MBMAIL\Microsoft Exchange Mailboxes Access denied to file Jhon
Doe [jdoe]Top of Information StoreSync IssuesServer FailuresMail
Delivery (failure firstname.lastname@example.org)." Help Please
Can you access the mailbox from a mail client? If so, you can use mdbvu
to look at the Top of the Information store folder, and delete the message
If you cannot access the mailbox, then I have seen it where some users think
they are ...graph add ins for dials or dashboard reports?
I am trying to create some dashboard reporting at my company and cannot find
any addins for this purpose. Can anyone help ???
I've heard from a few people that like Charley Kidd's dashboards. I
haven't tried them:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I am trying to create some dashboard reporting at my company and cannot find
> any addins for this purpose. Can anyone help ???
...HR Benefit Deductions Summary
I'd like to modify the HR Employee Benefit Deductions Summary window to not
pull in any inactive benefit or deductions codes.
Can I simply do this in VBA or is there something "bigger" that I need?
I think you would need to build a new window using Dexterity or the upcoming
toolkit. I don't see how VBA could prevent the data from being displayed.
Charles Allen, MVP
> I'd like to modify the HR Employee Benefit Deductions Summary window to not
> pull in any inactive ben...need to make a formula that would add a field value to current dat
I have made a form in which I input different values. On of the values is
(How Many Days). Now I need to a assign a default value, or expression (not
sure which way to go about this) that will take the date value for (Date) and
add the value (How Many Days)
I figured that the formula should read =sum([Date]+[How Many Days])
But that is not giving me any results, thanx for your help in advance
=DateDiff("d", Date(), [How Many Days])
"J Man" wrote:
> I have made a form in which I input different values. On of the values is ...Report Writer
I am trying to modify the Financial Trail Balance in Summary in Report Writer
in GP10 to have two separate columns: one that shows the ending credit
balance and the other column to show the ending debit balance. Also at the
bottom of the total for the debit and credit columns I need to show the
profit/loss that would display on an income statement. If possible provide
some details if they have every created this modified report or let me know
where I can find more information on generating these reports. Below is an
example of how the report layout.
Account Description ...Outlook Today
On the Outlook Today page the "Options" button does
nothing. We're still runnning Win 98 SE2 with no immediate
hopes of upgrading. Any help would be appreciated. Thank
david <email@example.com> wrote:
> On the Outlook Today page the "Options" button does
> nothing. We're still runnning Win 98 SE2 with no immediate
> hopes of upgrading. Any help would be appreciated. Thank
This question has been asked and answered 100,000 times (literally). SEARCH
for the answer.
3290 Patterson ...Ad Hoc Reporting #2
I am putting together an ad hoc report in Excel. My query is in the VB
editor. I am trying to specify criteria
Select x,y,z where...
in the WHERE, I am struggling.
I want to take a range of ids specified in the worksheet, F2:F55.
Select x, y, z where IDs IN ( F2:F55 )
I tried to use WHERE IN ( Range(F2:F55) ) but it did not like it.
What syntax should I use to make this work? Thanks!