Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Greg553
  • Content: Threads
  • Order by date
  1. Greg553

    Coding combo boxes to be enabled/disabled

    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...
  2. Greg553

    Two combo box populate a third

    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...
  3. Greg553

    running multiple querys in order

    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...
  4. Greg553

    How to use update query ?

    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...
  5. Greg553

    Trying to set up a flter query on two combo boxes

    Hello I am trying to set up a query which is filtered based on selections in two different combo boxes. Can this be done. Cbo_Weeks Cbo_Program the query contains these two fields in the query with other fields also. The form which contains the Combos is name Frm_PowerTraining I am trying...
  6. Greg553

    trying to get a grid on report

    Hello, I'm trying to get an empty grid on a report, so the users can enter there weights or reps that they have done. I can get the first row of a grid but no more. It looks like this Reps Weight Time Explosive 1 Clean Upper body 1 Bench Lower...
  7. Greg553

    turning controls on/off based on choice

    hello i am trying to figure out how to make a control active or inactive based on another control choice. What I have is two group frames ( toggle buttons) one is RUN/PASS the other two are Frame run and Frame pass, both wit toggle buttons in them. What i'm trying to do is, when some one...
  8. Greg553

    Conditional toggles / Frame groups

    hello i am trying to figure out how to make a control active or inactive based on another control choice. What I have is two group frames ( toggle buttons) one is RUN/PASS the other two are Frame run and Frame pass, both wit toggle buttons in them. What i'm trying to do is, when some one...
  9. Greg553

    Archive data or History table

    I have a table called tbl_weightlifting It has hundreds of records of players on there weight lifting.Fields are What I want to do is be able to save this table as a history table, meaning as players leave and new ones come in I want to have a records table that will hold all the history. At the...
  10. Greg553

    Finding Max lift or top 5 performers

    Hello again. I have a Situation where I want to get the top 5 or 10 performers in a certain lift. I have a table that of course has many records and multiple records for the same player. My table is set like this tbl_weightlifting Weight_ID Player_ID Lift_ID Weight lIfted Date i know how to...
  11. Greg553

    Filtering records on form and sub form

    Hello, first let me say thanks to all the help on this site. I'm trying to set up a filter where i have a Form / sub form the top half is the form, used to edit a record. the sub form is in data sheet view of the form. what i' trying to do is have a list box or combo box on the top form so i...
  12. Greg553

    list box writing data to table

    Hello, i will try to explain the best i can. I have a form that has to list box controls onit Listboxnames Listboxlifts the listboxnames is populated with names from a table containing the names of players. when you click on a name in the list box the after update code runs and populates the...
  13. Greg553

    number of records

    How do you limit the number of records that can be entered . i'm looking to have a limit on records in the demo program so i can have clients review the program while not be able to enter more than 5 or so records. thanks greg
  14. Greg553

    get query to show all colums

    I am trying to get my query to show all results for each lift type for each player and weight. This is new territory for me and not sure how to go about it. this is my set up TBL_corelifts Lift_ID ( each lift has its own ID) LiftType (bench press, squat,dead lift etc )...
  15. Greg553

    Filtering list boxes showing result

    First let me say that I have learned more from this site than most of the books i have read. The books only show all the basics. Thanks to everyone who has helped. I am trying to filter a list box, what I want to do is choose a players name in the first list box and have the second list box...
  16. Greg553

    showing value in text box based on list box choice

    What i'm trying to do is show the corresponding value based on two list box choices. this is the set up list box names Player_ID Player Name List box Lifts Lift_ID LIft Type I have a query of the weight lifting table which has the max weights for each lift for each player...
  17. Greg553

    show text instead of ID

    I'm trying to show the text associated with the ID field. I have three tables playerinformation sportsidentification sportspositions the sports Identification table has: sports_ID Sports Sports position table has Position_ID Sports_ID Positions I'm storing the sport_ID field (numeric) I...
  18. Greg553

    problem, error message

    I have no idea how this happened or how to fix it. I have tried everything. My combo boxes where working fine. I have two and based on what you choose in the first limits the second. Cascading combos.. they were working fine than i got this message This error occurs when an event has failed to...
  19. Greg553

    showing the Text in sted of ID

    hello, I know this is most likely an easy fix, just can't seem to find the answer. I'm trying to get my query and report to show the sport name instead of the sport ID. I am storing the Sport ID in the sport field . each sport has it's own ID. when printing a report I want to show the sport...
  20. Greg553

    cascadingcombos

    Hello, I know this question has been asked and I have search all the posts on the subject.I just can't seem to get this right. What i need to do is store the values chosen from each combo box. This Is what I have. tbl_player information ( where all information on player is stored )...

Part and Inventory Search

Back
Top