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

    Date Formula

    Okay - I think I figured out what was wrong. The calculated days should be a SUM and I believe it's only pulling the last field in the report in. That being said. I fixed my formula so that I am now calculating correctly. datevalue({EMPLOYEE_1.New_Rehire_date})-sum({@Calc_Days}) WooHoo...
  2. Jewel142

    Date Formula

    The {EMPLOYEE_1.New.Rehire_Date} is a date field. I validated my formula in Excel for example: Rehire Date 7/19/2011 - Days previously Worked of 320 should give me a returned date of 9/2/2010 instead I am getting a date of 02/19/2011 which isn't even close
  3. Jewel142

    Date Formula

    I even tried using the DateAdd function: DateAdd("d",-{@Calc_Days},{EMPLOYEE_1.New_Rehire_date}) but it still doesn't won't work. Thanks!
  4. Jewel142

    Date Formula

    I am trying to calculate a date in Crystal. What need to do is calculate number of days previously worked and minus from their rehire date calculate a combined length of service date. My calculation is working properly but I can't get the date to calculate correctly. Here is my formula...
  5. Jewel142

    Newbie to Sql Subqueries

    Thank you - it worked! Jewel
  6. Jewel142

    Newbie to Sql Subqueries

    I am new to SQL and I'm having a hard time with getting the right results from my subquery. I am reporting off of three tables, Vendors, Invoices and Line Items and I am trying to get the results for each invoice that has more than one line item in the InoviceLines Table. Here is my code so...
  7. Jewel142

    Key Press Event for Input Box

    Thanks I'll give that a try!
  8. Jewel142

    Key Press Event for Input Box

    Hi Everyone, Is there a way to limit the types of characters in a user input box (not a text box). I have a text box that I use for capturing social security numbers and have a key press event set up so that they can only enter numbers. However, if they enter less than 9 characters or skip...
  9. Jewel142

    PDF to Word

    Try opening the file in PDF and they copying the text directly from the pdf file (you should have a flashing cursor and should be able to highlight and copy your text). Then just paste it into your word document. This also works if you need to put it into excel and then use your text to...
  10. Jewel142

    Trouble with Array overwritting itself

    ...Private A_FIRSTNAME(15) As String Private A_LASTNAME(15) As String Private A_SSN(15) As String Private A_HRLYRATE(15) As String '***PRIVATE SUB PROCEDURE TO ADD LINE ITEMS TO ARRAY*** Private Sub Add_To_Array() Dim EE_NBR As Integer Dim i As Integer...
  11. Jewel142

    Convert to Euros

    Yes it did! Thank you so much! Is there a really good reference book out there that you can recommend? I've looked at a couple of them but I'm not sure which one to get. Thanks again and have a great day! Jewel
  12. Jewel142

    Convert to Euros

    Thank you so much. I will let you know how I make out. Thanks again and have a great day! Jewel
  13. Jewel142

    Convert to Euros

    Hi Everyone, I have a program that I need to convert a dollar amount to Euros. I've done the background calculations computing from dollars to euros. I can get the proper amounts to show up in my listbox items but I'm having a hard time figuring out how to swap the decimals and the commas...
  14. Jewel142

    Textbox size change

    This may be a long shot but have you tried subreports?
  15. Jewel142

    Textbox size change

    Can you provide us with a print screen so that we can see what you are trying to accomplish?
  16. Jewel142

    Textbox size change

    So it's not a ratio of one to one i.e.; one border text box assigned to one memotype dbaseField? Are the multiple border text boxes being used as dividing lines that need to grow?
  17. Jewel142

    New to VB Need help with List Boxes

    Thanks for your help! I'll let you know how I make out. Have a great day! Jewel
  18. Jewel142

    Textbox size change

    Okay if I understand correctly, You have database field we will call dbaseField and a text box that you use to as a left border to that dbaseField. In design mode, drag your dbasefield into your blank text box, the field will then show up as {dbaseField Name} in your text box. Go into your...
  19. Jewel142

    Textbox size change

    Is it a textbox, a label or both? Is your line spacing set to multiple? Do you have your can grow selected with 0 (for unlimited). Or is is that you want the last line of text to be underlined and that needs to vary depending on length? Is this being pulled from a database or do you allow a...
  20. Jewel142

    New to VB Need help with List Boxes

    Hi Everyone, I am new to VB and need help with a project. I have a user-interface that has a list box with employee's names added to it (Debbie, John, Jim, etc) which are defined as strings. On my form, there is a select single name button and select multiple name button. There is also...

Part and Inventory Search

Back
Top