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 derfloh 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: troix
  • Order by date
  1. troix

    Hiding a RECORD

    ne'er mind, i just told it to add a new record first. that worked.
  2. troix

    Hiding a RECORD

    Actually, it's not working, it's deleting the record the first record REGARDLESS. *ICK*
  3. troix

    Hiding a RECORD

    i figured out it's easier to tell it the opposite of what I REALLY wanted. somehow it worked. *scratches head* wheeen Microsoft. Maybe it's because I think backwards.
  4. troix

    Autodate

    Okay, this should be easy. I have a date field. I want it, when clicked, to automatically enter todays date. Thanks
  5. troix

    Hiding a RECORD

    Actually, I am so proud of myself, I figured it out on my own *WHEEEEE* But what we want is a CHECK BOX (instead of yes/no) and if the CHECKBOX is checked, after pressing the button, the YES's become invisible.
  6. troix

    Hiding a RECORD

    I am okay. I am a little confused on the adding a query part. I am not a user of queries, usually.
  7. troix

    Hiding a RECORD

    I know there is a way to run a procedure, if a box is checked ALL RECORDS with the checked box will disappear after the "CLEAR" button is pressed. They will stay in the Table, but won't appear on the form.
  8. troix

    Hiding a RECORD

    I've done this before, and I have totally forgotten how. I want to create a command that, when a certain box is "dirty" (with text), a button can be pressed that says "Clear Copy". Once "Clear Copy" is pressed, those records are not seen. They are NOT deleted from the table, but those records...
  9. troix

    "hide records"

    but i want them to have ONE last chance by being forced to have to press a button and clear out any errors.
  10. troix

    "hide records"

    I know how to test for dirty. The thing is if the field becomes dirty, after pressing a Dialogue button, I need those records to "hide".
  11. troix

    "hide records"

    I've done this before, and I have totally forgotten how. I want to create a command that, when a certain box is "dirty" (with text), a button can be pressed that says "Clear Copy". Once "Clear Copy" is pressed, those records are not seen. They are NOT deleted from the table, but those...
  12. troix

    If Then different form

    Doesn't work. already tried that 1,000 times.
  13. troix

    If Then different form

    in VB, i need to create an If..Then statement On the form "PAGE7" is a field "Med55" on the form "PAGE8" is a field called "Med76" If Med55 is "1" then Med76 needs to be disabled. Being Med76 is on a different form, how would I writ the statement?
  14. troix

    Default Values 0 to ""

    well, it's not glib, it's just true. *sigh* Why doesn't Microsoft make it where you can have NO default?
  15. troix

    Default Values 0 to ""

    There is no query yet. Just the table. and all the default values are "0". I want NO default.
  16. troix

    Default Values 0 to ""

    I have about 250 fields (this is one momma of a database). Is there a RAPID way in the table to change all the 0's to "" (empty set)?
  17. troix

    Reminder/Alerts

    I have SEVERAL documents in a SUB FORM named "GRANTS" I have 3 dates entered into "GRANTS" Date1 Date2 and Date3 I need it so that if it is one of these dates or AFTER, a box will come up saying there is an alert saying "GRANT REMINDER NAME (from the main form) on DATE(x)" and if OK is...
  18. troix

    Reminder/Alerts

    I have SEVERAL documents in a SUB FORM named "GRANTS" I have 3 dates entered into "GRANTS" Date1 Date2 and Date3 I need it so that if it is one of these dates or AFTER, a box will come up saying there is an alert saying "GRANT REMINDER NAME (from the main form) on DATE(x)" and if OK is...
  19. troix

    Math Functions

    Okay I got it now! I just had to put default 0 in the score boxes to see a running score. Thanks amillion!
  20. troix

    Math Functions

    I looked in that thread, and tried this Private Sub Total_AfterUpdate() Me.Total= Me.TotalHidden End Sub It's not working.

Part and Inventory Search

Back
Top