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

    postal code check

    Perfecto! Thank you so much.
  2. shummy1

    postal code check

    the equation is giving me an error loks like it does not recognize isnumber I am working with crystal 8.5
  3. shummy1

    postal code check

    I need to come up with a formula that will make sure that the characters entered in the postal code field are valid. I am creating a report in crystal that pulls the data from a sequal database. Crystal 8.5 I need to check if the first is a letter, the second a number, the third a letter...
  4. shummy1

    space in text box causing text to move down while typing

    I have a field called company name. User is typing in the company name and uses a space (hits the spacebar) the text in the box moves down a line and you can not see what you have entered previously. I have tried reducing the font and making the text box longer but the same things keeps...
  5. shummy1

    using down arrow to open combo box list

    That worked perfectly on the got focus option. Thank you
  6. shummy1

    using down arrow to open combo box list

    I was trying to play around with that also but could not figure out the correct coe to put into the event. I will try that out.. would that also work in the "on key down" field?
  7. shummy1

    using down arrow to open combo box list

    Need to find a way to have the combo box list open up as soon as a letter is typed into the combo box or when the user hits the down arrow key. The contents of the combo box are loaded from a table with just the customer name.
  8. shummy1

    mutiple tables and data sets from access to be used in VB.net

    I have 6 different tables that need to be used in a windows application. The problems is: I want to load the combo boxs for some of the fields but once every different box has data chosen I want it to update the dataset for its table as well as the dataset for the table where all completed...
  9. shummy1

    multiple tables and data sets in VB Windows app

    Sorry I did not realize this was the wrong forum. I am using Microsoft Visual Basic.net but am building a windows application form that uses an access database. What forum should I be in?
  10. shummy1

    multiple tables and data sets in VB Windows app

    I have 6 different tables that need to be used in a windows application. The problems is: I want to load the combo boxs for some of the fields but once every different box has data chosen I want it to update the dataset for its table as well as the dataset for the table where all completed...
  11. shummy1

    combo box in a datagrid on a windows application VB Form

    I am creating a windows application solution in VB.net. I have the form ready with a datagrid that displays information from a table in and access database. Is there a way to change the fields in the datagrid to combo boxes? I have fields such as Dealer Name .. in access I have the fields set...
  12. shummy1

    VB Query

    Hmmm. OK will try that out if I don't get anywhere with the first plan. Thank you
  13. shummy1

    multiple lines in detail for each record need to supress

    OK I am not sure how to word this one. I am using crystal 8.5 I have a list of customers. each customer number has many orders. I need to creata a formula that will go through the orders and return a Y if there is an NSF charge on any of the transactions per order. The problem is I do not want...
  14. shummy1

    VB Query

    Ok I will try that out. It may be a while before I get back to you as this is a "when I have time" project
  15. shummy1

    VB Query

    Is it possible to populate a combo box with a query and then have the chosen item in the combo box update to a record in a table? The query pulls from the same table that the record will be save in. ie customer name combo box is populated with a query run on the orders table where the query...
  16. shummy1

    year to date and last year to date in Crystal reports

    The serial date formula worked just fine. I am finally on the path to finishing this thing. Thank you -s1
  17. shummy1

    year to date and last year to date in Crystal reports

    I guess your right the user would need to enter the year as well. hmmm I would need to see dec 2004 and 2003 year to date total even though I am running in Jan. In this case I may just go with a date fields and use a "date" parameter. I will wait for your response and then try out a few things...
  18. shummy1

    year to date and last year to date in Crystal reports

    The user is only selecting the month.Or could set it up to choose the end date. What works in crystal is if I change the stprint date option to the last day of the month. But how do I get this to set in the formula for the column instead of having set the print date option. If I set the print...
  19. shummy1

    year to date and last year to date in Crystal reports

    ok that seems to be ok except for one thing. I need to set the month for anytime during the year. The parameter could also be January. Does that get put in anywhere?? -s1

Part and Inventory Search

Back
Top