Recent content by oerris

Hi sydeburnz. It looks to me as if all you need to do is ommit the part of the query that filters out the single store (masterStoreID and perhaps DepartmentID). Your query should then lokk like this: SELECT Inventory_ProductTable.Artist, Inventory_ProductTable.Title...

Hi haveli1 If the text you are trying to append to the sql expression is the last part you are missing af ";" in the end. If (VarType(Me.dnum.Value) = vbString) Then query4 = query4 & "AND [All Data Table].[Docket No] =" & Chr(34) & Me.dnum.Value & Chr(34) & ";" Ørris.

Hi Scarecrow If you take a look at the attached DB (Access 2k format) I think you will find what's needed to get started. The solutions can be optimized in many ways but I'm guessing your main concern is to get on with things. Have fun. Ørris.

Hi arnhemb You could try the attached code. I haven't had a change to check it, but it should get you started. Private Sub Something() Dim sSQL As String Dim sProgramID As String Dim sProgramName As String On Error GoTo ErrorHandler Set rs = New ADODB.Recordset...