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.60 seconds.
Search: Posts made by: K[_4_]
Forum: Database Design May 28th, 2010, 09:29 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 0
Views: 604
Posted By K[_4_]
Export Table Records to txt file

Hi all, I have Table "T_Data" in my database. In "T_Data" I have
220000 records. I need to export them into txt files. I need some
kind of macro which should export chunk of 60000 records into...
Forum: Database Design May 25th, 2010, 03:41 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 721
Posted By K[_4_]
How to add record in Subform which is in another Subform

Hi all, I have Subform "SubA" on another Subform "SubB". And "SubB"
is on Form called "Main". On "SubB" I have button called "Add New
Record" and I got macro (see below) on this button's click...
Forum: Using Forms May 25th, 2010, 03:41 PM Posted to microsoft.public.access.forms
Replies: 0
Views: 557
Posted By K[_4_]
How to add record in Subform which is in another Subform

Hi all, I have Subform "SubA" on another Subform "SubB". And "SubB"
is on Form called "Main". On "SubB" I have button called "Add New
Record" and I got macro (see below) on this button's click...
Forum: Database Design May 18th, 2010, 09:08 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 675
Posted By K[_4_]
How to change existing table record value by VBA and How to add newrecord in existing table by VBA

Hi all, I got table in my database with name "tbldata" and i have two
fields in that table with the name "Ticket_No" and "Amount". In
"Ticket_No" filed column i have value "SD001" and in same row...
Forum: Using Forms May 16th, 2010, 09:54 AM Posted to microsoft.public.access.forms
Replies: 1
Views: 547
Posted By K[_4_]
Filter Subform

Hi all, I have table in subform control which i have put on a Form
call "Main Form". Table name is "Data" and Subform name is "Data
Subform". On the Form "Main Form" just above from subform control...
Forum: Using Forms May 14th, 2010, 11:22 AM Posted to microsoft.public.access.forms
Replies: 1
Views: 610
Posted By K[_4_]
Filter Table in Subform Control according to TextBox control value

Hi all, I have put Subform control on a Form1 and in Source Object of
that Subform I selected Table1 from drop down list. I also got Text
box control on Form1. In the first column of the Table1...
Forum: General Discussion April 22nd, 2010, 10:22 AM Posted to microsoft.public.excel.misc
Replies: 6
Views: 366
Posted By K[_4_]
Match formula to match values in multiple columns

On Apr 21, 4:53*pm, Dave Peterson wrote:
I'd just insert the formula into the macro:

Dim wks as worksheet
dim LastRow as long

set wks =...
Forum: General Discussion April 21st, 2010, 02:01 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 366
Posted By K[_4_]
Match formula to match values in multiple columns

Thanks lot Dave Peterson. Your formula works. What i was trying to
achive that i got data in three columns like see below

K L M.....col
XX YY GG
SS TT NN
RR VV AA
etc...

then i have data in...
Forum: General Discussion April 21st, 2010, 12:25 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 366
Posted By K[_4_]
Match formula to match values in multiple columns

Hi all, does any friend know that how can I make below formula work
MATCH(A2,$K$2:$M$30,0)
Forum: Using Forms April 11th, 2010, 02:19 PM Posted to microsoft.public.access.forms
Replies: 0
Views: 85
Posted By K[_4_]
Go Through Records by ScrollBar Control

Hi all, I am tring to give freez column effect like excel in
continuous form. To do that i have created two continuous forms with
name "SubA" and "SubB". I made these forms for read only. Then...
Forum: Using Forms March 30th, 2010, 09:54 AM Posted to microsoft.public.access.forms
Replies: 1
Views: 156
Posted By K[_4_]
Continues Subforms Scrolling

Hi all, I have to continuse subforms visible on Main Form. The two
subform names are "SubA" & "SubB". I need some code or way that when
I scroll on one Subform then other Subform should also get...
Forum: General Discussion February 28th, 2010, 10:03 AM Posted to microsoft.public.excel.misc
Replies: 7
Views: 100
Posted By K[_4_]
Formula needed to SUM and COUNT in specific way

you know stefi lot of people told me about pressing YES button but
believe me i post my questions and answers in google discussion groups
and i never seen this YES button anywhere. Can you please...
Forum: General Discussion February 23rd, 2010, 11:35 AM Posted to microsoft.public.excel.misc
Replies: 7
Views: 100
Posted By K[_4_]
Formula needed to SUM and COUNT in specific way

On Feb 23, 11:23*am, Andrew Taylor wrote:
You need SUMIF() and COUNTIF()

In cell B2 of Sheet2: =SUMIF(Sheet1!$A$2:$A$100,A2,Sheet1!$B$2:$B$100)
In cell C2 of...
Forum: General Discussion February 23rd, 2010, 10:44 AM Posted to microsoft.public.excel.misc
Replies: 7
Views: 100
Posted By K[_4_]
Formula needed to SUM and COUNT in specific way

Hi all, I have data in Sheet1 and Sheet2 as shown below

Sheet1
A B-----col
Data Amount----headings
XX 2
YY 4
SS 5
XX 9
GG 8
Forum: General Discussion December 18th, 2009, 09:27 AM Posted to microsoft.public.access
Replies: 1
Views: 80
Posted By K[_4_]
Change one table link by vba

Hi all, I got macro below which changes the link of all linked tables
in access. How can I ammend it to change only one table link with the
name "Summary". Please can any friend can help

Public...
Forum: General Discussion May 18th, 2009, 03:48 PM Posted to microsoft.public.excel.misc
Replies: 0
Views: 130
Posted By K[_4_]
Insert\Charts section is not working in excel

Hi all, I am using excel 2007. I have one excel file in which I had
few graphs. I deleted all the graphs and charts as I wanted to create
new one. Since I deleted all the graphs and charts, I am...
Forum: General Discussion March 23rd, 2009, 10:11 AM Posted to microsoft.public.excel.misc
Replies: 1
Views: 74
Posted By K[_4_]
Minus Dates

I have dates in Range("A2:A20") like see below
01/04/2009
05/04/2009
06/04/2009
10/04/2009
11/05/2009
etc………
And again I got date in cell B2 and in cell C2 and I want formula in
cell D2 which should...
Forum: General Discussion January 27th, 2009, 03:43 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 100
Posted By K[_4_]
Formula Needed : Sum on Conditions

On Jan 27, 3:08*pm, Pete_UK wrote:
Put this in D1:

=SUMPRODUCT((A1:C7="FTB")*(A2:C8="USA"),(A3:C9))

and it will return 209.

Change it to STX and UAE and you get...
Forum: General Discussion January 27th, 2009, 02:58 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 100
Posted By K[_4_]
Formula Needed : Sum on Conditions

Row A B C…….columns
1 FTB YRT STX
2 USA CAN UAE
3 33 66 33
4 STX FTB YRT
5 UAE USA CAN
6 44 88 69
7 YRT ...
Forum: General Discussion January 12th, 2009, 12:14 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 69
Posted By K[_4_]
Formula to match words

On Jan 12, 11:46*am, "Arvi Laanemets" wrote:
Hi

=IF(LEN(SUBSTITUTE($B1;$E1;""))=LEN($B1);"";A1)

Arvi Laanemets

"K" wrote in message

...
Forum: General Discussion January 12th, 2009, 11:26 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 69
Posted By K[_4_]
Formula to match words

Hi all, I have data in column A and B like (see below)

A B------columns
BB School Suzi dd coroc film
CC Tony MR Kent stated Society
DD Chandeliers Fil...
Forum: General Discussion January 10th, 2009, 05:35 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 72
Posted By K[_4_]
Count Text Characters in cell

Hi all, I know that if you put formula "=LEN(A1)" in cell B1, it will
show the result of numbers of text characters been input in cell A1.
My question is that the result in cell B1 will appear only...
Forum: General Discussion February 8th, 2008, 12:13 PM Posted to microsoft.public.outlook.general
Replies: 1
Views: 77
Posted By K[_4_]
PLEASE HELP FOR OUTLOOK 2007

Hi , is there way to put out of office automatically on in any day of
week. As i keep forgetting putting my out of office on and i want it
to be turn on automatically on every thursday. Please if...
Forum: Setup, Installing & Configuration February 8th, 2008, 12:10 PM Posted to microsoft.public.office.setup
Replies: 4
Views: 111
Posted By K[_4_]
OUT OF OFFICE IN OUTLOOK 2007

Hi , is there way to put out of office automatically on in any day of
week. As i keep forgetting putting my out of office on and i want it
to be turn on automatically on every thursday. Please if...
Showing results 1 to 24 of 24

 
Forum Jump

All times are GMT +1. The time now is 11:49 PM.


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