Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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