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: *

  • Users: cdck
  • Order by date
  1. cdck

    getting "Run-time error '3061' Too few parameters response on a specific query - can anyone see

    dhookom: This is a front-end which multiple users will be accessing, possibly at the same time. If I set the pass-through query and then pull from it in each user's instance of the database as they execute the process, will it cause conflicts if it happens to fire at the same time? Is it...
  2. cdck

    getting "Run-time error '3061' Too few parameters response on a specific query - can anyone see

    ...I basically removed the WHERE clause, moving it to the start of the built query, thus: Dim strSql As String strSql = "SELECT * FROM qryTSAcomments WHERE efDate BETWEEN #" & dtFrom & "# AND #" & dtTo & "#" and built on from there (without the efDate filter here, I would have gone with...
  3. cdck

    getting "Run-time error '3061' Too few parameters response on a specific query - can anyone see

    ...section of code to deal with the option to filter based on status. With both options set to be used, I run it again and get this Query: SELECT * FROM qryTSAcomments WHERE ([tsStatus] = 'I' OR [tsStatus] = 'M' OR [tsStatus] = 'A') AND ([Dep] = 49 OR [Dep] = 54 OR [Dep] = 70); Same results...
  4. cdck

    getting "Run-time error '3061' Too few parameters response on a specific query - can anyone see

    ...changes recommended by dhookom and got the same results. With the settings in place on the form this time, the Immediate window showed: SELECT * FROM qryTSAcomments WHERE ([tsStatus] = 'I' OR [tsStatus] = 'M' OR [tsStatus] = 'A'); Still "Too few parameters. Expected 2." in the error...
  5. cdck

    getting "Run-time error '3061' Too few parameters response on a specific query - can anyone see

    ...to run the report: Private Sub cmdPull_Click() Dim UserName As String UserName = GetUserName() Dim strSql As String strSql = "SELECT * FROM qryTSAcomments" Dim WhereAnd As String WhereAnd = " WHERE " Dim strANDS As String strANDS = "" Select Case...
  6. cdck

    getting "Run-time error '3061' Too few parameters response on a specific query - can anyone see

    I have, too, which is why I tried pasting it into a query and running it that way. Usually, if you do that, you get a more direct error response which tells you which field you typed wrong. But in this case, it runs just fine. Cheryl dc Kern
  7. cdck

    getting "Run-time error '3061' Too few parameters response on a specific query - can anyone see

    ...a watch on the query, and when I copy the watch value and paste it directly into a new query, I get valid results. Here is the watch value: SELECT * FROM qryTSAcomments WHERE ([tsStatus] = 'I' OR [tsStatus] = 'A' OR [tsStatus] = 'M') AND ([Dep] = 40 OR [Dep] = 70 OR [Dep] = 90); It tells me...
  8. cdck

    Translating data received over serial Encoding = System.Text.Encoding.GetEncoding(1252)

    That gave me a thought. When I first programmed the code to send the data to the device, I had difficulty getting it to send correctly; although the string was hex according to vb formatting, it wasn't hex according to the receiving device. That's why I had to use the special encoding on the...
  9. cdck

    Translating data received over serial Encoding = System.Text.Encoding.GetEncoding(1252)

    I'm communicating over a serial port to a piece of equipment which needs to receive the data in Hex format. Recently, a requirement came up to not only send the commands, but receive responses and parse them. I have been successfully sending commands for some time, and I am able to capture the...
  10. cdck

    vb.net - pass parameter to rdlc, report not defined exception

    I'm working in Visual Studio 2012 on a vb.net winforms project originally created in Visual Studio 2008. Since converted, the .rdlc files have started giving me issues, but I thought I had cleared them up with an updated reference. Currently, I'm working on passing two parameters from a form...
  11. cdck

    Visual Studio designer throwing an error which is in error

    I should note that on each form, along with the undeclared error listed above, I also get an error which indictates that "value does not fall within the expected range". But this error does not direct me to a line of code where the issue arises. I have no idea how to figure out the cause if I...
  12. cdck

    Visual Studio designer throwing an error which is in error

    I'm working on a vb.net windows forms application using Visual Studio 2008. I have two forms which have tab controls on them. On each tab control, one of the tabs has a reportviewer. On both forms, when I first open them in design view, I get an error telling me that the reportviewer control...
  13. cdck

    CrystalReportViewer showing blank report

    ...Dim SQLstring As String SQLstring = "SELECT SN, PartRev, Contract, MfrDate, Model, Description, MadeIn, WhichLabel, '*' + SN + '*' AS SNbarcode FROM SerialSNsOut WHERE MachineName = '" & MachineName & "';" Dim con As System.Data.SqlClient.SqlConnection con = New...
  14. cdck

    visual studio 2008 - datable miscommunication?

    jebenson: I actually tried that while I was waiting for a response, but got the same error. I also tried setting the value of d_Hist("Remain") into a variable and then using the variable to set the two r() values, with the same result. Thank you very much for taking the time to try to help...
  15. cdck

    visual studio 2008 - datable miscommunication?

    Solved. Although the error was thrown at the line listed above, it appears that there was actually something wrong with the control on the datarepeater. Dropping the datasource for that control back into it did not fix the issue, but deleting the control entirely and adding it again did. I've...
  16. cdck

    visual studio 2008 - datable miscommunication?

    I have a table in my dataset which is used to locally store and process a set of records for use with a form. The table is LocalInfoTables.TREEpartsTreed. I have a function running to update the data in that table based on a query tied to a SQL server. The function runs down one row at a time...
  17. cdck

    Problem attempting to fill Datatable from a shared function

    Thank you, softhemc, it worked beautifully. Cheryl dc Kern
  18. cdck

    Problem attempting to fill Datatable from a shared function

    I have a DataTable in my local tables which I fill successfully from a button-click on a form. I now want the exact same process to fire from another form, so I took the Sub which fills the table and moved it to a shared functions module, which I use to store functions/subs I need to fire from...
  19. cdck

    Automatic Revision # Update

    You could create Before Update or After Update events for the specific fields which should trigger a revision bump to update the revision. You'd need to store the revision in data somewhere, as well. The table you'd want to use would depend on how far down the data changes need to impact...
  20. cdck

    DataRepeater controls are blank

    I have a DataRepeater attached to a table which I clear and refill each time text in a TextBox on the main form changes. It appears the the table is being managed correctly, as you can see that when the form opens, the DataRepeater is nothing but a blank border, and as you change the text...

Part and Inventory Search

Back
Top