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 Mike Lewis 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: eilob
  • Order by date
  1. eilob

    Moving a database from one server (SQL 2000) to another (SQL 2008)

    I havent done this before, could you please let me know the steps, thanks
  2. eilob

    Moving a database from one server (SQL 2000) to another (SQL 2008)

    I was told because they are different versions wont work. I have a back up done already. I am just waiting for IT to transfer it to the new server so I can restore it... Hopefully will work Thanks
  3. eilob

    Moving a database from one server (SQL 2000) to another (SQL 2008)

    Hi all, I have a database in SQL 2000 that has to be moved to another server in SQL 2008. Please if someone could tell me the best approach to migrate this database. Thanks Eilob
  4. eilob

    Moving a database from one server (SQL 2000) to another (SQL 2008)

    Hi all, I have a database in SQL 2000 that has to be moved to another server in SQL 2008. Please if someone could tell me the best approach to migrate this database. Thanks Eilob
  5. eilob

    Excel VBA Dropdown

    Hi, The dropdown is a control toolbox...
  6. eilob

    Excel VBA Dropdown

    Hi all, I need to set up the properties of a dropdown list equal to nothing, so that when I open my workbook nothing is selected. I dont want anything to show on the dropdown.. So I need to place this code on a form so will have to specify the name of the Sheet first and then the name of the...
  7. eilob

    VBA excel Help

    Hi all, I am working using vba in Excel. basically I have a form with two sections and both contain check buttons. I need some code to be able to get all possible combinations and paste a range of cells if certain check boxes are selected. Please if you could help me with some type of structure...
  8. eilob

    VBA excel Help

    Hi all, I am working using vba in Excel. basically I have a form with two sections and both contain check buttons. I need some code to be able to get all possible combinations and paste a range of cells if certain check boxes are selected. Please if you could help me with some type of...
  9. eilob

    GridView Updatecommand (VS 2005 asp.net c#)

    Have been working on the code to update a GridView in Visual Studio 2005. Have the AutogeneratedEditButton set to true. When I run it nothing happens doesnt give me any error but is not updating. In the aspx page I have a the the following code <%@ Control Language="C#" AutoEventWireup="true"...
  10. eilob

    GridView DeleteCommand Asp.net

    Not sure how to do this, do you have any examples? Thanks
  11. eilob

    GridView DeleteCommand Asp.net

    Thanks Mark, that works now Now my next problem is the UpdateCommand, nothing happens when I update. Retrieves the same data without any change. Any ideas? UpdateCommand="UPDATE [TBL_FAQ1] SET [FormInserted] = @FormInserted, [Area] = @Area, [Topic] = @Topic, [Issue] = @Issue, [Update] =...
  12. eilob

    GridView DeleteCommand Asp.net

    Hi all, I am using Visual Studio 2005, I have created a web application that uses a Grid View with a Delete, Update, insert commmand field. But I am getting the following error when I try to delete a record: Must declare the variable '@FAQ1ID'. Description: An unhandled exception occurred...
  13. eilob

    Query in Access (Transpose)

    THANKS A LOT PHV That works great!
  14. eilob

    Query in Access (Transpose)

    Any examples? Had tried that but cant get that layout.. Cheers
  15. eilob

    Query in Access (Transpose)

    Hi All, I have the following table: Week1 Week2 Week3 Week4 Week5 Week6 Week 7 0.49 0.48 0.46 0.45 0.49 0.48 0.46 and need to change it to this layout: Week Margin Week1 0.49 Week2 0.48 Week3 0.46 Week4 0.45 Week5 0.49 Week6 0.48 Week7 0.46...
  16. eilob

    Functions in Access

    Thanks all for your help!!! Rgds Eilob
  17. eilob

    Functions in Access

    Hi all, I need to take the first two or three characters from a text depending if the hour has two or three characters, there is any function in access that will take the first characters until finds this symbol (:) or will delete the last four characters? 78:39:06 78:08:48 195:06:22 71:24:16...
  18. eilob

    Datatype for hours over than 24?...

    Thanks for your help!
  19. eilob

    Datatype for hours over than 24?...

    Hi Golom, Instead of the actual value would this work specifying the actual field? Dim TValues() as String TValues = Split([Elapsed_Time], ":") Hours = TValues(0) Minutes = TValues(1) Seconds = TValues(2) Should I use a module for this?? Thanks
  20. eilob

    Datatype for hours over than 24?...

    Thanks for that Apologies about this, but where should I place this code?

Part and Inventory Search

Back
Top