Search results for query: *

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

Cool - many thanks Steve

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

cool - many thanks again Steve

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

Thanks Greely Thats fantastic - works like a charm much appreciated regards Steve

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