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...
Andrzejek: Thanks for the suggestion, it helped me to clean up the code by several lines.
dhookom: The query this pulls from did, in fact, reference two date fields on the form. I'd put them in there to reduce the total number of records the built query had to evaluate. When I removed those...
Yes, here's how the second one is set (pretty much the same as the first).
Private Sub lstStats_Click()
Dim SelectedValues As String
Dim frm As Form
Dim varItem As Variant
Dim lstItems As Control
Set lstItems = Me!lstStats
For Each varItem In lstItems.ItemsSelected
If SelectedValues > ""...
I made the 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...
Andy:
This is actually the way I had it structure the query first, with the same result.
I'm having the listbox update a text field each time an item is selected or deselected to create the code which will be pulled by the VBA that builds the query. Here's one of the two:
Private Sub...
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
I'm using VBA to build a query based on responses to a number of fields on a form, two of which are listboxes. When the code executes, it appears to build the query correctly, but I get the subject error every time.
I've set a watch on the query, and when I copy the watch value and paste it...
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...
I'm using Visual Studio 2008. I have a form which has a DataRepeater and a ReportViewer displaying a report which uses the same table in the local DataSet that the DataRepeater uses. When I load the form, I fill this table. The DatarRepeater displays the data correctly, but the ReportViewer...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.