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!

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

Recent content by RuralGuy

  1. RuralGuy

    calculating indivdiual days between two dates

    What is it you want to display on the form? (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 ac13 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
  2. RuralGuy

    calculating indivdiual days between two dates

    This link should point the way: (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefithttp://access.mvps.org/access/datetime/date0011.htm
  3. RuralGuy

    Filtering 2nd Subform from 1st subform

    Glad to hear you got things working. (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
  4. RuralGuy

    Filtering 2nd Subform from 1st subform

    Try a Me.frmSessionAvailabilityStaff.FORM.Requery in the OnLoad event of the MainForm. (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
  5. RuralGuy

    Filtering 2nd Subform from 1st subform

    Good point Duane! They work well for a filter as well. SpartansFC, give them a try. (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
  6. RuralGuy

    Filtering 2nd Subform from 1st subform

    I don't use filters much so bear with me while we experiment. I would start by putting a filter directly in the Filter property of the 2nd SubForm. Something like "ClubName = Me.Parent.InvisibleClubName_txt" and see if it filters for the ClubName as you make changes in the 1st SubForm. (RG for...
  7. RuralGuy

    Filtering 2nd Subform from 1st subform

    I usually create an invisible TextBox on the MainForm that containd the value I want from the appropriate SubForm. It is then easy to reference as a filter for your 2nd SubForm. Leave the invisible TextBox Visible until you get it to work as you want. (RG for short) aka Allan Bunch MS Access...
  8. RuralGuy

    event procedures

    Glad to hear you got it sorted. (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
  9. RuralGuy

    event procedures

    In what event are you calling this "global function" and what is the function? (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
  10. RuralGuy

    Acc 2007 Why in the world? I wanted to add a unique ID to my table

    You should have created a new table with the additional field and then appended all of the records. (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
  11. RuralGuy

    bookmark record not working

    Starting suggestions: Disambiguate your libraries... Dim RstPiece As DAO.Recordset, RstDetailFacture As DAO.Recordset ...your original Dim line would Dim RstPiece as a Variant --- I do not see where you are bookmarking a record. (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 -...
  12. RuralGuy

    Microsoft access Subform and Not in List

    What ComboBox are you having trouble with and where is it located? (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
  13. RuralGuy

    remove file encryption using vba

    I, for one, have no idea what the colors mean. Are you seing these colors in Windows Explorer? What are the various OS's involved? (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
  14. RuralGuy

    Problem with Custom Command Button Code

    See if this link clears up the issue a bit: http://access.mvps.org/access/forms/frm0031.htm (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
  15. RuralGuy

    Tab pages

    That is usually the problem. It is a tricky visual test. 8^) (RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro Please respond to this forum so all may benefit
See more

Part and Inventory Search

Back
Top