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!

  • Congratulations TouchToneTommy 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. jodie

    Formula with boolean field!!

    Hi, i am doing a report where I have to get a count of all the cases of a sales rep by coverage. For example: Sales Rep: Joe Broker Case 1 LF.............True MD ............False RX..............True Case 2 LF.........True MD.......True RX........False Case 3 LF.........False...
  8. jodie

    sorting alphabetically

    My report is grouped by Broker Name and then by Office Name. The Office Name is sorting alphabetically, however the Broker Name is not. If I go into Sort and see my options, the Ascending and Descending options are grayed out. What can I do to sort my Broker name alphabetically also? I do...
  9. jodie

    Average (fields with 0 values are also counted)

    Hi I am trying to calculate the averages of fields called "Estimated Transfer" and "Estimated Deposit" My problem is that I only want to average the fields where the value > 0. Even if I suppress the field, the field is still counted. For eg. Estimated Deposit...
  10. jodie

    Formula for Select Expert

    I am doing a report from a database which has fields: Proposal No. Version NO. etc More than one proposal can have the same Proposal NO. ; but they have to have different version No. There is no limit of versions a proposal can have. The greatest version no. dentoes the final proposal. Ex...

Part and Inventory Search

Back
Top