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...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 ...Error opening the Workflow Manager
Hi everybody !
I have this error when I attempt to open the Workflow manager (my
installation is new and I never opened the workflow Managerbefore):
"Workflow Manager cannot start. This could be because the workflow service
has not been started or is not configured correctly"
My configuration is:
- Windows 2003 SRV STD
- Exchange 2003
- SQL 2005 w/ reporting services 2005.
Apart from that, everything is working properly. I can login the system,
generate reports, manage entities, everything. I can even open the Workflow
Am'I missing something in the configuratio...Using Defined Names in Charts
I am using Office 2002.
I am trying to create a chart that has only one Series called Data. The
values for DATA is a name called SCROLL_DATA. The name has been defined
using the Insert-Name-Define action. The workbook is called Quality
Escapes.xls I have entered the following in the values box as I have
seen many instruction as follows
What am I doing wrong.
bobburg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22006
View this thread: http:/...USE of system.xml.xpath
When we need the xpath namespace as we can traverse the xml document using xmldocument object like using selectSingleNode or selectNodes methods. In system.xml.xpath namespace we have to use XPathNavigator , XPathExpression , XPathNodeIterator class to get the same result what we get it thru selectNodes ....and that too iterator can be traversed in forward direction only.
Please tell me the usage of system.xml.xpath other than performance.
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community...How do I use the "More Details" in a newsletter? #2
In Publisher 2003, you can create emails directly. The templates have a
place for a short intro to an article with a place to click to get the rest
of the article. How do I use that feature?
The "More Details" is no doubt an area where you add a hyperlink to a place where
folks can get more details.
Mary Sauer MSFT MVP
"Kevin" <Kevin@discussions.microsoft.com> wrote in message
news:8198CBA9-E37C-48F3...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...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?
...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] & """"...How can I get my ABC spellchecker to use UK English
I am preparing a large commercial brochure in the UK and the spellchecker
refuses to change from English US, which as we know is totally different to
English UK.. any ideas please. I have tried resetting it but I still get
told to change my 's' to 'z'!!
This based on the Help from Publisher 2000.
In the Help Answer Wizard look for "spell checker".
The "Tip" section of the answer is,
The English (U.S.) version of Microsoft Publisher 2000 comes with proofing
tools for English. To check spelling in other languages, use the Microsoft
Office 2000...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...Mail Merge using Access then save as PDF
In my organization, we send out letters by the thousands, ususally about 500
at a time, due to the time constraints of the current method.
Currently, we process the database, which places the letter contents in a
table called Archives. Then we open the Merge Template Word document, and
process the mail merge to print each individual letter. Next we have to save
each individual letter as a PDF file (Acrobat 8.2 Installed) for record
keeping and quality assurance. What we'd like to do is find a way that this
can all be done from within Access programmatically.
We upgraded from 1.2 to 3.0 a while ago. While doing some more customizing we
got errors that certain fields are used in workflows. However, those
workflows where deleted in the workflow manager. Unfortunately it looks like
the workflows are still active (paused) in the database (visible in workflow
monitor) and can not be cancelled to free up that field.
Hi When you did your upgrade, did you migrate your database from
server A to server B then do your upgrade? IS the CRM server name the
You can check the WFProcess table to see if there's anything active or
pause. Y...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...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...Using Catalog Merge
I'm using catalog merge to create a directory from an excel spreadsheet. The
phone numbers in the spreadsheet are using the special cell formatting for
phone numbers. is there a way to bring this formatting into publisher? Right
now the phone numbers are merging into the directory as 1234657890 instead of
Format the field in Excel as text...
Mary Sauer MSFT MVP
"Sharon" <email@example.com> wrote in message
news:947260D7-2280-4D5E-A946-A20969230BB8@mi...Locate a cell, based on a criteria, then use the 'Cell' command...
I am using a pivot table to configure some data. In the first column, the
pivot table of course displays only one instance of the text representing of
data group. What I need to do is determine in which cell a particular item
of text (i.e. the criteria) resides in. Once I can locate the cell where my
'criteria' text string resides, I can then use the CELL function to return
the row number.
My question is... what excel formula can I use to locate a cell in a single
column range, where the cell contains the text = "XYZ"
My eventual plan is to then use the following ...Where's a similar (useful) MS Word forum / newsgroup?
This newsgroup contains a vibrant and active discussion on MS Outlook,
with frequent replies from Outlook MVPs, expert users, etc. Although
I've found the microsoft.public.word newsgroup, it seems to be pretty
"dead," without much in the way of meaningful contributions. Is there
another newsgroup that addresses MS Word issues, which has more
activity? Or some other good reference source? I've tried MS's pages
(support.microsoft.com) and lots of Google searches ... but cannot
find help for the specific question I have (which I posted in
microsoft.public.word, but won&...best database to use for multiple attendence at meetings
I need a database which lists a group attending meeteings weekly for 2 years
and the date on which they attended alsoif they were overnight or day only
Access will work fine.
> I need a database which lists a group attending meeteings weekly for 2 years
> and the date on which they attended alsoif they were overnight or day only
> thank you.
You've stated your need. Are we to assume that you expect "someone" to
donate that database to you? Or do you want a template...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...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
...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...I can access any mailbox using OWA 2003
Exchange Server 2003
By using OWA I can open anyones mailbox.
if I enter http://server/user1 in IE i can see user1's mailbox
if I enter http://server/user2 i see user2's mailbox.
what security setting must i change so that only the logged in user can see
his or her own mailbox.
goto Exchange System Manager, servers, server_name,
protocols, http, exchange virtual server. goto properties
of exchange, click on acess tab, check basic
authentication and intehrated windows authentication.
Now, only if someone can answer the question I posted this
>...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://...Using forms in a shared powerpoint
I have a feedback form in a Powerpoint which stores the inputted data in a
text file. It works perfectly and does what I want it to. EXCEPT I want to
use the same form with a group of users and whenever I try this an error
occurs. When they press Submit when someone else has it open a run-time error
Does anyone know if I can get around this or should just give up!
This is the kind of thing I am doing:
Maybe try using FreeFile instead od #1? Not sure that even then you can have
it open on more that one PC at a ...