Is there a way in E2K7 to make a particular message always send a message out
in plain text format? Is that just an Outlook setting?
I have some data that I graph.
Column A has a date [has data in 12 rows]
Column B has a data entry (number) [has data in 1st 6 rows]
Column C has a data entry (number) [has data in 1 st 6 rows]
Column D has a formula that calculates a % on column B & C [formulas in 12
The graph range I have covers the whole 12 rows but it seems to read the
formulas in col D and plots every row
Is there something I can add to my formula that stops the graph from
plotting it unless there has been an answer returned in it?
Formula I have is : =IF(B5+C5<1,"",(B5-C5)/B5)
I was wondering if someone could tell me how to implement a couple of
threads. I have an MFC application which launches a Command line
application using 4 different commandline arguments. This works fine using
CreateProcess, but I also want to update a progress bar to the amount of how
long the command line application stays active. I created a thread to
update the progress bar and it works, but I can't figure out how to update
the progress bar at the same time that the exernal process is active. The
program always waits until the process is complete before updating the
progres...Pivot Table Help #3
I have a lot of data that I am trying to analyze with a pivot table and am
not sure how to go about it.
(2) Store #
(3) 2003 Score - these are #s or text ("incomplete")
(4) 2004 Score - these are #s or text ("incomplete")
For each district, I am trying to find out 3 things:
(1) % of stores incomplete
(2) Average score for 2003 & 2004 - I've got this one working properly
(3) % change between 2003 & 2004
I can successfully analyze the data in a spreadsheet but there is too much
to go through and thought a pivot table was the way to ...Registry question
I have an application that saves some configuration data
in the registry system (under
HKEY_CURRENT_USER\MyApp\ConfData) of the currently logged
on user. This way, every user who runs this app will have
his own configuration data.
When a user runs for the first time this app, the 'MyApp'
registry key will be created along with all its subkeys.
Now suppose we have 3 users and all of them have already
used the app. We will then have the 'MyApp' subtree
created for these 3 users.
What I want to know is that when the PC admin wants to
uninstall the app, how...Subtract colums in pivot table
I have a pivot table that has the following characteristics (Excel 2007):
-rows (down the left) are values: "# Employees", "Total Pay"
-Columns (across top) are Dates
I want to calculate the difference between different date columns.
5/23/2010 5/16/2010 5/24/2009 Total
# Emp 10 15 5 30
Pay 1000 15000 500 16500
5/23/2010 5/16/2010 5/24/2009 Total Vs. Last Wk % Change Vs. Last Yr % Change
# Emp 10 15 5 30 -5 -33% 5 33%
Pay 1000 5000 250 6250 -4000 -80% 750 15%
Can anyone tell me how to cre...Question about Application behaviour,...
i have a simple MFC Application, that shows me the System Memory Usage.
But after a while the Applications GDI Objects Count grows to something
about >8.000 GDI Objects and its Virtual Memory (not much but step by step
in less than 5 Minutes. I can see with ProcessExplorer that the application
a high count of page faults. I cant figure out why! The System then starts
slowly. The Timer invokes every seconds the member function with the code
following this text, sets the Position on a progress bar control and raws a
text on the surface of the prog...HELP with Office 2004 not loading after installing Adobe Acrobat 7.
Word, Excel and Powerpoint won�t launch anymore after installing Adobe
I checked on office/startup and the three folders are empty.
All I get is window telling me that app couldn�t launch.. Error
Is there a way to fix this? I don�t want to reinstall OSX. I have
uninstalled and reinstalled Office several times to no avail.
Entourage launches fine.
There are troubleshooting techniques linked from this page, work through
see General Troubleshooting and Troubleshooting for Office 2004
If they get to the splash sc...Defrag question #3
I have a windows 2000 server that's a file/print server and Exchange 2000
also installed and running on the same box. I was wondering what is the best
way if I want to run defrag and scandisk on the disk drive? I guess I'm
asking because exchange is running on the box and I don't know if I run
defrag and scandisk will I run into problems or cause the database problems.
Thanks for your help.
In article <4D7A888F-B293-400C-A77C-DC379DDF4BDF@microsoft.com>,
> I have a windows 2000 server that's a file/print server and Ex...ADMT Tool Question
I'm trying to run this tool without success from a Windows 2003 native
domain to extract accounts from an NT4 domain. Is this possible?
Windows 2003 server
Domain: Windows 2003 native mode
Forest: Windows 2000
NT4 server sp6a
"bobs" <email@example.com> wrote in message
> I'm trying to run this tool without success from a Windows 2003 native
> domain to extract accounts from an NT4 domain. Is this possible?
> Window...Best book for learning MFC/VC 7.1 for developing rich GUI apps ?
I am a C/C++ developer of quite a few yesrs, although I am relatively
new to Windows (Unix background). I am about to begin work on a project
that would require me to develop several GUI rich frontend applications.
I would like to hear from developers ou there if there is a book they
would recommend, to help me hit the ground running - i.e. a book that is
NOT an introductory text on programming/C++ but rather one that dives
straight in and shows how to create front ends (possibly widgets etc) -
using the VC IDE, one that covers all I need to know about MFC to start
working on a re...2008 SBS questions... 07-04-10
I am trying to get a 2008 sbs running as efficiently as I can & was
wondering about a couple of things.
1) I know it wants to be the DHCP server on a network, but what about
for wireless clients? I have a wireless sonicwall TZ-170 for wireless
laptops to connect to. They really don't need network access, just
internet, so can I leave this running, as long as the addresses it
hands out aren't in my same network?
2) Although the bought an SBS, the customer is not & probably won't be
running exchange for a while. Can I remove exchange all together? I
really see no rea...Splitting a table into smaller tables
I'm trying to split firsttable into smaller tables based on values in
firsttable. no relationships need to be maintained.
1 green eggs
1 orange eggs
2 green eggs
3 brown ham
so that i end up with
1 green eggs
1 orange eggs
2 green eggs
etc. any suggestions?
>> any suggestions?
Don't do it.
Why would you need to split?
Build a little, test a little.
"joseph g" wrote:
> I'm trying to split firsttable into smaller tables based on values in
> firsttable. no relationships need to be maintai...Pull Data From Multiple Tables ????
I will have 4 tables name "TblCostomers","TblVendors","TblAccounts",
Now i have a for name "FrmDrVouchers" that has a table "TblDrVouchers" in
This form has two TxtBox Control name "TxtAccountNo" and "TxtAccountName"
If User enters a Account No., It pulls the Account Name from Any One of these
I can do this if I have only one table.
But tell me how can i do it while I have 4 tables for One Field of a table
Message posted via AccessMonster.com
http://...Multi-language support question
We have an MFC application that uses ADO, ATL components to communicate with
a SQL Server 2000 database.
Our application is currently English only and we are making the conversion
to support multiple languages. The text in the application is read in from
a table so translating the text itself won't be a big deal programmatically.
The text is loaded at log in and we can just autoswitch to the appropriate
data based upon who the user is. My concerns are with different character
sets, how the different languages impact the OS (how we set the character
set in the OS automatically)...DNS Question
I am working with a customer that has 2 Small Biz servers in the same
office. These are on 2 domains, but the same subnet. I am having trouble
getting mail to route between the 2 domains. Each is Small Biz server 2003.
Domain A has a public IP of 18.104.22.168 and an internal IP of
192.168.200.78. Domain B has a public IP of 22.214.171.124 and an internal IP
of 192.168.200.250. We are using a Netgear firewall and inbound and outbound
mail between each of these domains and the rest of the world works fine. They
just can't seem to talk to each other. I would think this woul...Renaming table in a dB
Is there a short way in which i can modify all references to a table after i rename it? Or would i have to open every query and form and manually change the table references?Thanksramesh Access doesn't provide a way to do this.There are commercial products that do, e.g.: http://www.speedferret.com/-- Allen Browne - Microsoft MVP. Perth, Western AustraliaTips for Access users - http://allenbrowne.com/tips.htmlReply to group, rather than allenbrowne at mvps dot org."Ramesh" <ramesh2020@gmaildotcom> wrote in messagenews:uGgN$EuZHHA.4000@TK2MSFTNGP02.phx.gbl...> Is the...How to substitute for a non-existing column in a joined table
Is there a simpler way than a UNION to return a default value of a joined
table for which a corresponding row does not exist?
The following example (not a working one, of course) illustrates what I'm
after. I'd like to return 'N/A' as c2name if there is no matching row in t2
WHEN NULL THEN 'N/A'
ELSE t2.name END) AS c2name,
LEFT JOIN t2 ON t2.t1pk = t1.pk
On 2010-04-21 21:05, bob wrote:
> Is there a simpler way than a UNION to return a default value of a joined
> table for which a ...Question re:clustered column w/3D visual effect
I have Excel 2003
Why wont the 3D chart allow you to drag it more open? There is a large open
area between the left side and the axis that looks jerky :)
In a plain clustered column chart you can click inside to make the frame
appear and drag it larger or smaller as you desire.
In the 3D, clicking only allows you to change the angles of the 3D box.
Am I missing something?
This should be a hint to avoid the 3D effects. 3D charts are inflexible,
but more important, the 3D effects mask the information in the chart.
Peltier Technical Services, Inc....Question about CRM and Great Plains Integration
Can I create invoice when I invoice a contract in CRM and then show the
record in the Great Plains ?
Thanks in advance
...Tying tables to forms
I have four connected tables that work well as table input but when I put
them in a form some of the fields will not let me make entries. Does this
happen because I am using the Id fields and subsequent data from the wrong
It sounds like you have created a non-updatable form.
One cautionary note first:
Don't tie your forms directly to the tables. Use queries instead. The
queries will act as a stop light for which data is written and when. If more
than one person tries to make a change to the same record at the same time,
you will run into problems.
From wha...Dummy series and data table
I have a chart that presents 2005, 2006, 2007 summary data as a column
chart and then 2007 by month as a line. To show the yearly data I have
a yearly category, after which I have individual months where the
yearly data is zero - sort of like a dummy series - because I only
have one value for them. The 2007 detailed data has zero in the yearly
column but all the individual values in the monthly columns. It worked
fine until I was asked to add a data table to the chart. Now, since it
has 2007 twice - once as the summarized for the year and the other as
all these individual months - some us...Check box question 04-23-07
I have a form with a check box used to indicate if a receipt is voided or
not. What I'm trying to do is go to a new record after the checkbox is
marked. I have the following code in place and it works. Kinda. The
problem is that if I then go back and UNCHECK the check box, it sends me to a
new record again.
Here's the code:
Private Sub Check43_AfterUpdate()
If Ckeck43 = Yes Then DoCmd.GoToRecord , , acNewRec
Thanks for any help!
The following works fine for me.
If Me.Check3 = True Then DoCmd.GoToRecord , , acNewRec
If Ckeck43 = True Then DoCmd.GoToRecor...CHtmlView question #3
Is there an easy way to get the source of the HTML document?
On MSDN online, there's a GetSource(CString& str) listed
but that's apparently not implemented in VC++ 6.0.
...A simple mail merge question
How do you change the return address on envelops printed
using mail merge?
I don't understand the question. The return address will be whatever you
tell it to be when you set up your merge document.
"Nina" <firstname.lastname@example.org> wrote in message
> How do you change the return address on envelops printed
> using mail merge?