Search results

Ok not as solved as I thought having problems getting the SQL statement right any ideas? Private Sub butDisplay_Click() On Error GoTo Err_butDisplay_Click Dim db As DAO.Database Dim varList As Variant Dim strSQL As String Dim qdf As DAO.QueryDef Dim strCriteria As String...

perseverence seems to have got me through in the end managed to produce the following, seems like a clunky way of doing things though any advice on neatening it up a bit? Option Compare Database Option Explicit Private Sub Command2_Click() On Error GoTo Err_Command2_Click Dim db As...

ta for the quick reply I'm guessing I need something like qdf.OpenRecordset where I've got qdf.Exercute? but then it does nothing think I'm missing something here I'm only trying to get it to open for now to do a visual check that it's pulling through the expected results. So far today...

It's been a long time since I've used Access but I now find myself producing a database at work and i'm provided with Access 03 I'm currently trying to run a query from a value selected in a list box which I will want to enable multiselect on but as I can't even get it to run on one value I...