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 wOOdy-Soft 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 5ybarite

  1. 5ybarite

    Make table query question

    While I do understand what you both are getting at, 2 things remain true about this database: 1. The size, type, and shape of data I am tracking is completely different for each piece of equipment. For instance; we have 5 environmental air handlers, with data captured in 1 table tracking things...
  2. 5ybarite

    Make table query question

    I'm trying to put together a databse for a project @ work. I have a table for each piece of equipment I need to track numbers for. In addition, from time to time each piece of equipment gets service performed on it, so originally I thought it would be a good idea to store records of past...
  3. 5ybarite

    Excel Macro Question using if then loop to hide rows

    That still yields a "Run-Time error '13': Type mismatch" message on that same line. Any other ideas? Thanks for your help BTW Thanks, ~5ybarite
  4. 5ybarite

    Excel Macro Question using if then loop to hide rows

    If Range(TargetCol & x, TargetCol1 & x).Value = Range(TargetCol & x + 1, TargetCol1 & x + 1).Value Then This is all the farther I've gotten. Everytime I run it, I get that error. Project? It's in a project module specific to that worksheet. I'm still learning, so I don't know if that's what...
  5. 5ybarite

    Excel Macro Question using if then loop to hide rows

    I have a report that I have to generate weekly from another application. This other app will kick things out to Excel; what I want to do is automate the formatting process. Essentially this consists of creating a new worksheet based on the value of cell B (there should only be 4 values) and...
  6. 5ybarite

    Grab 1 year's worth of data based on now() function

    I appologize if this issue is already addressed here in the forums, but I did not find anything that I could use. I'm building a query which I would like to grab information from a table that is updated twice a month. I want that grab to be based on today's date everytime it's run. From the...
  7. 5ybarite

    Keys to save current record and open a new one

    RoyVidar, That was perfect! Thank you! I knew there had to be a way to do what I was talking about. I really appreciate the assist! ~5ybarite
  8. 5ybarite

    Keys to save current record and open a new one

    Pls excuse my "newbie-ness" I'm just returning to Access after a prolonged hiatus. I would very much like to be able to hit "enter" from anywhere (meaning any field) on my form and have that save the record and go to a new one (record) so that I can just continuously enter data and save it...
See more

Part and Inventory Search

Back
Top