The new beta version doesnt fix this problem yet. Any idea when we can expect a resolution. Thanks
52 2016-05-16 19:40:21
Re: math and default value (5 replies, posted in General)
hi Derek
once again you got what i needed to know. thanks for the info. i think you are getting to know my project better than me. i am learning some along the way but a lot is confusing. it would be nice to go one on one with someone and get some instruction but i dont know where i would get it around here without actually going back to school and i am both too old and too poor to attempt that. thanks again for your help.
lee
53 2016-05-16 17:12:28
Re: combobox questions (16 replies, posted in General)
hello again Derek
just chedked out the dl. its close but there is a problem. no what team i choose as the visitor team, the same team name shows up.'fire ballz'. the player show up as the right players for the team i pick..
lee
54 2016-05-16 16:37:11
Re: combobox questions (16 replies, posted in General)
Hi Derek
Thanks again. i just downloaded the file and will check it out. i was wondering if ou would have any recommendations on the best/easiest way to attack the math stuff i need to do on this. team ran, team total score for season, win percent, player games played, games won/lost, mvp points, etc. as always, look forward to hearing from you.
lee
55 2016-05-13 07:39:33
Re: combobox questions (16 replies, posted in General)
hello again Derek
i think i figured out how to do the visitor team but i cant get any of the information to show up in the tablegrid to make sure i am actually getting two different teams saved. i have been playing aroung with this fora few da getting nowhere.
lee
56 2016-05-12 07:34:26
Re: More on dates (8 replies, posted in General)
hi Derek
once again you are right on point. works perfectly. i thought maybeit had something to do with the id but wasnt sure where to go with it. dont seem to be able to find any documentation on the function use. would appreciate it if you could give me some direction to go there. again and again i appreciate all the help.
lee
57 2016-05-12 07:21:18
Re: math and default value (5 replies, posted in General)
yes and to expand on the question further, does the same go for default values in an integer field in a table. is the value always 0 or only 0 if it has not been changed. do the calculations in a calculated field assume they are being done in other words i cant do calculations on a field that hasnt had a value placed there byh some means. sorry for the basic questions but this is pretty new and i havent been able to dig up the answers any place else. thanks for all of your help.
lee
58 2016-05-10 16:19:13
Re: More on dates (8 replies, posted in General)
couldnt get it to work for me. attached is sample of what im trying to do.
59 2016-05-09 23:10:11
Re: More on dates (8 replies, posted in General)
i use the weeksbetween to automatically give me the week number of play. seemed like an easy way to do it to me.
60 2016-05-09 20:10:53
Re: More on dates (8 replies, posted in General)
geves me error "" is not a valid date time
61 2016-05-09 17:46:06
Topic: More on dates (8 replies, posted in General)
i wish to show a start date in datepicker2. i have this line in an 'on change' event in datepicker1: form1.DateTimePicker2.DateTime:=sqlexecute('select startdate from seasons where id=seasonname' ). when i change the date in datepicker1 i get a date in datepicker2 but it is always some datein 1899. never the correct date.
62 2016-05-04 09:24:21
Re: combobox questions (16 replies, posted in General)
hi Derek
i understand what you are saying. i'm not quite sure i understand what all you did to fix it. it does work and i thank you for that. now back to beating my head against the wall trying to figure out how to do the next thing with this little project. thanks again
lee
63 2016-05-03 20:57:39
Topic: math and default value (5 replies, posted in General)
if i set a default value of 0 in a text box and then use it in a math expression like edit1=edit1 + 1 what is the value of edit1 the next time i run the program. what is the value of the table field it represents. does it go back to 0 or maintain the computed value?
64 2016-05-02 21:09:35
Re: combobox questions (16 replies, posted in General)
hi Derek
coldnt get it to work. i just got an empty list for the player combobox. tried to play around and get your configuration to work for me but seem to be missing something enclosed is a very simplified version of the way i am doing things. maybe that will help.
thanks again
lee
65 2016-04-30 15:52:22
Re: combobox questions (16 replies, posted in General)
hi derek
thanks for the help again.
1. works great, just what i needed.
2. thats way beyond my knowledge of sql. in my quest for learning sql i did come across this nice site: http://www.fincher.org/tips/General/SQL.shtml. samples of about every sql command.
3. relates to my billiards project. i have set up several teams so my top combobox contains that list. i pick one of those teams. under that i have 10 comboboxes each have the full list of players available. i pick one player from the list for each box. now i have a team with 10 players assigned to it. when i go to fill in a blank scoresheet with the same combobox arrangement (team but only 4 players), i can pick the right team from the team box but the players dont follow. when i go topic the team member that should be assigned to that team the full list of players not just the 10 assigne to the team.
lee
66 2016-04-29 09:21:38
Re: Random error on development and preview (18 replies, posted in Reports)
i also have this happen when i run the project. while in preview if i run the mouse over the menu bar another form will pop up
67 2016-04-29 07:34:33
Topic: combobox questions (16 replies, posted in General)
i have a couple of questions about the combo box.
1. when i use multiple fields they are run together. is ther a way to put spaces between them and control how many spaces.
2. how to i reference the different fields in the same combobox. ie. combobox1.???.value:=something
3 this is a long one. i have a pool of a-z and a combobox with choices A,B,C. i choose A. I have some more comboboxes with choices a-z. i pick a-d for the firs and e-j for the second etc. the question is when i go to another form how do i get the comboboxes holding partial alphabets for a to show as partial alphabets and not the whole a-z for each combobox.
68 2016-04-23 09:36:30
Re: Random error on development and preview (18 replies, posted in Reports)
same thing happens to me when trying to design the report. using windows 10.
69 2016-04-20 16:28:10
Re: preview error (3 replies, posted in Reports)
attached is the report. i want to print it blank
70 2016-04-20 09:16:32
Topic: preview error (3 replies, posted in Reports)
i get "unconnected header/footer Header1" error when i trh to preview a report design. any ideas?
71 2016-04-20 08:59:45
Re: adding rows and column on a form (13 replies, posted in Script)
came to checkl lmy response from a few days ago and find it didnt get posted for some reason. you got it perfect. i dont think tab ordering isgoing to be a problem as none of these guys are really data entry people. after a few shees they just want to get the infoin. the math part i know how to do from basic i just need to figure out how to do it in this environment. this is all new to me so i have to learn as i go along. i found sql lessons on line but i think they go intoa lot more than i need to knw for this. i could use some help on good material as it relates to what i am doing. i want to thank you for all of your help. i really appreciate it. i did urchase mvd. i have never had any software where i could get the support or hep i have needed. you guys are terrific. i hope everyone realizes the time and effort it takes to get the qualityof help you guys provide.thanks again,
lee
72 2016-04-12 09:43:57
Re: adding rows and column on a form (13 replies, posted in Script)
the column of numbers to the left of the names are the individual handicaps.the way they are arrived at follows: the year is divided into 2 playing sessions of 21 - 24 weeks. for the first two sessions his handicap is the total number of points made divided by the total number of games played.rounded up.. at the beginning of the third session, all of the figures for the first session are dropped and it consists of the second session numbers plus the numbers from the third session as the games are played. at the end of the third session the second is dropped and the fourth and fiveth are used etc like i said, a strange way of doing it. hope this helps
lee
73 2016-04-11 21:26:49
Re: adding rows and column on a form (13 replies, posted in Script)
it looks really good but the problem is the data still has to be entered thru that scoresheet. its a nationwide league and that sheet is the standard score sheet used. being new to this, i am going to have to take some time to stud what you are doing but i am guessing i will need to do somethinglike that to do the strange way they figure the handicaps for the individuall players.
lee
74 2016-04-11 19:24:30
Re: adding rows and column on a form (13 replies, posted in Script)
the database structure may e wrong but that is a different problem.i dont think you understand what is going on with the scoresheet. a blank sheet is given to each team in the match. each player in the match plays each player on the other team one time so ther is one square for each score in that players row. the last square is the tota of all of that players scores. the process is repeated for all players. the columns are the rounds of play. adding all of the firs round scores of each player goes in the subtotal square for that round. there is a round for each player so there are that many colums plus a totals column.. each player has a handicap so all of the handicaps are added together for each team. the smallest subtracted from the smallest and that number goes in the add handicap row for the team that had the smallest handicap. then the subtotals are added to them for the totals. these totas are compare to the other team to determine the winners of the individual round. the totals are added together for each team and compared to determine the overall winner and by how many ppoints. this sheet is then turned into the league manager who enters it into the database. my goal is to have the totals and subtotals fill in as she is entering the data
75 2016-04-11 14:21:32
Re: adding rows and column on a form (13 replies, posted in Script)
the information i was giving wasnt specific to my project. as my pfoject is more complex i was hoping to give enough information to duplicate the problem without having to bother you with my whole thing. it is attached, the problem is with the scoresheet scores. adding the rows and the columns. thank you for your help.
lee