Search:

like..


Private Function ReleaseDate()
Set cmd = New ADODB.Command
Set cmd.ActiveConnection = cnn
cmd.CommandText = "select * from Table2 where cardset = '" & gCardSet & "' Released"...

what about just adding a NEW cmd? at the end of the current code???

Set cmd = New ADODB.Command
Set cmd.ActiveConnection = cnn
cmd.CommandText = "select * from Table2 where cardset = '" &...

seems complicated.. i just want to pull the RELEASE date on the set that is showing in the flexgrid from table 2 into label3(1).caption.. table 2 doesn't have anything else i really want to grab from...

question..

so, i have this:


Set cmd = New ADODB.Command
Set cmd.ActiveConnection = cnn
cmd.CommandText = "select * from Table1 where cardset = '" & gCardSet & "' order by...

"sleep" was just something i was playing with back in 2004.. like i said i want to re-do / refresh this app as i now have reason to do so.. it's just been a LONG LONG time since i've touched this...

back from vacation.. still on pause tho cause i just got back and get back into routine for work and such..

topic on pause.. i cannot keep up with this for a couple of days.. driving and all that.. i'll check back in soon

k time for a shower, sleep and drive 18hrs.. i'll get back to this.. but ty

same error..

i didn't impliment that back in 2004.. all i can tell you is when the change of owning or not owning it takes a second or 2 to update the db and refresh the grid.. personally i expected any changes...

i'll try it out before i go to sleep and respond.. ty, i appreciate it

atm, i am using a smaller version of the DB than it's upscaled version which i want to use that has lots more in it.. but when i try to do it, i come across alot of issues.. so, i'm stuck between a...

it's a simple "Yes" or "No" in the database.. it works just fine for the first set but not any other set.. you choose yes or no via a combobox in the edit form.. not much to it honestly. just not...

ok, so.. if i right click on a card it brings up an editor to show.. in there i can set the card to owned and other things later.. so atm, it works for the first set in generation 1.. but when i try...

i didn't see that, i will try it now

that works! ty appreciate it

huh? i meant to say #3 - and no, we are not the same person that can be verified by steve or shaggy

the generations and card numbers are numeric...

yes, and i replied in #8

ty anyways..

and what i'm trying to do isn't that hard honestly.. i just can't list the cards in order with all sets - some list fine and others not.. i dunno if it has to do with refreshing, but...

the cards themselves do not have dates.. the date the set was released is the only date given.. so when you load the form, there is another specific table that holds that info and other specific info...

whatever then..

guess nobody is fluent in MS FlexGrids... 116 views and only 1 reply...

yes, i get that the forum is open and not obligated to help and all that.. but if you see someone struggling and keep going...

i thought this would be a "simple" fix.. apparently not.. guess i'lll have to start a new thread starting from scratch tho i did all this hard work.. i really tried on this.. same design, same...

that now lists like this:
1
10
100
101
102 - which is the last card for this set for example..
11
12
13
14

ok, so the Ms FlexGrid will load set 1 from generation 1 just fine, however, if i want it to list set 2 from generation 1 the set doesn't start with card 1 instead it starts with card 26 to 64 and...

@Tabi - Grid1.CellAlignmentFixed(1) = 4 - same error.. but ty, i appreciate the time and suggesstion..


@Arnoutdv - ok, i will look into it.. ty

i tried that exactly.. and then i tried "0" and then "0 , 0".. just error of "method or data not found"

i just want all HEADERS aligned centered.. so i would have to set that for each header?

apparently i'm not getting it.. Grid1.TextMatrix(0, 0).alignment = flexAlignCenterCenter

example...

i just want the headers aligned centered, the info i want to choose what gets centered.. like an image or card number.. but all the headers centered



Private Sub Form_Load()

...

like the next part of the program i am trying to do, will have an MSFlexGrid.. i do have a working version of it.. the issue is it loads the first SET or cards right but if i choose the second set...

i'm not saying it's not and i will look into what he suggested.. i have no issue with that or in disagreement with it at all.. i never said i was. all i did was question the decimal is all

i may...

k, i'll look into that. ty

why the decimal? asking cause i don't understand.. or was that to be a comma?

did you mean: ##,###,000 ???

i can't put it into practice as none of the totals go past 5 digits atm..

however, now there is another issue using that.. i just noticed if i tried that with a smaller amt.. the amt shows "001" for example.. but i don't want the 0's :(

i mean it works great with 4...

format( 'BEFORE rst isn't something i know or would have thought of that


and i assumed everything had to stay within here:


("TotalCount").value


but ty appreciate it.. it works just fine

formatting a label with commas if the label is displaying totals and the code is as follow:



lblTotalCards.Caption = rst.Fields("TotalCount").Value 'Total Cards


something like this: but i...

how about adding a 1 on 1 coaching feature? 1 person asking for a specific thing(s) and only 1 coach? instead of every tom, *, and harry in a thread putting in their 2 cents screwing up the project?...

whatever..

anyways... moving on.. back to #94