Search results

thank you so much, Big Pat! will play with the design in the next few days, will report on the progress - looks like it needs a little tweaking. this forum is pure blessing - i learned so much about queries here, it's like going to college, only better, in many ways. l

it's not guaranteed that i am going to have ONLY those five, it may change at some point. i'd prefer the resulting table to have 3 fields - Date1, Park, Attendance (but please correct me if you think it's not the best approach). i played with this some more yesterday, and - complete blank! am...

it is bound to the table. i think. i make it (in Access 2007, btw) by selecting the table of interest and then hitting 'create - form (or 'multiple items')' in the ribbon. the problem is that i want something between single entry and multiple entry form, and it's not happening. thanks Trevor.

hi. i am new to Forms, so was having problems with this probably very simple one. please see attached. basically, i need the user to enter the date, and then for each Park - the attendance. then hit the button or enter - and there will be five new rows in the attendance table. any help would...

or - DMAX can work, although it's not particularly flexible, i.e. probably better for looking at customers' max one by one.. i second pivot table.. l

drum roll ! the board is ready. it's a rudimentary set, really, consisting of alternately colored cells and pics of pieces on top of them. you just drag the piece when making a move. included the second set for the bughouse fans.. l

i can do it with formulas, if you are interested.. here, actually - in d1 enter =VALUE(A1&C1) in e1 enter =A1 in f1 enter =IF(ISERROR(VLOOKUP($A1,$D$1:$D$12,1,FALSE)),B1,"") in g1 enter =IF(ISERROR(VLOOKUP($A1,$D$1:$D$12,1,FALSE)),C1,"") copy d1:g1 all the way down. your result is in columns...

so there are two ways so far - If Target.Address = "$W$5" Then and If Intersect(Target, Range("w5")) Is Nothing Then Exit Sub Else is there advantage of one vs the other? i don't see any.. l

thanks Brian. your code put me in an infinite loop triggered by change in any cell. however, i finally came up with the one that works, see below. for posterity, this code is generally useful if you need to plot a column of data, but do not want any of the Excel'07 options for dealing with the...

thanks guys. well, i just spent two hours trying to make this work. i was hardly breathing, trying not to disturb ultra sensitive ms excel vba aura.. it worked once. then i changed the trigger cell from "$a$1" to "$w$5" and it went downhill from there. shutting down excel, new workbooks -...

very strange - i lifted this code from ozgrid site (thank you, ozgrid, and your long term member PCI) - Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If (Target.Address = "$A$1") Then Cells(2, 2) = Cells(2, 2) + 1 ' Your Code...

hm, i don't think i'll be able to play with the letters, i am so used to playing with the images of the pieces.. thanks anyway. i'll post if i find something i have in mind. or if i stop being lazy and make it myself.. l

thanks Charles, i was too busy this week to check your boards, but looking forward to play with them this weekend.. len

hi. i am looking for a very very simple and light excel chess board, and surprisingly can not find anything online (i thought everything has been done and tried on the world wide web by now). i am envisioning an 8x8 grid with white and gray squares and movable pictures of pieces, that's all. i...

i give up.. sorry.. since the elite of the forum keeps silence, maybe try other forums, google or yahoo excel groups or somesuch.. good luck. l p.s. one more idea - try running it on another computer, maybe it's a software issue, who knows..

ignore that ODBC DSN part - it wasn't that, it was just smaller query, the size reduction is almost negligible.. unfortunately.. l

it's actually my wife who will do the bulk of work on this. i think her patience is infinite.. l

even stranger. excel'07 charting is annoying.. in my chart, after i go to the 'legend fields (series)', next to the name of that series, there is a filter square - gray, with tiny arrow in the middle - which, if you click on it, will produce a sort/filter menu. the only other option i can think...

these paths between Excel and Access are so weird and thoroughly beyond my comprehension. for example, a few minutes ago i figured how to import access query into a pivot table with a resulting file about 8 times smaller than what i was doing before. yes!.. (you can try it too - use import data...

thanks bob. don't think i can increase RAM to 3G, but will double-check. so i think my strategy will be to go computer shopping, and pick a machine with your specs, but not buy it until i get the data and see how my current one handles it. if it slows to a halt, i'll be prepared to quickly go...