Recent content by tav1035

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

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

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

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

Ok, actually they both work great. Thanks. tav

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

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

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

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

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

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

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

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

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

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