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 gkittelson 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: *

  1. dbflora

    Link Access to excell

    I have been looking for the answer to this one as well.
  2. dbflora

    Grouping and Graphs

    Thanks!
  3. dbflora

    Grouping and Graphs

    Is there some way to group date data by week ending. I need to convert daily information into info by week.
  4. dbflora

    Grouping and Graphs

    I have various dates and corresponding data that I would like to put into a graph by week ending instead of by day. Can this be done automatically or do I have to add up the totals for each week in a seperate table?
  5. dbflora

    Option buttons

    Thank you!!! You have no idea how long this has been bugging me.
  6. dbflora

    Option buttons

    Nope. Maybe I am not entering in the correct expression. I put =[Option10].Value=Abs([Option10].Value) in the AfterUpdate event and nothing. Is that correct? At least there was no error message this time.
  7. dbflora

    Option buttons

    Can anyone help me with this?
  8. dbflora

    Option buttons

    I think there was an error somewhere else on the form. I have started over. To simplyfy I just created one field and on the form and attched it to a seperate table. I inserted one option button and tied it to the same field. When I click the option button, the field in the form and on the...
  9. dbflora

    Option buttons

    I tried putting it in click event, same results. The error comes when I try to save or exit the form. I've got the option buttons set up in an option group and they are linked to seperate fields. I need to have it return a 1 or a zero into the appropriate field.
  10. dbflora

    Option buttons

    I think I'm close. I keep getting "error evaluating check constraint" errors. You are correct in that the form is bound to the table. I am setting a button (option 61) with =[Option61]=Abs([Option61] in the AfterUpdate section. Am I douing it incorrectly?
  11. dbflora

    Option buttons

    First, thanks for the help. Second what I am trying to do is have the -1 show up as +1 on all tables and reports I run. I have 4 option buttons to choose from and I would like to have the one that is checked return the 1 and the others 0 so I can calculate totals.
  12. dbflora

    Option buttons

    Sounds exactly like what I need to do. How do I incorporate this into the option button for doing a count.
  13. dbflora

    Option buttons

    Option Buttons - When I use an option button, it returns a negative 1 value, T/F ot Y/N. Is there some way to have it return a positive 1 value?

Part and Inventory Search

Back
Top