Search results

I have the following code to go to a record from a list box. Option Compare Database Private Sub List15_DblClick(Cancel As Integer) 'Requires reference to DOA 3.6 Dim db As DAO.Database Dim rst As DAO.Recordset DoCmd.OpenForm "mainform" Set rst = Forms!mainform.Recordset.Clone...

Hi, I am writing a database which will be on more than one computer. I want to be able to import/export any modifications that the user has made to/from a floppy disk/ flash drive or a file on the hard drive. I want this done from two buttons on the switchboard (an import and an export button)...

A solution Thank you for your advice. After many extensive searches on google I found a solution: If Me.FilterOn And Len(Me.Filter & "") > 0 Then DoCmd.OpenReport stDocName, acViewPreview, WhereCondition:=Me.Filter Else DoCmd.OpenReport stDocName, acViewPreview End If...

thank you very much for your prompt reply. i have looked through the attached file, and I understand that: DoCmd.OpenReport "rptSuppliers", acViewPreview, opens the report rptSuppliers in preview view and that: , , "SupplierID > 5 and CompanyName like 'S*'" specifies that the filter brings...

Here is the problem: I have a form where the user selects a value from an unbound list box. The selected value is used to filter records. The results are shown on a second, Main Form. The filter is applied through VB which was generated through a wizard. On the second form, there is a print...

Hi, I am setting up a simple database of clinical psychologist supervisors that includes fields like which theoretical approach they take. The users of this database will want to select different criteria, and then show all the supervisors that fulfil this criteria. At present, I have a...