Edit
This is the code that worked and I indeed used the .rowsource
Private Sub Command14_Click()
Dim strSQL As String
strSQL = "SELECT DISTINCT Barcode FROM tblRecall WHERE Reqno='" & Reqsearch & "' AND Type='" & Typesearch & "' AND Period=" & Yearsearch
text2.RowSource = strSQL
End Sub
so...
Hi
I have a form with some unbound boxes on it. The user types in one box and the other two they select an option from a drop down box. They then click a button and the 'on click' event runs an SQL statement and returns the result to another text box.
I had this working the other day but then...
Hi
Is it possible to run a SQL query to find a number in a range?
E.g.
I would like to have two fields one field called Reqno and the other barcode and filled as
Reqno Barcode
A1000-A1500 C532101
A1501-A2000 C532102
A2001-A2500 C532103
What I...
Hi
Many thanks for your quick response - works very nicely now.
So even though the select statement starts with a quotation, it doesnt have to end with one or a semicolon for that matter?
steve
Hi
I'm having a problem with the output of my SQL query but I dont know if its a syntax problem or whether I've got it totally wrong - I was hoping someone could have a look at it and perhaps tell me where I'm going wrong
I have a table with four fields - 3 of which are text (reqno, type...
Hi
Many thanks for that - works like a charm.
Could I just ask why you use ampersands instead of * and why * is in quotes and not the whole thing? Or is there a website that explains that - if I understand why I need to do it that way then it'll make me a better SQL wiriter
many thanks again...
Hi
I'm a bit new to SQL and am having a problem with a query. The query is being used to search for a string, however the string has spaces in it.
The query needs to search in several fields.
Example:
Table called Jobs
Field called Job Number
Field called Client
Field called Address
Client...
Many thanks for explaining that step by step - you made it very clear and easy to follow and I'm slowly getting a better grasp of whats going on and how to put it all together.
The code works very well - now I just have to work out why its putting the selections from stainsList into the table...
Hi Greely or anyone else who may read this and can help
The above code works fine but I'd like to get a bit more adventurous
I have two list boxes one called StainsList and the other ImmunoList. I've put in your code above and made the following changes to reflect my listbox
Dim ctl, varItm...
Hi there
This is what I'm trying to acheive and I'm sure its possible but cant quite get my head around it to do it.
I have a form with a multi select list box from which our customers can select a number of items they would like added to their worklist for the day. They then click on a...
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.