How do I insert Roman Numerals?New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <ckj@discussions.microsoft.com> wrote in message
news:6CF0C580-BA6E-463D-B4FD-E6A6FDD9E814@microsoft.com...
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
I
II
III
IV
V
VI
VII
VIII
IX
X
XI
etc etc.
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...
Insert triggerLooking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
file loads?
If trigger is the way to go, what is the syntax to create the after insert
trigger?
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...
inserting hrs and minutesI have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
--
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
--
Regards,
Peo Sjoblom
"-Brian-H- >" <<Brian-H-.110wgs@excelforum-nospam.com> wrote in message
news:Brian-H-.110wgs@excelforum-nospam.com...
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
>
>
> ...
Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnetre: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
**
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
**
Insert
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
***
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...
insert an interactive excel file into word web pageI'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
Any ideas?
...
Inserting Hyperlinks in a Protected SheetHi
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
3 Questions:
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...
Insert with a where conditionHi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
table.
INSERT INTO dbo.tblmnuGroupPerm
(
gId
,mtfID
,...
)
SELECT
@gID
,mtfID
,...
FROM dbo.locmnuTabFunction AS ltf
WHERE
ltf.mtfID NOT IN
(
SELECT gp.mtfID
FROM dbo.tblmnuGroupPerm AS gp
WHERE
gp.gId=@gID
AND gp.Deleted=0
)
Any ideas or recommendations appreciated :-)
Many thanks,
Jonathan
It's OK... <oops "redFace">I did not correctly se...
Saving pictures as trasparentHello!
Having problems when I'm having two pictures in my file. The first one is a
background, and the second one should be transparent.
How do I do that?
Thanks
--
- Lars
I would suggest the version of Publisher you are using does not support
transparency.
--
The US should free all those
illegally held prisoners they are
torturing, abusing and denying
human rights being held at
Guantanamo Bay.
We have the 2003 version of publisher.
Should the picture be created transparent before pub?
--
- Lars
"���MS�Publisher���" <donotknock@nobodyhome.com> wrote i...
InsertI want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...
Picture in OutlookI just tried to put an Enhanced Metafile picture into and outlook message
and when it was received, the picture had changed to a bitmap. Can someone
explain why this happens and what needs to be done to ensure it doesn't
happen again?
Thanks
...
How do you insert page numbers larger than 1000?I have my purchase orders set up as a Publisher document. When our
organization upgraded from Publisher 2000 to Publisher 2002, the new version
set parameters on the page numbers. This was one of those things that worked
just fine in the previous version... Does anyone know how to turn it off or
change it?
Hi mregen (mregen@discussions.microsoft.com),
in the newsgroups
you posted:
|| I have my purchase orders set up as a Publisher document. When our
|| organization upgraded from Publisher 2000 to Publisher 2002, the new
|| version set parameters on the page numbers. This was one of those...
how to insert data in a tableHi Exprets;
I am creating an access database in which I want to insert data in
already created table.
Kindly help.
Regards,
Vikky
Vikky <love.excel@gmail.com> wrote in news:1194124711.012302.269990
@e34g2000pro.googlegroups.com:
> Hi Exprets;
>
> I am creating an access database in which I want to insert data in
> already created table.
>
> Kindly help.
>
> Regards,
>
> Vikky
>
Data from where? Do you want to import it from excel, from a text
file, copy it from another table or type it in manually?
--
Bob Quintal
PA is y I've altere...
double picture filesHow can I find double picture files in MS Office picture database ?
...
insert downloads into power pointi downloaded an application called "BioDigital Simulator" of an animated
cleft lip/palate surgery and need it put into my power point presentation,
but can't fiugre out how to do so.... very frustrating...
What kind of file is this application? Is it a video? If so, what kind?
MPEG? AVI? MOV? Or is it an EXE file? Something else?
Which version of PPT are you using?
--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover...
Insert dataset to another databaseI'm posting this to this group also since it pertains to queries, primarily.
Hello,
Using VB6/ADO, I'm thinking I can create a recordset and insert it into
another table in a different Jet database, all within the execution of a
single query. But, I can't seem to get it to work, even in an experiment in
Access 2K.
My sql in Access 2K:
SELECT D.lorder as Ord, A.Lorder
FROM [;Database = C:\MyDocuments\Acc2K\Wrk.mdb].OrdersData as A INNER JOIN
[;Database = C:\Access\Work\Sales06.mdb].Detl1 as D On D.Lorder = a.lorder
WHERE ((D.fg)= 'MXX-NC' Or (D.fg)= 'MXX.NC')...
Insert a blank rowHi,
I need some help to insert a blank row in a range where column A has a
series of dates. There will be several of the same dates and I need to both
sort the dates and then insert the blank row at the end of each sequence. In
the blank row I need to total figures that will be in columns B through to
G.
Thanks,
Jim S
Hi Jim
maybe an easier solution
1. Sort your data (use 'Data - Sort', e.g., column A ascending)
2. Use 'Data - Subtotals' This will insert a row after each date and
calculate subtotals automatically for you
HTH
Frank
anon wrote:
> Hi,
> I need some...
How do I insert a letter into an existing word document?I am working on a large document that I need to add several letters that are
on our letterhead. If I cut and paste the letter, the letterhead header
becomes skewed. This is just one issue I'm having with the document! Also
need to know how to merge 3 separate documents together once I insert the
letters that I need! Help!
What do you mean by "skewed"?
To preserve the data from the header of the document, you will need to
insert it into a Section of its own separated from the rest of the document
by Next page Section breaks before and after it with the headers...
How do I insert backround into my picture inserts?
Could you please elaborate on your question, and give us details such as
your version of Publisher.
--
Brian Kvalheim
Microsoft Publisher MVP
http://www.publishermvps.com
This posting is provided "AS IS" with no warranties, and
confers no rights.
"TAMOS" <TAMOS@discussions.microsoft.com> wrote in message
news:A1B3ABEC-F208-4A23-B695-9C0EEFBF649F@microsoft.com...
>
How to Compose a Good Newsgroup Post
http://dts-l.org/goodpost.htm
How to Act Smart on Usenet
http://www.catb.org/~esr/faqs/smart-questions.html
Getting Your Post Noticed - and Answered
http:...
Inserting images into excel conditionallyI have a large product price list (1200 items) with one column for quantity.
I would like excel to import the appropriate image for a product once the
condition entered is that quantity is > 0. Is this possible? If so then
please help.
Thanks
Pav
One way
http://www.mcgimpsey.com/excel/lookuppics.html
can be adapted to your situation
--
Regards,
Peo Sjoblom
"Pav" <Pav@discussions.microsoft.com> wrote in message
news:37DC7373-14E6-4F11-9136-71DC3AD93CC2@microsoft.com...
> I have a large product price list (1200 items) with one column for
quantity.
> I would l...
How to create a member picture ID with text on both sides.I would like to know if anyone here knows how to go about creating a picture
ID, but also include text on the reverse side. I have heard you can create
many projects with Publisher or Word. I succeeded this with MGI Photosuite3,
the "Fun IDs" project but it does not print on the reverse side.
You can email me to JP-Graphics@juno.com
Do you have a duplex printer? Otherwise create a two page publication, print the
first page (current page) turn it over and print again. Keep in mind if "Bob's"
picture is on the left side of the card sheet on the front, "Bob...
How do I insert a reference to lookup and insert a nameHow do I insert a reference code in one column which will then look up a
reference table and then insert the name in the next column. eg if I type the
letter b in column 1 then the word 'bank' will appear in column 2. If I type
the letter i in column 1 then the word 'insurance' will appear in column 2
etc etc
look at VLOOKUP in Help.
--
HTH
Bob Phillips
"Jan K" <Jan K@discussions.microsoft.com> wrote in message
news:C6CDAC92-DB48-49A7-803F-BF494F5221AB@microsoft.com...
> How do I insert a reference code in one column which will then look up a
> r...
Unable to access My Documents, My Pictures, in my own profile!
*I can't access any thing uder my user profile such as My Documents and
My Pictures, it's a ADM profile with all rights. *
*Do I need to access it with main PC Adm Profile and reset the rights?*
[image: http://www.vistax64.com/attachment.php?attachmentid=17723]
--
Gumby22
Try looking in the Documents and Picture folders ie no"my".
Camper
"Gumby22" <guest@unknown-email.com> wrote in message
news:f20a816cac42d8f1949134cc462ee574@nntp-gateway.com...
>
> *I can't access any thing uder my user profile such as My Documents a...
Insert eps image into Publisher 2003Client created eps images in Illustrator. Said they have TIFF preview
available. When the images are inserted into Publisher, they only appear as
blank box. Rendered the document as a PDF and we can see the image but she
needs to see the image in Publisher in order to modify, resize, etc. When
inserting it, we get the converter window, but she needs it to stay in eps
format in Publisher. Are there any settings in Publisher to change to allow
the eps image to display in the Publisher document?
--
maryj
Are you using a post script printer?
Pieces of an EPS graphic may appear to be missi...
Triggers after InsertHi,
I'm having a temporary table in SQL Server 2005, which receives the data
from external Orace DB. The data from Oracle DB inserts the data once in a
month time.
How to create a trigger which calls the storedprocedures, after all the data
is get inserted to the temporary table, not for each row insertion.
On Sat, 12 Jun 2010 04:01:21 GMT, "Visha" <u60840@uwe> wrote:
>Hi,
> I'm having a temporary table in SQL Server 2005, which receives the data
>from external Orace DB. The data from Oracle DB inserts the data once in a
>month time.
>...
inserting a text into xml fileHi friends, I am new to csharp and XML :
fp=File.OpenText(server.mappath(".\\upload\\")+"test.txt");
string info=fp.readtoend();
string[] arinfo =new string[4];
char splitter = {'|','^'};
arinfo =info.split(splitter);
for(int x=0;x<arinfo.length;x++)
{
response.write(arinfo[x]+"<br>");
a=arinfo[x];
xmltextwriter xwriter=new
xmltextwriter("C:/XML/Data.xml",system.text.encoding.UTF8);
xwriter.writestartdocument(true);
xwriter.writestartelement("login");
xwriter.writeelementstring("usernam...