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!

Search results for query: *

  • Users: GerardMcL
  • Content: Threads
  • Order by date
  1. GerardMcL

    UPDATE error - too few params

    Hi everybody! strSQL = "UPDATE Tools SET Description = '" & tool_desc & "', Price = '" & tool_price & "', Bought = '" & tool_bought & "', Company = '" & comp_name & "' WHERE ToolID = '" & tool_id & "';" cnSQL.Execute strSQL I try to execute this and always get the same error "To few...
  2. GerardMcL

    Logging in using WA

    Hi, I am trying to connect to a SQL Server using VB6. I have put in name of server and the initial catalog (the name of database I wish to use - this is right isnt it???) But I am having trouble logging in. Is there a way I can instruct it to login using my Windows authentication, without...
  3. GerardMcL

    Refreshing data

    Hi everyone, I have an Access 2000 form. I add an item to a table then refresh the form hoping the changes would be reflected in the subreport I have set up to show table contents. I dont have any of the wizards running so I have hard coded pretty much all of this. The problem is when I...
  4. GerardMcL

    Error 5407 Inserting into a timestamp column

    Hi, I am running a proc in which an INSERT .. SELECT is fired off. One of the columns I am inserting to is of type TIMESTAMP. The value I am inserting is CAST(CURRENT_TIME(2) AS TIMESTAMP(2)) But I keep getting an error back SPL1027:E(L282), Missing/Invalid SQL statement'E(5407):Invalid...
  5. GerardMcL

    CREATE VOLATILE TABLE error

    Hi, I am running a REPLACE PROCEDURE. In the procedure I create a number of VOLATILE TABLES. The syntax looks correct to me but I get an error saying "User is not authorized to use the DDL/DCL/Dynamic SQL statement" Logged in as Admin too. Cant for the life of me figure this out, anyone got...
  6. GerardMcL

    Adding the records from a recordset

    Hi, I have my rs all set up and full of data but cant get more than one item into the checkbox. While rs.eof = False cmbTools.Value = rs("ToolID") rs.MoveNext Wend I know this doesnt work but Im used to VB6 and cant find the AddItem or a similar function here. Thanks for the help!
  7. GerardMcL

    Opening an Access Report

    Hi, I am working with an Access database, and cant find the datareport designer in VB.Net, probably because there isnt one. Can I open a report from the Access database using VB.Net? Cheers, Gerard.
  8. GerardMcL

    TeraData Newcomer

    Hi all, Was hoping someone could point me towards a Teradata tutorial or a site explaining what it is and what it does? Work are changing from SQL to TeraData - hoping to get a heads up. Any help offered is gratefully recieved. Cheers, Gerard.
  9. GerardMcL

    Trying to update DataGrid

    Hi, I am saving a record and trying to update the data in the datagrid, BUT alas things are not running smooth and I havent learnt all the errors yet. Heres my code Dim da As OleDbDataAdapter Dim dt As DataTable Dim cn As OleDbConnection Dim cmd As OleDbCommand...
  10. GerardMcL

    Export to Excel

    Hello, Again the switch from VB6 to VB.Net is giving me problems. I was wondering how I could export a RecordSet and enter it onto an Excel Sheet. A link to a tutorial or any code you have would be appreciated. Thank you very much.
  11. GerardMcL

    Problem working with Module

    Hi, I am tying to access a datagrid from the module but I am having problems. I have tried just dgTools.DataSource = dt but no go. I have tried Form1.dgTools & Form1.Controls(dgTools) Im too stuck in my VB6 ways. Any help as always is greatly appreciated.
  12. GerardMcL

    Refresh DataGrid

    Hi, I have a form with a DataGrid showing the contents of Table1. Below this we have text boxes for entering Data into Table1, when I click the Save button I execute the INSERT statement and then DataGrid1.Refresh() - Doesnt show the new Information Set up the datasource again - Doesnt show...
  13. GerardMcL

    Execute an INSERT statement.

    cmd = New OleDbCommand("INSERT INTO Tools (ToolID, Description) VALUES ('" & varToolID & "', '" & varDesc & "')", cn) cmd.ExecuteNonQuery() cmd is an OleDbCommand I have tried this an it doesnt work. What is the correct method of executing an INSERT statement ( and UPDATE and DELETE...
  14. GerardMcL

    DataReport Designer in VB.Net

    Hi, When working with VB6 I used the Data Report Designer, but cant find that capability in VB.Net. Am I being blind? Do I need to reference something? Dont tell me there is no report function, please!
  15. GerardMcL

    Selecting from Datagrid.

    HI, I want to select a row in a datagrid and transfer that info to text boxes. In VB6 I would have used DataGrid1_RowColChange() and then txtBox1.Text = DataGrid1.Col(1).Text But these options arent in VB.Net, has anyone any helpful tips or links. Incidentally anyone knowing of a website that...
  16. GerardMcL

    Filling DataGrid

    Hi, cmd = New OleDbCommand("SELECT s.Title + '. ' + s.FirstName + ' ' + s.LastName AS Staff, th.Location1, th.Location2, th.Date FROM ToolHire th INNER JOIN Staff s ON th.StaffID = s.StaffID WHERE th.ToolID = '" & ToolCode & "';", cn) dr = cmd.ExecuteReader DGrid1.DataSource = dr This is what...
  17. GerardMcL

    Using Parameter in OleDb command

    Hi (again), Sorry about all the posts but I am eager to get a handle on this ADO.Net stuff. I have executed commands and filled a combo box - was now hoping to take selected value and execute a further sql statement. E.g. ToolCode = Strings.Mid(cmbTools.Text, 1, 5) 'Returns correct Value...
  18. GerardMcL

    Read from Recordset in VB6

    Hi, I have been using VB6 up until recently and have switched to VB.Net. What Im trying to do is populate a combo box from a recordset but I cant get the same to work in VB.Net. E.G. strConn = "Microsoft.Jet.OLEDB.4.0;DSN=CorlinDSN;" 'Wanted to use an ODBC Connection & Access dbConn.Open...
  19. GerardMcL

    VB.Net to Access

    Hi, Ive recently switched from VB6 to VB.Net. In VB6 I set up my dbConn As ADODB.Connection then my connection string Provider=MSDASQL;DSN=SysDSN; But I have tried this in VB.Net and keep getting a problem I have Provider=Microsoft.Jet.OLEDB.4.0;DSN=CorlinDSN; I have a .Net book that is...
  20. GerardMcL

    MISSING: XLODBC.xla

    Hi, First of all apologies if this is wrong VB forum. Have a program that runs in Excel and I get an error when it tries to run SQLOpen() function Cant find project or library So I checked and found that XLODBC.xla had to be referenced so I went to references but it is checked and listed as...

Part and Inventory Search

Back
Top