Search results

I have created a query programmatically with a field names like; "Name", "Address", "City", "Field3", "Field4", "Field5". The field names are programmatically changed. At every time, all the fields name "Field" have no data. Then the fields, name like "Field" should be deleted and query should...

I have created a report like [rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb]. In this sample, report fields are selected by a combox. But I want to load the listbox from a specified table fields on form load to select report fields instead of combo selection. Any...

I have created a Allen Browne's type search form and result exported to excel format for more flexibility using following vba. Dim qdf As DAO.QueryDef Dim strWhere As String Dim strFile As String Const strcStub = "SELECT tblEquipment.*FROM tblEquipment" & vbCrLf Const strcTail = "ORDER BY...

I have created Allen Browne search criteria form. In the main form, there are many field like text, number, currency and Year. Year is selected by drop down combobox in the following vba and works fine. Dim strYears As String, intCounter As Integer For intCounter = 0 To 20 strYears...

I created an Equipment Database and a search form using Allen Browne Search Criteria sample DB. What I want is to create a custom field select report, based on the filtered form records. How do I create a form with multi select field list to select report fields? Can anyone to help me with a...

I am creating a database relates to hospital medical equipment using Access 2003. Using VBA code, I want to generate an AutoNumber for each Equipment falling under different Equipment and different Hospital. Ex: DGG-ECG-001 DGG-ECG-002 DGG-XRY-001 WBH-ECG-001...