How to create a partition on an external USB drive?
Toshiba Tablet XP Home/Student with plenty of memory. I have the
program DriveImage XML. At one point it says to create a partition
somewhere for the image it's going to create. I have a 40G external
plug and play HD. I'd like to create a partition on it without
disturbing other files and folders I have on it. There's plenty of
free space. Various resources say use XP Disk Management to create
that partition. So when I go there it appears as they say but when
they say click on the free space choose the selection "Create new
partiton." I have right clicked ...user created shapes non printing
I started have a problem with vision 2002 that I have not noticed
before. When I create a new shape, by default, it assumes the
non-printing properly under FORMAT � BEHAVIOR. Also if I group a set
of "printing" shapes the group will become non-printing. Can I change
How are you creating the new shape? Also are you using layers in your
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert" <email@example.com> wrote in message
news:9ec427f7.0409231005.576...Formula Help (to many expresions)
Could one of you give me a hand with this...
I'm trying to put a formula in a spreadsheet that has too many
expressions in it. I understand there is a limit to the number of
equations that can be in a formula but there must be a way around the
Or maybe another way to write the formula?
What I am trying to say in the formula is that if...
If X is less than 09 then B1 = what's in cell C2
If X is less than 25 then B1 = what's in cell C3
If X is less than 51 then B1 = what's in cell C4
The expression I have written looks like this...
=IF(X<10,"N/A",IF(X<..."All users" "Programs" create/modify shortcut from app...
I've created two shortcuts into "Programs" folder for "All Users"
It lets me to get them available for all user.
Application running in "User" context needs to delete and re-create such
links but it fails due to an "access denied" ...
Settings correct permission to such links it starts working as well
I've created links using the IShellLink/IPersistFile sehll interfaces.
So, I actually need to have link under "programs" for "All Users" which
might be modified by application running in "Users"...How to create a connection point in Excel
When I group autoshapes the group itself does not have connection points. A
connector connects to one of the grouped shapes instead. So, the connector
beginconnecedshape (or endconnectedshape) property contains the name of the
contained shape and not the name of the group. Is there a way to create
connection points for a group? Alternatively, is it possible to change a
group into a single shape with connection points?
How do I make my VS.net 2003 software not depend on
Use static linking. I don't know where to set the option in VS7, but it used to be under
Code Generation where you selected the desired C runtime library to use. In VS6 we had a
choice between a dynamically-linked runtime and a statically-linked runtime. I've not had
to make this choice under VS7 so I'm not sure where, in their overly-clever and completely
gratuitous reimplementation of the user interface, this has been hidden.
On Sat, 21 Feb 2004 22:24:56 GMT, firstname.lastname@example.org wrote:
&g...Help with ShowFilter Macro
I'm trying to use this ShowFilter UDF written by Tom Ogilvy (see bottom of
post). It says to use...
....in a cell to show the criteria for Column B. For one thing, I don't
understand the cells B2 and B3 business. What is supposed to be in those
I would like this function to appear in the cell directly above or below the
Autofilter menu cell. How do I change the function if the Autofilter criteria
menu is in, cell A3, for example, and I want the criteria (this function) to
appear just above, in cell A2?
After trying all so...Help with automating file name
I have the following code that exports the below query to excell. I would
like the files name to include the month and date. How would I format this?
DoCmd.OutputTo acOutputQuery, "qryShopOrderSqFtShippedSummaryExport",_
mattc (at) saunatec [dot] com
Message posted via AccessMonster.com
> I would
> like the files name to include the month and date.
Uh, . . . the date _always_ includes the month, unless you're r...Createing Quote sometimes make Error: 80070057
Today I found some funny problems.
I create Quotes via the quote WebService from the CRM.
This normally works fine, but now I have some quotes, which will get me an
error, when I open it. This error is no normal error, I will get an
white/yellow Page with ASPX Errorpage:
Here the Message (sorry but I only have this error in German):
Serverfehler in der Anwendung '/'.
Beschreibung: Beim Ausf�hren der aktuellen Webanforderung ist ein
unverarbeiteter Fehler aufgetret...Please help with last formula for order form.
I am able to accomplish this with 1 column by the formulas below.
Cell H160 is the subtotal: =IF(SUM(H72:H111)>0,SUM(H72:H111),"")
Cell H166 the total: =IF(SUM(H160)>0,SUM((H160*H163)+H160),"")
Cell H163 is for Tax.
I am almost finished creating an order form. I would like to get the SUM
of 3 different columns that are separated. I am not able auto fill
strait down the column, because the information is separated in groups
with titles, and the cells are not identically sized.
I tried varations of this formula:
=IF(SUM(H72:H111)+(116:131)+(135:154)>0,SUM ((H72:H...Creating Control Grid
I would like to know as to how I should go about creating a control grid of
my very own. I just need a bit of push (suggestions).
Thanks In Advance
Where are you getting stuck?
Of course, if the grid isn't too large and most of the cells will have data,
then you could simply use a two-dimensional array.
For larger grids that will be sparsley populated, there are a couple of
algorithms to consider. A simple one is to create a one-dimensional array
that represents the rows (or columns), and have each item contain or
reference a linked list for all items in that row (complete...SmartList Restrictions help
I built a SmartList that is based on the Year-to-Date Transaction Open file,
and has the Account Master linked to it. I want to restrict it to accounts
that begin with 36, 38, or 2504. I tried adding a restriction that says
"Account Number:Account_Segment_Pool1 begins with 36 OR 38 OR 2504", but I
got no results when I did it that way. I also set up 3 separate
restrictions, but that didn't work either.
Is this possible? I can't find much information about how to write
restrictions in SL Builder.
...Conditional formatting help #4
My problem is that, that i want to ignore blank i mean i had set a
conditional formatting say
A B C D
24.9 25.9 25 25.8
22.6 23.4 22.5 23.3
If value in ColA is less than value in ColC, cell A1 is shaded blue OR
value in ColB is greater than value in ColD, cell B1 shaded blue.
I have done above formatting but my problem is that if i dont enter
anything in colC then also colA is shaded in blue similarly if i dont
enter any value in colD then also col B is shaded.I mean i want to
ignore the blank.I need , if col C is blank then the Col A must be
normal .& if col D is blank & i ent...help plz
my account has been inactive how to i reacctivate it?
What account and what does this have to do with Outlook?
"heather" <email@example.com> wrote in message
> my account has been inactive how to i reacctivate it?
...Help with queries
This is the first time after school that I am trying to use ms access at
work and i need ur help in creating a query.
Any help will be highly appreciated!!
Here is what I need...
I have relatively small ms acces database with about 1000
I have 3 colums
date ipaddress sitename
12/09 188.8.131.52 A
12/09 184.108.40.206 A
12/09 220.127.116.11 A
12/09 18.104.22.168 B
12/09 22.214.171.124 C
What i need is if an ipadress is recorded more t...Need help to choose loyalty program integrated with website
My name is Alex and I am working for franchise company using RMS
We are looking for loyalty program integrated with web store.
We have 12 franchisee stores using RMS and they are all conneted to
our HQ system in main office.
We want customers to earn point for each sales and redeem their points
only at our website. (not on off-line store)
Can anybody recommend best solution for our plan?
...eConnect or Web Servies to create RMTransaciton?
I am new to GP 9.0 development using web services and eConnect.
Can someone help me decide which technique I can use to do the following:
In GP 9.0, if I go to:
brings up the Receivables Transaction Entry screen, where I can fill in a
number, batchid, customerid, and some sales figures, etc.
I am using .NET and can use the eConnect API to create a taRMTransaction to
submit using eConnect. And it works fine, the transaction creates in GP.
Can I perform the same thing with any of the web methods available via the
GP 9 web services? I ca...Help And Advive For A Novice
HELP AND ADVICE FOR A NOVICE
This Is Not A Question About Using Excell But How To Download E -books
I Have Purchased 2 E-books (a)f1 Excell And (b) Financial Statements.
Encountered Difficulty In Downloading Because The Instructions Were Not
Very Clear For Novice And Message Flagged Up "zip File Corrupted"
I Have Utilised My Permitted Downloads. Therfore I Have Not In A
Position To Use The E-books
Joe Williams's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23...formula help #42
What formula would I use to search down a column find a name and report the
number in the next column, this would be multiple times, the numbers to be
The added number reported then to be multiplied by another number and then
to be subtracted from another fixed number in a specific cell.
Thanks in advance
You can sum the corresponding cells matched without having a dedicated
column of numbers.
"Boenerge" <Boenerge@discussions...Suggestions on how to create a database that will allow lookup of nonunique addresses for unique names
I am relatively new to access, though vaguely familiar with database
concepts and Access jargon (i.e., queries).
I need to do the following (see below) and I was hoping someone could
tell me what is the best way (at a high level) to do this in Access.
I have a large list of names and addresses thrown into a single flat
table. There are many duplicates in the file. Somehow, I need to
separate duplicate addresses from the file and place them in another
table so that I can link the list of unique names to the addresses
(i.e., a one to many relationship).
My end users will be using the d...HELP! Balloon Payments in Debt Reduction
I have had this problem for so long it is getting really
frustrating. When I put a debt into the debt reduction
plan, it always puts a balloon payment on my first
payment. Then, if I don't make that payment, it just
builds and builds and builds with each subsequent payment
I do make.
How do I get rid of this? I removed the debt from my
reduction plan the first time and that cleared it. But,
the moment I started paying on the debt, it returned.
Now, it's to the point that I can't get rid of it at
all. When I remove the debt from the plan, it will do
the same thing w...SUMPRODUCT help #7
My question is if I have 3 or 4 criteria that need to be met before
excel acknowledges the row and then once it does it will sum the
accepted rows and return that sum into another sheet.
Category Price Date Customer #
InorgStock $30.00 10/20/2005101643
Inorg CB $415.80 1/23/2006 109597
InorgStock $15.00 1/23/2006 101643
Matrix Mod $50.00 1/23/2006 101643
If I want excel to only add up the extended price for the columns that
met the criteria Customer Number=101643 and Category=inorgstock and
Category=Inorg CB and Category=Matrix Mod and Document Date is
>=10/20/05 but <...what product is best to create website
The company I work for is wanting to create a better website then the one
they have now. They are using Publisher right now, but many other web
browsers like Netscape or Firefox, are not opening up the page right. What
would be the best product to create this site? We are also wanting to
eventually add videos to the website. Any suggestions would be greatly
Normally I would suggest FrontPage but as of Office 2007, it will be a new
product and I have no experience with that. I intend to keep on using
FrontPage for a while. Until I am forced to upgrade.
JoAnn Paule...Help Required with Macro to Manipulate Data
I have a spreadsheet(s) with the following data on it (this is imported
from a text file)
A B C D
1 Branch Date Total
2 4501 030204 29
4 4501 030204 14
6 4502 030204 331
8 4502 030204 52
10 4503 030204 54
12 4503 030204 85
and what do you want to achieve :-)
"Alan T >" <<Alan.T.firstname.lastname@example.org> schrieb im
> I have a spreadsheet(s) with the following data on it (this is
...Print Label Wizard
Is there a way to print the aliase using the label wizard?