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

    Autodate

    Okay, this should be easy. I have a date field. I want it, when clicked, to automatically enter todays date. Thanks
  2. 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...
  3. 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...
  4. 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?
  5. 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)?
  6. 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...
  7. 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...
  8. troix

    Math Functions

    If I have say 6 fields Score 1, Score 2, Score 3, etc. And then a 7th field "Total Score" What is the steps needed to make total score = a sum of Score 1 through Score 6? Thanks so much!
  9. troix

    "Other" Option

    I have an option box with the races/ethicities in it. I have an "Other" text box. I want to fix it where they can't type in "Other Text Box" UNLESS they fill in the bubble in the option box for other. Any ideas?
  10. troix

    Mutliple Carryovers

    I am trying to write in VB a procedure (or whatever it's called) where CGID, CG First Name AND CG Last Name from the original form will go into the NEW form. I can only get CGID to go in as of now. These are the names in BOTH forms. I know adding new StLinkCriteria and DoCmd.SQL isn't working...
  11. troix

    Open New / Close Old

    I am trying to create a button that will OPEN "CAREPLAN" and CLOSE "PSAFILES". PSA Files has a data field called "PSAID" and is an autonumber and must auto fill in "CAREPLAN" as "PSAID" I had something like the below but it's not working for...
  12. troix

    Backwards Continous Form

    How can I make a continous form go backwards? In essence, the new information i enter on top and the "old" goes as 2d so it'll show up backwards of how I put it in?
  13. troix

    Rolling Form?

    I am trying to do something. I will do my best to explain it. I have a form to enter data. It will later be used as a subform. I want it where instead of going to a "new page" everytime I enter one record, that it just adds a new row to enter the same data. I have to do this in...

Part and Inventory Search

Back
Top