Recent content by Greg553

Hey everyone, Thanks for all the replies...Great info..And also thanks for all the extra questions and answers...All ways learning.. Greg

I'm stuck on a simple problem i would bet. I have a option group containing 3 choices, beginner, Intermidiate,adavanced. I have 10 combo boxes below. what i want is to enable so many boxes based on choice in option group. so if beginner is choosen 5 combos are enabled, and so on. I have done...

Thanks PHV. Still having a little trouble as 3rd listbox won't populate. Do i have the event in the right place. I get no errors now but does not fill in row source of 3rd listbox Thanks Greg

Hello again. What i am trying to do is populate a combo box based on the choices of two other combobox's. the two combo boxes are not based on each other, just the 3rd is based on the first two. here is my code. not sure if i'm even close , but gives me a error. Private Sub...

Hello, i got a little stuck on tis. I am trying to figure out how to populate a combo box based on the result of the choices of two other boxes. Combo boxes are Programs combo box fields are program_ID, programs Weeks combo box Fields are weeks_ID, Weeks the combination of these two choices...

I have one more question, I have set up 3 Buttons cmd_updategrades cmd_Appendhistory Cmd_DeleteGrads what i want to do is have the first button active, the other two not active, after the first one is done running the update i would like to go to the next one and make it active and the one...

No i think that i have a lot of information that will see mw through. thanks for all the help

Thanks for all the ideas. i know that most coaches who will be using the software would not rather sit a bay sit through all the warnings. THEY want to hit one button and BAM it's done....HaHa I could set up just one warning maybe that all this stuff is going to happen i guess before they do...

Thanks guys, was a big help.. i can see the problems etc. I will try your ideas. What is the admin table with date and time stamp. How do i go about this...

Hello again, i have three querys Qry_updateGrades Qry_AppendPlayerInfo Qry_DeleteGraduates each query does what it says, how do i go about having just one button ( it says End of year update )runthese three querys in the order i have posted, will the boxes still come up saying you area...

Since on this subject, how would i go about creating a back up / restore data base feature. I would like to be able to backup data just incase something goes wrong and restore . I am going to look at posts to see but i figured i would ask thanks for ll your help

Sounds like a plan. that is a good Idea. i would at most have 20-30 seniors a year moving on so that sounds good. i also like the year aspect also Thanks greg

Once again thanks dhookom. I guess now what i would like to do is beable to update all grades at end of year and delete the ones that have graduated. So all 12th graders would be deleted from current table and archives into my history table. How would i go about coding this I have...

I want to update one field in my table. What i have is a player information table which has basic information on each player. The one i am concerned with is the grade field. What i'm trying to do is at the end of the year run a query to update each athletes grade to next grade. For example...

Thanks, that was easy