Pivot Table Source Data
I have an existing Pivot Table that usually updates daily, albeit this
relies someone in the office refreshing the data. Anyway we seem to
have missed one days data and thought we would be clever and just
include the days missing data back into the source data. In effect we
are putting the 8th September data between the 7th and the 9th. However
no matter what we do the data from the 8th ends up as the last column
in the pivot table. Are we missing something really simple here or has
my brain turned to mush?
thanks for the help in advance.
P.S I also tried creating a dynamic range but ...Exchange question
I currently have Exchange 2000 on Windows 2000. I am getting ready to setup
a new box with Exchange 2003 Ent. on Windows Server 2003. Here are my
1) Does my Exchange server have to be in Native mode before I can upgrade?
2) If I change it to Native mode, will I need to reboot my server?
3) Do I need to reboot the server after I run the Forest and Domain Prep?
Any help will be greatly appreciated.
It's been *a while* since I upgraded to Ex2003, but I believe the answers
www.sir...ZIP codes beginning with 0
I'm having trouble getting ZIP codes beginning with 0 to
stick, even when specifying ZIP code in the format
category type. No matter what I do, the initial 0 always
Either pre-format your cells as TEXT, or enter a leading apostrophe before
entering the number with the leading 0........the apostrophe won't show, it
only forces TEXT formatting on that cell..........
Vaya con Dios,]
"Peter" <firstname.lastname@example.org> wrote in message
> I&...Question about Date validation
I'm working on a form for weekly data entry. I'd like to create a
date field where the user will enter the date the week ends (ie week
ending Friday, June 25th). Is there a way to write code so that
Access will check that the day the user inputs is a Friday (and if not
they will recieve an error message)?. I know how to program the
error message pop-up box, but I have no idea how to write code to
check if the date inputted is a Friday.
Any help would be greatly appreciated!
Use the WeekDay function
If WeekDay(Me.DateField) = 6 Then
En...Current Record Source
I have the following Function in a module and using on a toolbar. It works
well on the open form which the toolbar is assigned to. The current Record
Source of my form is qryAll. I want to use this Function on several other
forms each with a different Record Source. How do I go about using a
variable as the Record Source changes? I don't want to create a separate
toolbar for every form. Any help appreciated.
On Error GoTo QTagProduct_Err
Dim strWhere As String
Dim strMsg As String
strWhere = "...a question about XmlTextReader.ReadBase64()
Hi, I am new to xml, so if I ask something stupid or funny, pls don't laugh.
my problem is like this:
I have a data structure like this
// I wrote it to xml like this
// I want to read it out
MyData md = new MyData();
while(reader.M...CRM3.0 Question on Activity
I am using CRM3.0. I have the following case.
1. Create Campaign
2. Add contact to campaign list
3. Create Campaign activity - Phone call
4. Distribute activity
5. CRM User will make phone call
6. When contact is interest, CRM user will make a "Free Trail" for contact.
I am having troble in step 6.
So far as I know, I have two choices for "Free Trail".
A) Service Activity
If I choose to create a service activity, then I can not link up the service
activity with the campaign or phone call.
If I choose appointment, I can set "regarding"...Pvt Table Question
I am creating several pvt tables that will be updated often with new
data. I want to know if there is any function within a pvt table that
I can use to set up my pvt table so that only the top 10 data points
are automatically displayed. So for example, if i have pvt table set
up to show brand name and then accounts for each brand name and I
sorted on accounts descending and only wanted the pvt table to show the
top 10 brands that had the highest total accounts. Is this possible?
To show the top 10 values for a field - double-click the field heading,
click 'Advanced' ...Possible to call Linux machine from MFC?
I've been searching for some answers to this online but it's really outside
my experience, which is mostly with MFC.
I'm trying to figure out if it's possible to call an executable that resides
on a machine running linux and pass both input arguments and get return
values from the linux executable. ( The hardware we want to interact with
is only accessible from the linux machine.)
TIA for any help or pointers.
> I've been searching for some answers to this online but it's really
> my experience, which is mostly...RMS and Bar Coding
We are having a year end inventory count performed and need to send a file
with all bar codes. Can we delete old bar codes that have not been used for
awhile to shrink this file? Or can we send a numerical file with just the bar
codes that currently show inventory? If so, how is this done?
We own Store Operations 1.20
...How to get looping VBA code to respond to events on worksheet
I have some code of the form
do while not g_Paused
bunch of calls
where I'd like the variable g_Paused to be toggled by a button on the
worksheet. The only way I can seem to get the code to respond to the
button click is to use
do while not g_Paused
bunch of calls
But this is pretty slow and causes the sheet to flicker...is there a
I'm using buttons from the Control Toolbox
Does anyone know the tax codes Microsoft Money uses for
In microsoft.public.money, Brook wrote:
>Does anyone know the tax codes Microsoft Money uses for
Explain what you mean.
What I am looking for are the Tax Codes for Different
I.E. If I wanted to create a 401k tracking within my
Microsoft Money, I was trying to figure out how I need to
tax code my transaction so everything appears properly.
Hope this is clear.
>In microsoft.public.money, Brook wrote:
>>Does anyone...Add a new code macro
I have workbook that I am trying to use with a macro form another post on
this form. It inserts a new row with the formulas and contents of the
selected row. The problem is that it copies the row below the one selected,
and because of this, I can not make a copy of row 2 below the column headers.
Any ideas? Thanks. Here is the code:
'/=======Start of Code==========================/
'adds desired # of lines below the current line and
' copies the formulas to that/those lines
'added selection of more than one worksheet
' - Gary L. Brown
...Copy and Paste question
I have a macro that copies and pastes a large amount of data. After it has
run I get the question:
" There is a large amount of information on the clipboard. Do you want to
Could someone please tell me how I can avoid this question being asked as I
never wish to keep the data?
Insert this line after the pasting is done, it will clear the clipboard:
Application.CutCopyMode = False
"Richard" <email@example.com> skrev i melding
> I have a macro that copies and pastes a l...Using Code instead of Criteria
In my query builder, I'm getting the message:
"The string returned by the builder is too long. The result will be
I think I understand why, as I am using a form to specify a large
number of options for the report.
Can I use VB to specify these criteria instead of the query builder?
Examples in query builder:
If [Forms]![boxSeatsMailings]![PW] Criteria =1 and (PFDirect>0 or
PFBulk>0 or PIDirect>0) then select record.
If [Forms]![boxSeatsMailings]![PW] Criteria =2 and (PFDirect>0 or
PFBulk>0 or PIDirect>0) then select record.
As ind...Question about frontend backend config
We have two E2K3 boxes, both with E2K3/sp1 running on W2K3/sp1.
At first we just had one, but were continually running out of disk
space (Ent. vers.), so I re-imaged a system with a great deal more
space and installed E2K3/sp1 on it, and moved some, but not all of the
mailboxes on it. My plans are to use the old server (svr1) as a FE,
then use the new one(svr2) as a BE. I have not checked the FE box on
svr1 yet. Also, we have configured OWA to run on svr1, and it worked
until I started moving mailboxes.
Here are my questions:
- I have several Mac clients using Entourage, configured to co...Formula question 03-03-10
I am trying to complete the following.
In s141 i have a drop list with 'yes' and 'no' as possiblities.
In x141 i have a drop list with 3 possible choices, .02 , .04 , or .08
g141 is the originating cell
p159 is the answer cell.
if s141 remains empty or has 'no' chosen from the drop list i need p159 to
remain blank, however if 'yes' is in s141 then i need the answer from g141
multiplied by .02 or .04 or .08 (which ever one is chosen from the drop list
in x141) to be displayed in p159.
Can anybody help?
Thanks in advance.
Scoob...Combine MFC with non-MFC files?
I met a problem... When I try to use a non-MFC cpp file into my MFC
project, I remove the "Use precompiled header" setting to avoid include
stdafx.h. All files compiled ok. But when linking, it returned some error
uafxcwd.lib(afxmem.obj) : error LNK2005: "void * __cdecl operator
new(unsigned int)" (??2@YAPAXI@Z) already defined in libcpmtd.lib(newop.obj)
uafxcwd.lib(afxmem.obj) : error LNK2005: "void __cdecl operator delete(void
*)" (??3@YAXPAX@Z) already defined in LIBCMTD.lib(dbgdel.obj)
uafxcwd.lib(afxmem.obj) : error LNK2005: "...Newb question: How did my Form_.... Access Class Objects get crea
I have an access database that originally was created in office 2003 access.
I am not in 2007 Access. When I go into the IDE, I can see, under Microsoft
Office Access Class Objects, a set of what appears to be modules named:
- Form_form abc
- Form_form xyz
Each of these corresponds to an actual form I have created, and includes
Private Sub RefreshAssetTable()
Private Sub Command4_Click()
by default. Now, my question: How did this class "modules" (and I know
that is the wrong term) get created? I &...New to Visio-Hyperlink Question
I have created a flowchart in Visio 2000. I put in a hyperlink to another
flowchart. When I view my flowchart in full-screen view I click on the
hyperlink for the other flowchart and it opens in Actual Size mode w/ all
the toolbars open. I would like for it to remain in full-screen mode for the
flowchart I open when I click on the hyperlink. Is this possible?
Thanks in Advance,
...COM communicate with managed code(.NET)
When I have a communication from COM to managed code(.NET) a type
library(TLB) is necessary in between to handle the communication from COM to
I tried to use Red Gats's reflector to look into the type library that have
extension tlb but it's not possible.
So why is it not possible ?
"Tony Johansson" <firstname.lastname@example.org> wrote in message
> I tried to use Red Gats's reflector to look into the type library that
> have extension tlb but it's not possible.
...Re: o many mails in our out queue with out source Address
My exchange server is is having all the setting as you said still i am
getting these messages.
Recently i have removed few user because they left the oraganasiton, and
they use to get so many Junk-E-mails do u think because of these e-mail's
coming. pls if u have any ide pls let me know.
If you just want to delete those message, you can select them in "Queues"
tab inside "Internet Mail service" properties and click "Delete" button. You
can consider going to "Internet Mail" tab inside IMC and click Advanced
but...MFC in DLL
I want to add MFC objects (CString) to DLL project.
#include <Afx.h> to stdafx.h file.
I get the message "fatal error C1189: #error : WINDOWS.H
already included. MFC apps must not #include
I tried to add:
#undef _WINDOWS_ before #include <Afx.h>
Than I had linking problems.
I added: /FORCE:MULTIPLE to Linker->Command line
DLL project was successfully compiled.
This DLL is run successfully by snmp.exe
But It throws exception, when I close it.
I think, that my solution was incorrect.
How do I solve this problem?!?
"Max V...Re: Front-end question
If i have 2 front-end and one crash, the other will function properly? or i
must modify something? i must change the server (on clients) where all
"Mark Arnold [MVP]" <email@example.com> wrote in message
> "MMC" <firstname.lastname@example.org> wrote:
> >I don't understand very well, how FE server function....
> >Just download "Using Exchange 2000 Server and Exchange Server 2003
> >Servers"but i don't understand how FE and BE comunicate in a multiple
server...Outlook 2002 backup question...please help!
I am having a problem with windows which may require me to reformat. I
cannot get into outlook (2002) via windows, but I can access files from dos.
Can someone please tell me where the data files for outlook 2002 are stored,
and which ones I'd need to copy?
Thanks in advance for any help.
See if this info helps:
"Jim" <email@example.com> wrote in message
> Hi all,
> I am having a problem with windows which may require me to reformat. I