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 ...Lowest entry in a column
Can anyone tell me how to automatically use the last/lowest entry in a
column? I don't want to sort the cells, or choose the Maximum or Minimum - I
just need to use the bottom entry in a column automatically in a formula
I'll create somewhere else on the spreadsheet.
It thought it would be in the functions list somewhere, but it has eluded
Suppose A is the column in question, use the following formula to refer to
the last cell:
"Astley" <firstname.lastname@example.org> wrote in message
ne...Auto fill and drop down lists
The fields are Rank and Rank Sort (I cant do this alpabetically as a the
ranks (Military) don't run in alphabetical order.
The idea is this:
The form (Pers Details Form) contains personal details Name, Number etc from
the Pers Details Table. There will be box where I can select the rank from a
dropdown list. The Rank details are contained in a seperate table (Rank
Table) containing a Rank and Rank Sort column. In the Pers Details Form I
can create a record, enter details but I want to have a drop down box to
choose the rank from. Once chosen I would like the rank to show (but ...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...Price list 02-23-06
Does anyone know how to default a quote to a particular price list, or can I
remove this mandatory field? Tks. Ian
Hi Ian, You could write a script at the OnLoad Event of the Quote Form.
var CRM_FORM_TYPE_CREATE = 1;
var CRM_FORM_TYPE_UPDATE = 2;
alert("This is a create form.");
//insert the PriceList GUID into the Price List look up field here.
Hope this helps.
Manisha Powar (Madhusudanan)
Microsoft Dynamics - CRM
This post...Module name in
Hi, when your are in the EXCEL code editor, you have on your left the
name of the modules.
I find anoying the fact of having to remember the module name or edit
one by one each modules to find for intense a piece of code as a
reference. Is there a better way to do it in that environment like
renaming the module with specific name?
You can rename the module.
Most of the people here probably group their macros into similar function
macros in different modules, and name the module accordingly. This makes it
much simpler to find.
You can also do a find, Ctrl-F, and set the ...Machine name
You can get all sort of information in INFO function.
How can i get the local machine name ?
Message posted from http://www.ExcelForum.com/
|| You can get all sort of information in INFO function.
|| How can i get the local machine name ?
|| Message posted from http://www.ExcelForum.com/
You need to use the GetComputerName API call in a VBA function.
Declare Function GetComputerName Lib "kernel32" _
Alias "GetComputerNameA" ..."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"...Names, Addresses In A Table...
I Am Putting Names And Addresses In A Table For A Directory I Am trying To Put Together, 6 Rows And 3 Columns. 18 Companies To A Page, I Will Have Approx. 300 Pages When Complete.
My Question Is: Is There Any Way To Make Them Go In Alphabetical order By Name Of Company?
I Am Very Greatful To Anyone Who May Be Able To Give Me Some Help. Thank You very Very Much.
PS: I Am New To This Kind Of Software And Would Like To Say To MS PUBLISHER...You Are Very RUDE!!
This is a multi-part message in MIME format.
charset="Utf...stacked column with total
I created a stacked column chart with 2 series. I'd like to show the total
value on top each bar. Right now, show value displays each value of
independently. For example, I have a bar showing 3 and 2 stacked but I would
like to show 5 (3+2) on the top bar.
I've seen on someone graph before. I can't recreate it. Pls help.
Microsoft MVP - Excel
"matelot" <firstname.lastname@example.org> ...Preventing Recipient Names from Showing
I have a long list of people I am addressing a message
to. I want the recipient to see that it is coming to
them, but not be able to see anyone else's name/address
that it's being sent to.
I've tried the BCC field but then even the recipient does
not see that it was sent to them. I'm afraid they will
think it is junk mail if they don't see it addresses to
for other options
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick...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?
...referencing to worksheet names in macro for each new worksheet inserted
I created a code to insert new worksheets and rename them according t
values on the new worksheet itself. Say in Cell D1, i have th
My question is when i want to refer to this worksheet in subsequen
coding, how should i code it?
How should i write the ???? for Sheets("????").select? Would creatin
the a variable to store the names help?
Thanks in advance
Message posted from http://www.ExcelForum.com
After inserting your new worksheet set it's name equal to a variable.
VWORKSHEET = ACTIVESHEET.NAME
This method ...outlook 2007 monthly calendar six column?
Just converted to Outlook 2007 from 2003, where I could print a monthly
calendar with 6 columns: Mon Tue Wed Th Fri Sat/Sun. This freed up some
width per column, b/c the weekend days were consolidated. Can't seem to do
this with '07. The columns are too skinny (even on landscape) and I can't
read appts. Advice? Thx
Try the calendar printing assistant or word template- see
http://slipstick.me/calprint for links.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
...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...Combo Columns
I've created a combo box on a form in Access using 2 columns. The first
column is hidden so the second column is the only one displayed in the combo
box. When I then use that combo as the source in a separate text box the
answered returned is the first column. Any idea how I get the second column
...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...Combine 2 rows if name is same in Column B & C on both
Combine 2 rows if name is same in Column B & C on both
2 spreadsheets - Sheet 1 is bigger with extra names in column B & C
Both - Column B & C Lastname Firstname - both sheets
Sheet 1 has data in Col. D & E
Sheet 2 has data in Col. F & G
Sheet 1 has extra names not in Sheet 2
If Sheet 1 B&C = Sheet 2 B&C ,
then add F&G columns from sheet 2 ,
behind D& E columns on sheet 1 , for the match of names in Column B &
On Nov 13, 12:50 pm, wk <kerns.wal...@epa.gov> wrote:
> Combine 2 rows if name...List box with available queries question
I have a list box control on a form and want the list box to display all the
queries within the database. The following code is what I have so far but it
does not work. Any help is appreciated.
SELECT [Name] FROM MSysObjects WHERE [TYPE] = 5 and LEFT([Name],1) <> "-"
ORDER BY [Name];
"Billy B" <BillyB@discussions.microsoft.com> wrote in message
>I have a list box control on a form and want the list box to display all
> queries within the database. The following code is what...Force command to run for each computer in txt file list of compute
I have a few hundred computers that haven't been defragged in years. I was
wondering if rather than doing it manually, if someone had a script where if
i just put all the computer names in a txt file, it would iterate through the
list and perform a "defrag c: -f" on them all from my workstation. The
workstations all have the same local administrator password, so the process
would be the same for each. I just dont know how to write scripts.
I know if i were going to do this manually from my computer I would run the
command below for each ComputerName
psexec ...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...Filtering a column to exclude any repeated entries.
I am working on a column that has the same entries 2 or more times. Is there
a way (copy-paste or other) to get only unique entries from this
column (that is to exclude repeated entries)?
Any help apprieciated,
If you go to Data/Filters/Advanced Filters there is a box
at the bottom left that you can tick to return unique
>I am working on a column that has the same entries 2 or
more times. Is there
>a way (copy-paste or other) to get only unique entries
>column (that is to exclude repeated...SBS VPN Oddity with Name Resolution
We host a number of intranet sites for employee use (not hosted on the SBS
box itself - they're on member servers). Some are published, most are not.
I've trained our laptop-using employees to use the "Connect to Small
Business Server" VPN connection to reach our intranet-only websites when
offsite. I haven't seen issues with users reaching the Internet-facing
sites even when users switch back and forth between connecting and
disconnecting the SBS VPN during a session.
My boss recently informed me that he couldn't reach one of our published
sites fr...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...compare two columns with different ranges in two worksheets
I need to compare two columns of data in two different worksheets and display
a third one.
Here it is an example:
-(worksheet1!A1:A10), (worksheet1!B1:B10) and (whorksheet2!C1:C25)
-this is my query, if C5 is already in (A1:A10) I want to display B5 in
I think it is tricky because you need to identity which row in the A1:A10 is
equal to C5 to display B5 and the range are different.
you could save my day
=if(isna(vlookup(C1, worksheet1!$A$1:$B$10, 2, 0)), "", vlookup(C1,
worksheet1!$A$1:$B$10, 2, 0))