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" <email@example.com> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
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"...Not plot a data series in a chart but still display in data table
MS Excel 2007
I've somehow managed to display only two data series on my line chart. They
still display in the data table. How did this happen? More importantly, how
do I reverse it. I don't want to recreate chart.
I see the data series not plotted on chart in the Chart Elements and when I
select the series, the source data is highlighted; it's in the data table.
How do I make it visible?
HAve you perhaps simply formatted the data series as "no line, no marker"?
If so, you can format series, add some color.
Looking 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
If trigger is the way to go, what is the syntax to create the after insert
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.
-...Automatioc spill over data to a new Excel sheet from Xml source?
I have an XML source file with data for more than 256 columns. Since one
sheet can contain a max of 256 cols, Is there a way to make Excel, create an
additional sheet to keep the excess data? Preferrably using Xml map /
...How do I get only the data I want to be shown?
I have approximately 2000 rows of data all with strange data in it. Each row
starts with positions of stars in sexagesimal format. I want to filter
through these so that I only have the ones I want (approx. 600), followed by
the data in the row that corresponds to the position. I have the list of the
ones I want in a seperate column (i.e. there positions). How do I get them?
I hope this makes sense. Thanks!
Two approaches come to mind.
1) Use an advanced filter. Click in the larger table and select Data >
Filter > Advanced Filter. The 'database' should be the larger t...How to retrieve data which contain "/" in it
I try to pull a data from access with contain a speacial character "/" in it
but what i get is it not return a single data, so how do i wanna retrieve it?
below is statement I use it but it return nothing.
SELECT LDDATA.COR, LDDATA.CON, LDDATA.PCODE, LDDATA.QTY, LDDATA.BOXNO,
LDDATA.CASENO, LDDATA.RSNOS, LDDATA.RSNOE, LDDATA.NOFRS
FROM LDDATA WHERE (((LDDATA.COR)="A11/LC/000002/11/06")) ORDER BY
On Tue, 22 May 2007 21:53:02 -0700, osmanar
>I try to pull a data from access with...How do I prevent duplicate entry of a sku in a data table?
I want to keep folks from entering the same sku into a table (i.e. like data
validation does for other parameters).
Assume that you want to restrict the users from typing the duplicate values
in A Column.
Place the cursor in A1 cell and press Cntrl+Spacebar which will selecte the
A Column. Keep in mind that the active cell should be A1 cell. (Active cell
will have a white background after selection also)
Data >>Validation>>Settings>>Validation Criteria>>Allow>>Custom>> and in
Formula paste this =COUNTIF(A:A,A1)=1
I have a subform that shows a usual set of data such as:
The client wants me to be able to do the following:
I.e. merging data cells where they are the same value
Preferably with Name1 being centered across the products. Within a
straight access form I would use a group via crosstab however this is
an access adp on SQL Server.
Can anyone help?
In a report you can hide duplicates.
Build a little - Test a little
"BecksWatkinson@gmail.com...inserting hrs and minutes
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
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hfirstname.lastname@example.org> wrote in message
> 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 an interactive excel file into word web page
I'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.
...Updating a table
I have query that relates to a table and i want to be able to automatically
insert a comment into a range.
I.E Table column is called Report name. I want to open the query and have
it ask me the name of the report. When i enter it i want it to
auutomatically enter the name in the column so that all the other information
that i add afterweards is associated with the report. I then want this info
to save when i exit.
Can anybody help?
...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "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 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...Inserting Hyperlinks in a Protected Sheet
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.
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 condition
Hi, 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
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...showing data values on chart
in excel when mouse stand on chart,excel is showing the data values of that
point.how can to do this action in access?
Exactly the same. When you hover the mouse over a data point for a little
amount of time, a yellow bow should come up describing what's in your data
> in excel when mouse stand on chart,excel is showing the data values of that
> point.how can to do this action in access?
Where you insert chart?i insert chart on report,and i can't to see data value
on data point.
"Steve"...How to copy specific columns until end of data
I'm trying to import data from 2 workbooks into a summary (combination)
workbook. The trouble I'm having, is I want to import only certain
columns and have excel know to stop at the last row with data.
For example, from Workbook1 I want to import columns A, B, C, F, and G
(from Sheet2). I want it to copy up to the last row containing any
data--right now that's row 1046, but next month it could be row 1267.
In workbook2 I'm fine with it copying the CurrentRegion--all columns
are important. BUT, it doesn't include the title/category heads in the
first row (Salesperson, ...Calculation of weather data help
I have a data file (at http://www.weatherweb.net/cliall.dat) which contains
daily weather data from 1881 in the format:
dd,mm,yy,max temp,min temp, rainfall, sunshine, wind speed, wind gust,
What I would like to do is to calculate means for max, min, wind speed, wind
gust and pressure, and also total rainfall and sunshine for each month.
I would like the output in the format:
mm,yy,mean meax, mean min, total rain, total sunshine, mean wind, mean wind
gust, mean pressure
Can anyone give any assistance as to how I might do this in excel to create
a sngle file contain all th..."Lookup" data type
I´m using the deployment manager to create a new lookup filed chema but when
I click on the dropdown box to select the data type, the "lookup" data type
doesn´t appear. I´ve got the customization manual and that data type is
supposed to appear in the list. How can I add it?
Deployment Manager in CRM 1.* does not let you add a Lookup data type
"Talei" <Talei@discussions.microsoft.com> wrote in message
> I�m using the deployment manager to create a new lookup filed chema but
> I ...Insert
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...excel data to outlook
In my daily job, I need to flash some new data into my excel and use the
excel result to send out mails to report daily result. Is all numbers I need
to report in mails. Wonder if you can tell me if there is any tools to make
the data into text on my outllook.
I tried forming some string using:
="Today we booked "&Sheet1!A4&" MM vs."&Sheet1!A5&" MM expiry"
but when I copied this cells into my outlook, format is rare and pasted as
table / cells where I prefer to paste as text format ( which can be read by
boss with blackberry).
I asked ar...Editing data from 2 different tables
Could someone please explain to me if it is possible to edit data from 2
different tables that are being showed in the same form?
I created a form which shows fields from 2 different tables and I can not
edit the fields. I would like to be able to change/include data using my form.
The two tables need to be related in some manner and joined in a query for
the RecordSource of your form.
Elaine Parlato wrote:
>Could someone please explain to me if it is possible to edit data from 2
>different tables that are being showed in the same form?
>I cr...Exporting Data From Query Into Excel
How can I have this process automatically done to have the data from a query
after it's been ran to be exported into Excel in a specified location?
Ronald R. Dodge, Jr.
Master MOUS 2000
I have done some research on this method. While this method looks
promising, there's one limitation. It states one MUST leave the "Range"
argument as blank, when exporting data. The other thing I'm looking for,
putting data from a query into a worksheet, which the name of the worksheet
would be different from the name of the query. Based on the various things ...how to insert data in a table
I am creating an access database in which I want to insert data in
already created table.
Vikky <email@example.com> wrote in news:1194124711.012302.269990
> Hi Exprets;
> I am creating an access database in which I want to insert data in
> already created table.
> Kindly help.
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?
PA is y I've altere...Uploaded Checking acct data
Just successfully uploaded all 2004 (YTD) for main checking account.
That said, why does the calender not reflect the payments?
My calendar shows nothing just "Add New"
Is there some steps that I need to do or is the calendar information updated
only if I, step-by-step, pay bills in the system?
The data that you have uploaded will be in the account register, not in the
bills/deposits area which populates the calendar. To get it in the calendar,
you'll need to add it to the bills/deposits area. You can do this by either
entering it manually or by...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
Hi mregen (firstname.lastname@example.org),
in the newsgroups
|| 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...