Search results

  1. B

    how to Delete query fields

    Thanks for your reply. I'll try to rethink of it. If you could please send me the correct vb code or sample for the above requirement.
  2. B

    how to Delete query fields

    UG added Code Tags Private Sub Form_Current() Dim dbs As Database, qdf As QueryDef Dim fld As Field, rst As Recordset Dim tbl As String ' Return reference to current database. Set dbs = CurrentDb ' Return reference to Employees table. Set qdf =...
  3. B

    how to Delete query fields

    Thanks for all your ideas. I'll explain briefly what I did so far. I wanted to create a search form and needed to take excel output with filtered results and selected fields. Then, First I created a search form like Allen Browne's with about 25 search criteria. As the high number of search...
  4. B

    how to Delete query fields

    Thanks for your quick reply. That's not work for me. It's only for the specific field name(s). Really I want to define field name like "Field" instead of Field1, Field2, Field3 like that.
  5. B

    how to Delete query fields

    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...
  6. B

    Select report fields

    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...
  7. B

    Excel report with search criteria as headings

    thanks for your quick reply with vb code corrections. I am newbie to access vba and copied the Allen Browne's search form and above codes from an example. I haven't physically created a report and put a button to export the filter form to excel format. Therefore, Step by steps would be highly...
  8. B

    Excel report with search criteria as headings

    I have attached the Excel report that what I want. Is it possible to do it?
  9. B

    Excel report with search criteria as headings

    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...
  10. B

    Question Search Criteria

    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...
  11. B

    Select Report Fields based on filtered form

    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...
  12. B

    Generate an AutoNumber for falling under two different categories

    Thank you very much for your reply. This is exactly what I wanted. According to your example the "unique ID Number" is stored in an unbound text field. But I need to store these ID numbers in a table. So please advice me how to do it? or According to your example, how to change unbound...
  13. B

    Generate an AutoNumber for falling under two different categories

    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...
Top Bottom