A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 24 of 24
Search took 0.09 seconds.
Search: Posts made by: senthil
Forum: Page Layout June 4th, 2010, 04:47 PM Posted to microsoft.public.word.pagelayout
Replies: 7
Views: 3,310
Posted By senthil
Print Frist 2 pages in First Page Tray & others in other pages

Thanks Graham, this seems to be working expect i modified printing for rest
of pages like below, hope this is right.

sRestPages = "3-" & ActiveDocument.ActiveWindow.Panes(1).Pages.Count
...
Forum: Page Layout June 4th, 2010, 01:33 PM Posted to microsoft.public.word.pagelayout
Replies: 7
Views: 3,310
Posted By senthil
Print Frist 2 pages in First Page Tray & others in other pages

I couldn't find any specific code which says to print two pages in tray1 and
rest to tray2 in the given link.

OR

Do you mean to say that if First page tray is set to Tray1 and other pages
Tray to...
Forum: Page Layout June 4th, 2010, 01:11 PM Posted to microsoft.public.word.pagelayout
Replies: 7
Views: 3,310
Posted By senthil
Print Frist 2 pages in First Page Tray & others in other pages

So is it not possible if we have set First Page tray and other pages tray?
Can we not tweak to print first two pages in First Page tray?

Meanwhile i will go through the link you posted.

And...
Forum: Page Layout June 4th, 2010, 11:27 AM Posted to microsoft.public.word.pagelayout
Replies: 7
Views: 3,310
Posted By senthil
Print Frist 2 pages in First Page Tray & others in other pages tra

I use one tray for Headed Paper and another for plain paper.
Using macro i print first page of the document to the headed paper and
remaining pages in plain paper tray correctly.

Now to be more...
Forum: General Discussions May 27th, 2010, 10:42 PM Posted to microsoft.public.office.misc
Replies: 0
Views: 335
Posted By senthil
Help with MS word - TOC

Can someone help me with the following:
- Adding fields to document properties so that it can be easily retrieved
from share point
- Populating these document property fields in the document such...
Forum: General Discussion May 19th, 2010, 11:09 AM Posted to microsoft.public.excel.misc
Replies: 3
Views: 93
Posted By senthil
how do i merge the datas in 2 columns

i have a data address data in 3 columns like door no. in one, street no in
another & city name in another column. shall i get all these address in a
single column (consolidated)

Thanks
Forum: Tables November 30th, 2009, 04:43 PM Posted to microsoft.public.word.tables
Replies: 5
Views: 129
Posted By senthil
Problem converting tet to table

That worked! Thanks a lot :)

"Graham Mayor" wrote:

Select the text you want in columns then Page Layout Tab Columns - select
the number of columns.

--
...
Forum: Tables November 29th, 2009, 08:39 AM Posted to microsoft.public.word.tables
Replies: 5
Views: 129
Posted By senthil
Problem converting tet to table

Yes, exactly. I want newspaper style columns,
First column should be filled first, then the next, etc..
How can I do it?

- Senthil Kumar

"Suzanne S. Barnhill" wrote:

Perhaps what you actually...
Forum: Tables November 26th, 2009, 06:28 PM Posted to microsoft.public.word.tables
Replies: 5
Views: 129
Posted By senthil
Problem converting tet to table

Hi,

I am trying to convert text to table in Microsoft Word 2007. I'll explain my
problem with a small example.

Take the following list

Item1
Item2
Item3
Forum: Worksheet Functions December 5th, 2008, 02:21 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 57
Posted By senthil
Concatenate by checking a condition

Valko, I had to restart my m/c after the download installation. It works
pretty good.

Thank you.

"T. Valko" wrote:

Nothing built in to do this. There is a free add-in that has a function that...
Forum: Worksheet Functions December 5th, 2008, 01:52 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 57
Posted By senthil
Concatenate by checking a condition

Valko, Thanks for your help. I installed the add-in function that you have
suggested, I am getting the error message "#NAME?". I couldn't quite
understand what to do with array formula? Can you...
Forum: Worksheet Functions December 4th, 2008, 10:32 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 57
Posted By senthil
Concatenate by checking a condition

Hi,

I am trying to concatenate cells after checking the condition. For example

A B
1 0
1 A
...
Forum: Running & Setting Up Queries December 29th, 2007, 08:48 AM Posted to microsoft.public.access.queries
Replies: 2
Views: 72
Posted By senthil
Count with a condition

I have table called " aug_base " with the following fields
Bill_period,day_1,day_2,day_3,day_4,day_5,day_6 upto day_60

I want to take report bill_period wise count of day_1,day_2,day_3 upto...
Forum: Running & Setting Up Queries December 27th, 2007, 05:03 PM Posted to microsoft.public.access.queries
Replies: 8
Views: 77
Posted By senthil
Check boxes in forms to call a query

Hi John,

I am a begineer and do not know much on coding. Can you help me out in
detail on how to do it.

"John W. Vinson" wrote:

On Mon, 24 Dec 2007 10:30:00 -0800, Senthil
...
Forum: Running & Setting Up Queries December 27th, 2007, 05:01 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 88
Posted By senthil
Collating text files

Thanks john.

But i have a problem here. The text files are not 3...they are around 30
files and each time i do a link and change the file name is tedious. Any
other way out.

"John W. Vinson"...
Forum: Running & Setting Up Queries December 25th, 2007, 05:02 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 88
Posted By senthil
Collating text files

Hi,

There are 3 text files - text1.txt, text2.txt, text3.txt. Each of these
files have a records of 10 digits each.

Text1.txt Text2.txt Text3.txt
1234567890 ...
Forum: Running & Setting Up Queries December 25th, 2007, 07:26 AM Posted to microsoft.public.access.queries
Replies: 1
Views: 41
Posted By senthil
Export text with current date

hi,

I want to export a few queries to text files. I am current using "transfer
text" option through macros. If we provide the file name and the path the
files are exported to the path. How do we...
Forum: Running & Setting Up Queries December 25th, 2007, 07:05 AM Posted to microsoft.public.access.queries
Replies: 8
Views: 77
Posted By senthil
Check boxes in forms to call a query

Hi Klatuu,

I am a begineer and do not know much on coding. Can you help me out in
detail on how to create a multiselect list box and run the requirement.



"Klatuu" wrote:

I would not suggest...
Forum: Running & Setting Up Queries December 25th, 2007, 06:49 AM Posted to microsoft.public.access.queries
Replies: 8
Views: 77
Posted By senthil
Check boxes in forms to call a query

Hi tina,

I am just a beginner in access and absolutely not familiar with coding. Can
you guide me by giving me the complete code so that i can copy/paste and
execute the coding and learn.

"tina"...
Forum: Running & Setting Up Queries December 24th, 2007, 06:30 PM Posted to microsoft.public.access.queries
Replies: 8
Views: 77
Posted By senthil
Check boxes in forms to call a query

I have around 50 queries. These queries are run on a requirement basis.
For example, i have query1,query2,query3,query4,query5

If i select query1,query3 through a check box, the selected query...
Forum: Running & Setting Up Queries September 12th, 2007, 10:42 AM Posted to microsoft.public.access.queries
Replies: 1
Views: 36
Posted By senthil
How can we use sendobject to directly send a mail?

How can we use sendobject to directly send a mail through lotus notes without
prompting for a send option.
Forum: Running & Setting Up Queries September 12th, 2007, 10:38 AM Posted to microsoft.public.access.queries
Replies: 1
Views: 34
Posted By senthil
How can we convert a crosstab query to a table?

How can we convert the output of an crosstab query to a table.
Forum: General Discussion January 18th, 2007, 03:21 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 57
Posted By senthil
excel formula

What is the formula to be used in excel to convert the Number to text


Eg : 1250 = One Thousand Two hundred and Fifty only
Forum: General Discussion January 18th, 2007, 03:16 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 55
Posted By senthil
formula

how should i use vlookup & if condtion

Question
by using vlookup if result column contain Y, then if condition to be used
there. if result is N, then result should be 0
Showing results 1 to 24 of 24

 
Forum Jump

All times are GMT +1. The time now is 05:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.