credentials to run this report are not stored
I'm getting this problem when I try and create a timed subscription.
Error: ...credentials to run this report are not stored.....
ok I created another folder under the same folder where I'm having this
loaded the report and I have no problem. I even moved the current folder
with that report in it. Creted another folder with the same name
and still the same problem with that named folder. With a different name for
the folder I have no problem???
I'm stuck here.. almost all post just talk about storing the credentials,
Already done and works...Change database source for pivot table
I've built a pivot table based on an Oracle database.
however I want to change the source database (from test to live) but can't
figure out how to change the source database.
Just answered my own question, in the query go into table definition and
change the database
"Neil" <firstname.lastname@example.org> wrote in message
> I've built a pivot table based on an Oracle database.
> however I want to change the source database (from test to live) but can't
> figu...Auto-print Pivot Table Report that cycles through all Page Field values...
Suppose I have a pivot report with a Page Field. In my case, it
allows a drilled-down view for a given state using source data
covering all states. Pretty common use case, I imagine.
I'd like to be able to have excel print a multi-page report for all
states (not together, but individually). It should just cycle through
all values of the page-field value.
This seems like a pretty basic thing to want to do with a pivot table
but so far I don't see that it's possible. I mean, sheesh, they even
called it the "page field" as if it's supposed to be part of a
multi-pag...Need only one DLL instance to run...
if two apps load the same DLL - LoadLibrary(...) - system will create to
different instance of the DLL...
Now, in my DLL i've a CList and i need it to be visible to all instance and
Is there a way!?
I need the dll to remain loaded till machine reboot!!! Is it possible!?
>if two apps load the same DLL - LoadLibrary(...) - system will create to
>different instance of the DLL...
>Now, in my DLL i've a CList and i need it to be visible to all instance and
>Is there a way!?
It'll be difficult to share a ...Do you use Pivot Table
I found Pivot Table is very handy but would you have users see Pivot Table
instead of forms? Should I look for codes that will do the drag and drop?
Experts, what are your suggestions?
Message posted via http://www.accessmonster.com
accessuser via AccessMonster.com wrote:
> I found Pivot Table is very handy but would you have users see Pivot Table
> instead of forms? Should I look for codes that will do the drag and drop?
> Experts, what are your suggestions?
Users which understand a pivot table, are normally fit in Execl. So
exporting the raw data to Excel w...Repost: Error running Report in an Access 2003 db from Access 2007
Ok, clarification - ignore the code from my original post, some of the
reports do work. The ones that don't are reports that I have being filtered.
Here is the code from one of those buttons:
Private Sub Ok_Click()
On Error GoTo Ok_Click_Err
'using the customer sub form for customer state report to filter the
report, clicking ok will open report for selected state
Dim stDocName As String
Dim stLinkCriteria As String
If Not IsNull(Me.Search_Results) Then
stLinkCriteria = "[StateOrProvince] = """ & Me![Search Results] & """"...run time error 10-22-03
I am having a lot of trouble when I open up word I get
run time error 52 in VB. I have tried uninstalling word
and reinstalling it. WE have tried deleting the macro
but still to no avail can someone help me please?
...Automatically run macro
My name is Mike and i have a question about microsoft excel macro's.
Attached is a copy of the excel sheet im working on. Below the excel
sheet is the macro I built. Some of the cells contain given values and
some cells are calculated from formulas. Cell (G4) is my given
value...it is related to cell (C32). The point is, I plug a value into
cell (C10) and it runs through the rest of the calcs in the other
cells and gives me a value to cell (C32). I built a macro that works
as a goal seek pretty much. The macro makes cell (C32) equal to cell
(G4) and gives me the value for cell (C10). I wan...tables created by Linking an Excel File
I have a linked access table created from an excel
spreadsheet. Then I used Table Analyze feature in access
to split this and the split created 3 seperate tables.
When the excel spreadsheet is changed the linked table
gets updated but split tables remains unchanged. Is there
a way these split tables to get updated automatically.
Thanks mates in advance for your help.
The table analyzer is designed for splitting a non-normalised table into
two or more new, normalised tables. This is a one-time process: the new
tables are entirely separate from the old one. T...display changing label caption on form as sub runs w/o screen flic
let's say i have this routine
label1.caption = "Starting ... "
label1.caption = "Getting there ... "
label1.caption = "Finished! ... "
on my form, i have label1 right in the middle
what happens is sometimes the message will change, and then sometimes it
wont, or it will show the first one, skip the second and jump to the third
etc etc etc
so it is inconsistent.
is there a way to make sure the label caption displays consistently, on
time, wh...Excel Continuous Running Total
I posted a message earlier and have received a partial solution.
I want to keep track of how much stock prices go up or down with a running
total of how much they go up or down over several days until the direction
For example, if price go up 10 on Mon, 20 on Tues, 30 on Thurs and down 10
on Fri I want my running total column to show a positive number of 60 and
then a red number of 10 and continue adding the amount of the total of the
down days until the market shows an up day.
The formula I am now using total the first and second day but does not do a
running total count if t...A get change first operation on table 'GL_Account_MSTR'
My client has recently upgraded to vs10 and now gets the following error
when he scrolls using the scrolling keys in the Account Maintenance window.
'A get change first operation on table 'GL_Account_MSTR' is for an invalid
How can we fix this?
i have come across many 'get change operations' this works many times
I would check this first:
1. In SQL Management Studio or in Enterprise Manager, right-click the
company database, and then click Properties.
2. On the Options tab, click to clear the Single-user check box under...Excel Database/Pivot Table Issue
Hi! I'm struggling to find an optimal solution for my excel databs
My file consists of two tabs - "data" & "summary".
Summary tab has my attempt to group the project phases by timeline.
But I think pivot table would be a better solution. My problem wit
the pivot approach is I've 14 cloumns which make up different phases i
my timeline. I want those columns to be the "rows", in the pivot tabl
layout. But excel does not allow me to do that.
I would apprecaite some help..
I've attached my excel file..
Message posted from http:/...Selecting Rows in Pivot Table
I've created a simple Pivot table in excel 2000 which gets data from an
The final resulting pivot table has hundreds of rows. The user can uncheck
values to limit the rows but that will take hours if he only wants to see
data for a few rows (which is usual ). Is there a way the pivot table can
start with zero rows ( all row values unchecked ) and let the user select
rows by checking them?
The other option is to drop the row field on the page field but then the
table shows only one record at a time depending on what value is selected
from the page field?
I hope i've made my...What tables and database does the Knowledge Base use?
Hi, we are wanting to make Knowledge Basee articles available online
for customers. From what I understand we would have to setup something
manually to display SQL information on the website. So what I would
need to know is what fields and databases will we be using if we do
something like this?
"Admin Matt" <Admin.Matthew@gmail.com> wrote:
> Hi, we are wanting to make Knowledge Basee articles available online
> for customers. From what I understand we would have to setup something
...Money 2002 will not run
I had been using Money 2002 for approx. 3 yrs on my home pc (Dell Dim 2100,
XP Home Ed. w/SP2). Last year, it simply would not launch. No error message,
no splash screen, no app opening, no process listed in Task Manager. Just....
The only change that was made to the system since M2k2 last ran was
upgrading my a/v solution from Trend Micro PC-Cillin to TM Internet Security.
I have tried disabling every aspect of the Internet Security product, as well
as completely un-installing the app, and then attempting to run Money, but
the same thing (nothing) happens.
I was considerin...Using a pivot to calculate an average w/o 0's
I have been killing myself with this problem for 2 days now, and I giv
up. I can't solve this myself. It seems that Excel works differentl
each time I use it. This is my situation:
I have a .csv file w/ 20k records.
I have a pivot table report that reads the .csv as the source.
In the pivot, I need calculate the average for one of the columns i
The problem is that 90% of the records have a 0 as the value for tha
I dont want to average the 0's into the average.
When I take out the zeros, i get a #DIV/0 error.
I have successfully been able to make this calculation...Pivot table Data always showing up as "Count"
Hi guys first post here and tried searching for this but couldn't find
I have a pivot table and whenever I drag and drop in to the Data
portion of it, the pivot is always putting it in as a "count" and I am
always having to change it to "Sum". Is there a way to change the
default way that a pivot handles info droppped into the data box?
Thanks in advnace for your help.
qwopzxnm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=275...Re: Workflow just wont run automatically, i have to run them manually
Yes, but i realized what i was doing wrong. I assumed [bad idea] that if i create a case and hit Save & Close the first time, taht the rule will run. In order for the rule to run automatically, it has to be Save, once it saves it, then Save & Close.
Thanks for your reply.
Did you check the workflow monitor to see if the rules get triggered
correctly and complete sucessfully ?
Have a nice day,
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://...Outlook Still Running
I am running XP Pro with Office 2003 Pro and sometimes when I exit out of
Outlook, Outlook.exe and Winword.exe stay as processes still running. Does
anyone else have this problem and what can do to make sure this does not
Thanks for your help
Remove ABCD from Email address to reply <neil154ABCD@earthlink.net> wrote:
> I am running XP Pro with Office 2003 Pro and sometimes when I exit
> out of Outlook, Outlook.exe and Winword.exe stay as processes still
> running. Does anyone else have this problem and what can do to make
> sure this does not happ...Help on Pivot table
When i do pivot i get the data displayed as
Contractor Circle Count
X 1 10
Y 1 10
Z 1 10
I want to display as
Contractor Circle ...Pivot tables and macros
i currently use macros to change some downloaded sales information.
unfortunately, the volume always changes and I cannot use a macro for
creaqting a Pivot table. When i select cell A1 and hit pivot tabel it
automatically selcts the range. In my macro it will only select the actual
range i recorded. IS there a way to go around that?
You'll have to edit the macro to create a variable range (alt + F11 will
bring up the VB Editor). If, for example, your macro recorded the range as
"A1:D4200", you'll want to create a variable to capture the final row, th...Very strange problems while running Great Plains on workstations
I notice that a few workstations in an office I support are having
problems when they run Great Plains. Excel, Outlook, Word and
Dynamics.exe are showing in the Application event log as being Hanging
or Faulting. I also see Fault Bucket errors, but when I search online
I cannot find any information online.
Here is one of the Fault Bucket errors:
3:15:35 pm 28-Sep-06 Application Hang None 1001 N/A
Fault bucket 296734104.
Also, these workstations are experiencing problems printing PDF files.
Has anyone out there seen this behavior and if so, how can these
problems be fixed?
...Publisher 2000 will not run
I had problems with Publisher 98 not running which we=20
never did solve so I installed office 2000 to see if=20
Publisher 2000 would function. Same problem: The flash=20
screen pops up and then disappears. No program.
Microsoft=AE Publisher 2000 Version 6.0 has encountered a=20
problem and needs to close. We are sorry for the=20
Howard, hi again,
Have you tried opening Publisher in safe mode?
Publisher retains all printer information within its publications. If you can open
Publisher in safe mode, either regress or update your printer and video drivers.
Mary Sauer MS MV...Macro automatic run at open
Is there a simple way to have a macro automatically started when a workbook
Francesco, use the workbook open event, like this,
Private Sub Workbook_Open()
MsgBox "It Works!"
To put in this macro, from your workbook right-click the workbook's icon and
pick View Code. This icon is at the top-left of the spreadsheet this will
open the VBA editor to the thisworkbook module, then, paste the code in the
window that opens on the right hand side, press Alt and Q to close this
window and go back to your workbook, now this will run every time you ...