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!

Recent content by Bodhi147

  1. Bodhi147

    Build a string for a filter

    That works great, thanks again for the help.
  2. Bodhi147

    Build a string for a filter

    I am checking the state of each row in a checked list box. If the item is checked I would like to filter a datatable by that item. I don't know how to handle if more than one item is checked in the list box. I am trying to build a string value for the filter but it will only filter by the last...
  3. Bodhi147

    Add Hours to DateTime

    That Worked Thanks for the help
  4. Bodhi147

    Add Hours to DateTime

    AddHours gives me 10/27/2005 11:35:00 AM, it adds two days and forgets about the decimal. I need it to add .5 days to the time.
  5. Bodhi147

    Add Hours to DateTime

    I am trying to add hours to a datetime. Not sure what the best way to do this is. If I have 60 hrs (2.5days) and want to add that to todays date 10/25/2005 11:35:00 AM. I need the outcome to calculate not only the days but to add the half day to the time. Thanks for the help
  6. Bodhi147

    Bind data to a drop down in a datagrid

    I have a drop down box that is dynamically populated from other user defined criteria. I want this drop down to appear in a datagrid on the same page. Is there a way to populate a datagrid drop down using data from another drop down outside the grid? Some guidance would be greatly appreciated...
  7. Bodhi147

    Populate drop down in a datagrid

    it is, thanks
  8. Bodhi147

    Populate drop down in a datagrid

    I have a drop down box that is dynamically populated from other user defined criteria. I want this drop down to appear in a datagrid on the same page. Is there a way to populate a datagrid drop down using data from another drop down outside the grid? Some guidance would be greatly appreciated...
  9. Bodhi147

    Printing On Custom Page Size

    I am trying to print a report with a custom page size of 8x7 in Access 2003. I can't find any options that will let me print to this user defined size. I also need a width of 850 and length of 700. Unit: .01
  10. Bodhi147

    Syntax error in Update statement

    My problem was that certain words are reserved and you can't use them. I just put brackets around all of them and it worked. Don't ask me why but it does. Thanks for your help though. SQLStmt = "INSERT INTO Parts ([PNumber], [Grade], [MfgGrade], [Size], [Weight], [Offcuts], [GradeType]...
  11. Bodhi147

    Syntax error in Update statement

    Thanks, but still getting the same error.
  12. Bodhi147

    Syntax error in Update statement

    Update Parts Set PNumber ='03-0412', Grade = '2890', MfgGrade = 'No', Size ='540 x 540 x 1830', Weight =1184, Offcuts = 'Yes', GradeType = 1, FullBlockDivider = 1, BaseGradePart = '03-0136', ProcessCode = '03-5526', NominalInches = '21.5 x 21.5 x 72', Where Index = 73
  13. Bodhi147

    Syntax error in Update statement

    I can't figure out this error, please help. Its giving me a syntax error in my update statement at Set RS = Conn.Execute (SQLStmt) if strIndex = "0" then SQLStmt = "" SQLStmt = "INSERT INTO Parts (PNumber, Grade, MfgGrade, Size, Weight, Offcuts, GradeType...
  14. Bodhi147

    Syntax error in WHERE Clause

    Thanks, worked perfectly
  15. Bodhi147

    Syntax error in WHERE Clause

    Can't fix this error in my Sql statment. Please help Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'. SQLStmt = "UPDATE Drawing_MAIN Set User_ID_Eng ='"+struser+"', Customer_ID...
See more

Part and Inventory Search

Back
Top