Ah my table
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 11016 articles for 0.530 sec
I have no idea what Microsoft will do about it - I'm assuming they'll continue improving structured references, since it's new and hot. Strictly for formula auditing purposes, you could save a copy of the workbook, convert tables to range, ensure that formulas are accurate, and revert back to original with structured references. On Nov 19, 3:50 pm, TKS_Mark <TKSM...@discussions.microsoft     

Group: microsoft.public.excel.misc · Group Profile · Search for Ah my table in microsoft.public.excel.misc
Author: iliace
Date: Nov 19, 2007 13:58

I worry that referring to an A1-style reference will end up being butchered if I extend the table using the new handles that MS provides. It won't be as dynamic as before and could ruin my references. "iliace" wrote: Ah! Multiple tables - confirmed. It does work with GETPIVOTDATA() formulas, or using a non-structured A1-style reference to a different sheet. On Nov 19
Show full article (3.55Kb) · Show article thread
Will MicroSoft fix this in an upcoming release? "iliace" wrote: > Ah! Multiple tables - confirmed. It does work with GETPIVOTDATA() > formulas, or using a non-structured A1-style reference to a different > sheet. > > > On Nov 19, 3:20 pm, TKS_Mark <TKSM...@discussions.microsoft.com> > wrote: > > You covered all scenarios except for one. The two tables are in two > > different sheets     

Group: microsoft.public.excel.misc · Group Profile · Search for Ah my table in microsoft.public.excel.misc
Author: TKS_Mark
Date: Nov 19, 2007 12:50

Ah! Multiple tables - confirmed. It does work with GETPIVOTDATA() formulas, or using a non-structured A1-style reference to a different sheet. On Nov 19, 3:20 pm, TKS_Mark <TKSM...@discussions.microsoft.com> wrote: You covered all scenarios except for one. The two tables are in two different sheets in the same workbook. I just now moved my problem table into the same sheet as the
Show full article (3.04Kb) · Show article thread
In article <garym-503BEE.05561811052010@news.mv.net>, garym@_MYLASTNAME_.com (Gary McGath) wrote: > > Ah, I hadn't noticed that. It might be easier to split it up into > table cells and > > use the title attribute? Then it doesn't need any JavaScript. > > Just lots of CSS (which admittedly is cleaner for most things than > JavaScript), and either doing 102 graphics or getting each cell     

Group: microsoft.public.excel.misc · Group Profile · Search for Ah my table in microsoft.public.excel.misc
Author: TKS_Mark
Date: Nov 19, 2007 12:48

Makes sense. You can mock up an append query in query design. (Append is on the Query menu.) Type some vaolues into the Field row, e.g.: EmpID: 99 and in the next column: ReviewDate: #1/1/2008# Then switch to SQL View for an example of the SQL statement you need. You can then massage it in VBA to concatenate the desired values into the string. The the basic approach to Execute
Show full article (2.89Kb) · Show article thread
Say I create a table called tblEmployeeReviews and within the table I have these fields: EmployeeReviewID - PK EmpID ReviewType ReviewDate ActualReviewDate And then another table called tblReviewType which would be joined with the above table based on the ReviewType. From the AfterInsert can I have it only create the first 3 records in the tblEmployeeReviews, 1 being the 3month review     

Group: microsoft.public.excel.misc · Group Profile · Search for Ah my table in microsoft.public.excel.misc
Author: iliace
Date: Nov 19, 2007 12:39

Ah: you just want to record that there was a review, not what happened in the review. My reply is largely irrelevant. So you want to record that: - first review is due 3 months after HireDate; - second review review is due 6 months after HireDate; - subsequent reviews are due each year on the anniversary of HireDate. So part of the issue here is that this is an open-ended sequence. While ever
Show full article (2.70Kb) · Show article thread
"ah" <splifingate@gmail.com> wrote in message news:48d450a0$0$67988$892e0abb@auth.newsreader.octanews.com... > Wim Jay wrote: >> "ah" <splifingate@gmail.com> wrote in message >> news:48d1a00a$0$33687$892e0abb@auth.newsreader.octanews.com... >>> Wim Jay wrote: >>>> "Naked Gonad" <bodron57@tiscali.co.uk> wrote in message >>>> news:48d0c1a7$1_2@mk-nntp-2.news.uk.tiscali.com... >>>>> honestjohn@centurytel     

Group: rec.music.filk · Group Profile · Search for Ah my table in rec.music.filk
Author: Rafe Culpin
Date: May 13, 2010 15:14

"ah" <splifingate@gmail.com> wrote in message news:48d450a0$0$67988$892e0abb@auth.newsreader.octanews.com... Wim Jay wrote: "ah" <splifingate@gmail.com> wrote in message news:48d1a00a$0$33687$892e0abb@auth.newsreader.octanews.com... Wim Jay wrote: "Naked Gonad" <bodron57@tiscali.co.uk> wrote in message news:48d0c1a7$1_2@mk-nntp-2.news.uk.tiscali.com... honestjohn@centurytel
Show full article (0.81Kb)
    

Group: microsoft.public.access · Group Profile · Search for Ah my table in microsoft.public.access
Author: Allen Browne
Date: Sep 22, 2008 09:06

Show full article (4.92Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Ah my table in microsoft.public.access
Author: Secret Squirrel
Date: Sep 22, 2008 08:53

Show full article (3.91Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Ah my table in microsoft.public.access
Author: Allen Browne
Date: Sep 22, 2008 05:04

Show full article (2.30Kb) · Show article thread
    

Group: alt.talk.bollocks · Group Profile · Search for Ah my table in alt.talk.bollocks
Author: honestjohn
Date: Sep 20, 2008 00:57

Show full article (1.65Kb) · Show article thread
    

Group: alt.fluffgirl.pinkusensei · Group Profile · Search for Ah my table in alt.fluffgirl.pinkusensei
Author: honestjohn
Date: Sep 20, 2008 00:57

Show full article (1.65Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next