Search results for query: *

bjd4jc, This is just what I have been looking for, but did not find it for hours (many hours) over a period of months! Can this be posted under the heading of something like "Auto expand combobox" or "Auto dropdown combobox." This forum it the greatest. I hope that someday I may become...

johnwm, Thanks for the response. After much more searching and reading, I have made these modifications, but it still prints to the system default printer.[sad] SQLQuery = "SELECT Printer FROM UnpaidSummary " rsUnpaidSummary.Open SQLQuery, dbTransact If Not rsUnpaidSummary.EOF Then vntTemp =...

I need to always use a specific printer to print a report, so I do not need to offer the choice of printers before printing. Here is my attempt: Private Sub Form_Load() Dim pr As Printer For Each pr In Printers Debug.Print pr.DeviceName Combo1.AddItem pr.DeviceName Next pr Combo1.Text =...

I haven't tried this, but just looking at your code, consider this: Private Sub cmdCloseForm_Click() Call ValidateRecord() 'Docmd.Close, acform, "ThisForm" move this End Sub ... Public Sub ValidateRecord() If isNull(Me.field1) Then MsgBox "ERROR" Else MsgBox "No ERRORS"...

That was it! Thanks again. lrott

bjd4jc , I have the same error. I have SP6, and installed 2.8, but still no go. I can use BIBLIO.MDB if I don't update it to Access2000. This my first attempt at ADO, still stumbling. References include MADO 2.8 Library MADO Recordset 2.8 Library. Dim dbInvt As...