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 Chriss Miller 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 tav1035

  1. tav1035

    access formula approach (RD workorders within 15 days of the closing of the last PM workorder)

    I starting a data pull using access and I am looking for ideas before I get too involved. I'm looking to know if there is a way to find RD workorder's (reportdate) within 15 days after a PM workorder's ( actfinish) date on an asset using access and Oracle. Fields- VIEW_WORKORDER.WONUM...
  2. tav1035

    converting an excel formula to use in access

    MajP, Did you run this in Excel? or access? Where do I add the code? I need some steps as to where to add the code and how to run it. thanks for your time tav
  3. tav1035

    converting an excel formula to use in access

    Andrzejek- So the folling data is in an oracle database. PMNUM FREQUENCY FREQUNIT NEXTDATE1 PM1 1 MONTHS 10/12/2015 PM2 2 WEEKS 10/12/2015 PM3 30 DAYS 10/12/2015 PM4 1 YEARS 10/12/2015 Every week a script runs to see if anything falls within this week and if it does it produces a...
  4. tav1035

    converting an excel formula to use in access

    I have a table with a frequency (the value at which something will happen), frequnit (units at which it will happen), nextdate1 (next time we expect it to happen). FREQUENCY FREQUNIT NEXTDATE1 nextdate2 2 MONTHS 1/2/2015 3 WEEKS 10/5/2015 30 DAYS 2/1/2015 1 YEARS...
  5. tav1035

    VBA to Copy the value from the Table/field to a textbox on a form that is used as a visual

    Ok, actually they both work great. Thanks. tav
  6. tav1035

    VBA to Copy the value from the Table/field to a textbox on a form that is used as a visual

    PHV, Not sure where to add this, but I added it to the textbox Control Source and it returns #Name? thanks tav
  7. tav1035

    VBA to Copy the value from the Table/field to a textbox on a form that is used as a visual

    I have a database that the tables are populated by odbc (external oracle database), via a push button running a refresh macro and a creating a few make tables, charts and reports. I have a form called "Main_Form" on that form I have a few textboxes that I'm using as a stoplight chart. One of...
  8. tav1035

    Calendar Style Report for oracle

    Does anyone have a calendar style report that is functional like the one LBASS created. I was hoping to find one that doesn't use other excel files for the tables and is a stand alone report. I have one table called PM and the field name is called nextdate. I have a frequency called freq (ie..1...
  9. tav1035

    RTF to HTML Crystal Reports 10 to oracle

    I have Crystal Reports 10 (CR Developer; FULL ver 10.0.5.1177) I'm using to hit the a field in an oracle database {LONGDESCRIPTION.LDTEXT}. I'm currently using a formula to convert rtf to html and I'm also using the format "text interpretation set to html". Formula works great- stringvar...
  10. tav1035

    Comma delim- Parsing first, second, and third word from a field in ACCESS formula needed

    dhookom, thanks for the quick response, The vb works great and was easy to use. thanks, tav
  11. tav1035

    Comma delim- Parsing first, second, and third word from a field in ACCESS formula needed

    I have never used vba in access and I can if I need to, but was trying to keep it simple with just a few formulas. I was using Excel and now have switched to Access. Here are the 3 formulas that I used in Excel. TRIM(MID(SUBSTITUTE("," & $I8&REPT(",",6),",",REPT(" ",255)),1*255,255))...
  12. tav1035

    Comma delim- Parsing first, second, and third word from a field in ACCESS formula needed

    Forgot to mention, i want to parse the description into 3 different columns.
  13. tav1035

    Comma delim- Parsing first, second, and third word from a field in ACCESS formula needed

    I'm looking for a formula that will parse a comma delimited field. I think I have the first formula-> Class: IIf(InStr(1,[ASSET.DESCRIPTION],",")=0,[ASSET.DESCRIPTION],Left([ASSET.DESCRIPTION],InStr(1,[ASSET.DESCRIPTION],",")-1)) I am struggling with the other 2 formulas. My data with 3 example...
  14. tav1035

    Parsing out text using a formula

    Thanks Brian, I used the suggested formulas as - First formula- split({ASSET.DESCRIPTION},",")[1] Second formula- if ubound(split({Asset.Description},",")) >= 2 then split({Asset.Description},",")[2] else "" Third Formula- if ubound(split({Asset.Description},",")) >= 3 then...
  15. tav1035

    Parsing out text using a formula

    The description for the first asset is SHREDDER, PAPER This should come out as SHREDDER using the first formula (which it does) This should come out as PAPER (has an error) The first formula worked as suggested split({ASSET.DESCRIPTION},",")[1]) The second formula saved, but it has an error...
See more

Part and Inventory Search

Back
Top