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. statmanron

    Difficulty Searching TIME in Access Database

    Skip...You're a genius. To make it easier for myself, I converted the dates into a text field because the data is not going to change in the lookup table. Thanks for your help!!!!
  2. statmanron

    Difficulty Searching TIME in Access Database

    I created a lookup table in Microsoft Access that lists long times between 9:31:00 AM to 4:00:00 PM. Through the query tool, I can successfully find the record times between 9:31:00 AM and 9:33:00 AM... but nothing greater than those three values. The query works for 9:33:00 AM and below but...
  3. statmanron

    Accessing Outlook Email from Microsoft Access

    Presently, I'm storing entire email messages within my personal organizer that I created in Microsoft Access. I'm looking for a VBA function to open an Outlook email from a stored email ID field within Microsoft Access. This way I would save space within Microsoft Access.
  4. statmanron

    Creating Dynamic IF Statements for Selective Record Groupings

    PHV - Eval is the best function in the world. Thank you. This prevents the need to overload numerous functions. You're awesome. MajP - You're awesome too!!! Thanks :)
  5. statmanron

    Creating Dynamic IF Statements for Selective Record Groupings

    That is a great alternative MajP - you are awesome! Its just too bad we cant send a conditional "STRING FORMATTED CONDITION" to an if statement like the following: Read record Initialize/Setup New StatStudy do until eof If "STRING FORMATED CONDITION" then setup the SS object loop...
  6. statmanron

    Creating Dynamic IF Statements for Selective Record Groupings

    Multiple conditions could exist with the (1) initial/starting criteria and with (2) finalizing criteria. All fields are listed within the table.
  7. statmanron

    Creating Dynamic IF Statements for Selective Record Groupings

    As example would be ClosingPrice > MA20(20 day moving avg), I would like to group/calculate totals (Business day counter, on going gains) until ClosingPrice > MA20 and ClosingPrice > MACD(another indicator). Sometimes there would be numerous conditions. Thanks!
  8. statmanron

    Creating Dynamic IF Statements for Selective Record Groupings

    Fair enough MajP. I've created a stock table that stores historical prices and some other calculate fields. In order to back test certain scenarios, I would like create a user interface to select field names from the table and conditions (">", "<", "=") to compare with other fields or random...
  9. statmanron

    Creating Dynamic IF Statements for Selective Record Groupings

    In MS Access - VBA, I'm trying to group records while looping through a recordset. Is there a way I can create two dynamic if statements(1. condition to start the occurrence/looping, 2. end the occurrence) using fields within an Access form. For instance, I've created an MS Access form where a...

Part and Inventory Search

Back
Top