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

  • Users: jodie
  • Order by date
  1. jodie

    use functions to separate some text from a string

    I got it. I declared pieces without the (2) and I got it to work. I got it to work when I used the code below. thanks much for your help. Dim sData Dim sTargetText sData = ".\sbp\B262591.CMI:Student Name: JOHN BRYAN" ' Splitting sData returns an array (0-2) of 3 elements, so...
  2. jodie

    use functions to separate some text from a string

    Dim myText, pieces(2) 'only expecting 3 elements (0,1,2) myText=".\sbp\B999999.CMI:Student Name: JOHN SMITH" pieces=split(myText,"\") 'process only 3 elements 'notice that pieces array starts with 0, so you want 1 response.write pieces(1) This is the exact and only...
  3. jodie

    use functions to separate some text from a string

    I tried this code, however I get an error for the third line which is below. The error I get is 'type Mismatch' on this line. Is this because pieces is declared as an array and we are using it like a variable to store a value. pieces=split(myText,"\",3) 'process only 3 elements
  4. jodie

    use functions to separate some text from a string

    Mark, Just one more problem. The length of the word between the slashes won't always be 3 characters, is there a general way of saying this so it grabs that text whether the length may be 3, 4 or 5 or otherwise. thanks
  5. jodie

    use functions to separate some text from a string

    I have a string that reads as below. Out of this entire string, I want to separate the value of whatever is in between the \ \ i.e. sbp in this case and store that in another variable. The value in between the \ is not always the same # of characters, this varies. Could someone please tell me...
  6. jodie

    Pass parameters

    It doesn't seem to help. I still get the same error.
  7. jodie

    Pass parameters

    I am having a problem passing parameters.. I am trying to pass the parameter boolPlans which contains a 0 or 1 value to another procedure in another form. However, when I run this, I get the error: Microsoft VBScript Runtime error: Wrong number of arguments or invalid property assignment...
  8. jodie

    Confusing Select Expert Criteria

    I type this in my Select Expert in parentheses so it recognizes it is two separate conditions. (Effective Date in Date(2002,01,01) to Date(2002,12,31) and Status = "Committed") and (Effective Date in Date(2002,01,01) to Date(2003,01,06)and Status = "Sold") However, when I...
  9. jodie

    Opening a DLL in Visual Basic

    Hi, I would like to know if there is a way to open up a DLL in Visual Basic. I don't really know if I have the Source code anymore, but I have the DLL file and I want to open it up in Visual Basic so I can see the code. Is this possible?I right clicked on the DLL and did Open with ...chose...
  10. jodie

    Export to Access

    I have Ver 6.0 of Crystal and there is no ODBC - Access option while exporting. Does that mean there is no way to export to Access from Version 6? thanks
  11. jodie

    Export to Access

    I don't quite understand. Are you saying that ODBC is not the right way to export to Access. Ok, then how should I do it? If it does create a new table...how do I open it up and see the contents in Access? I have never done this before and don't know how to do it or what to expect in Access so...
  12. jodie

    Export to Access

    I want to export a report created in Crystal Reports to Microsoft Access. I believe the way to do it is Export....ODBC ?. I am not sure exactly what i am supposed to pick and where it is exporting and saving the report (since I am not allowed to pick a destination). Please help. Also, I have...
  13. jodie

    Select Expert formula with multiple parameters

    Yes, I did. Nothing happens if I click one, except for that that parameter is selected. and if I double click, a circle with a diagonal line appears but i still don't see the Up/down arrows. Thanks
  14. jodie

    Select Expert formula with multiple parameters

    I believe this is so weird. I have 2 people here that suggested I try reordering parameter fields by using the Up/down arrow buttons but I don't have those in the tab at all. When I click...INsert...Parameter field...I only see 4 buttons "edit, new, rename and delete" and I don't see...
  15. jodie

    Select Expert formula with multiple parameters

    But, I don't have any up or down arrow keys there. On the Parameter tab ...the only buttons I have are : "Edit", "new", "Rename" and "Delete" I am using Version 6.0 if that makes a difference. Thanks
  16. jodie

    Select Expert formula with multiple parameters

    I really did try putting those parentheses around all three of my ORs before Mike, and they did not work but now when I tried it again -- it did work. Well, as long as it works -- Thanks a bunch for your help. REgarding the resorting of the parameters, I know this maybe a dumb question...but I...
  17. jodie

    Select Expert formula with multiple parameters

    Hi, I am doing a select expert formula that involves the usage of multiple parameters. I am doing a report where the user wants to display the data for 3 months in the same report. Initially to achieve this I had created 3 parameters (Month, Month2, Month3). The month entered by the user was...
  18. jodie

    Formula with boolean field!!

    Got it! I actually used the store and fetch functions and it works. Thanks a lot Ken
  19. jodie

    Formula with boolean field!!

    I am using Version 6. Is there a way to share subreport data with the main report in Version 6? Thanks
  20. jodie

    Formula with boolean field!!

    Hi Ken, I did a lot of searching in this forum but cannot exactly find how to declare and use shared variables. I was unable to find anything about shared variables in the Help section of Crystal report either. The only thing I see repeated, time and again, in this forum is that article id...

Part and Inventory Search

Back
Top