Search results

  1. D

    Export Filtered Form Data to Excel

    Hey JHB, Many thanks! You are correct. When I interviewed my customer that will be using the database, it was confusing. Thank you for your suggestion. It will give them the option to use it by click on the checkbox. You're the man!
  2. D

    Export Filtered Form Data to Excel

    hi JHB, I need your expertise once again. Is it possible to have one search field in the Form be able to lookup multiple columns. For example I want to lookup if Company A is present in Vendor, FKA and DBA fields. Thanks for any assistance you can provide. Many thanks!
  3. D

    Export Filtered Form Data to Excel

    Hey JHB, you're the man. Thanks!! Much appreciated. Can I buy you a drink? Private msg me if there is a way. Thanks again!
  4. D

    Export Filtered Form Data to Excel

    Not sure I am doing this right, JHB. Please see below. Thank you very much for your assistance. Private Sub cmdQUERY2_Click() Call Send2Excel(Forms!VendorListing, "VendorList") End Sub Public Function Send2Excel(VendorListing As Form, Optional VendorList As String) ' frm is the name of the...
  5. D

    Export Filtered Form Data to Excel

    Thanks JHB. I think I may have stated what I was trying to do incorrectly. I am trying to create a command button that will only export the results of the search and the columns selected or checked in the "HIDE/SHOW" fields.
  6. D

    Export Filtered Form Data to Excel

    Attached is a picture of the columns selected in 'HIDE/SHOW' button.
  7. D

    Export Filtered Form Data to Excel

    Hi JHB, I hope you are doing well. I am in need of your expertise again. I have a 'HIDE/SHOW' button on my Form that allows the user to select the columns they want to see or hide. The 'Export Query' button allows the user to export the results of their search. If the user decides to show...
  8. D

    Export Filtered Form Data to Excel

    Thanks so much, JHB. You're the man. That is awesome. Can you remove the attachment? I truly, truly appreciate all your time and efforts with my database. :)
  9. D

    Export Filtered Form Data to Excel

    Hi JHB - One more thing, there are blank records in both the 'Drug Manufacturer' and 'Device Manufacturer' columns. When the blanks are selected, it is possible for the blank records to come back in the results. When I select the blank field in 'Drug Manufacturer' no records return in the...
  10. D

    Export Filtered Form Data to Excel

    Hi JHB - Thanks for responding. If I select 'Intracompany' in the Drug Manufacturer field and 'Contract Manufacturer,Repackager/Relabeler' the results come back with any records that matches both criteria. My question is it possible if you select any of the drop down listing fields that it will...
  11. D

    Export Filtered Form Data to Excel

    Hi JHB - Attached is the zipped database. Thanks for any assistance you can provide. I truly, truly appreciate your time and assistance!! :):)
  12. D

    Export Filtered Form Data to Excel

    Morning JHB - Thanks for responding. I tried the VB code. It works if you select from one of the list box but if you select from both list boxes it doesn't work together. Any thoughts?
  13. D

    Export Filtered Form Data to Excel

    Good Evening Everyone: I need some help with a split form I am creating in MS Access. I have two list boxes named Vendor1 (ListVendor) and LICENSE TYPE (ListLicenseType) that I would like to search by vendor. My problem is that if I use one of the "For Each" the search works but I am trying...
  14. D

    Export Filtered Form Data to Excel

    I figured it out and it works now. Thank you, JHB & ridders. Private Sub cmdSearch_Click() ''Purpose: Build the criteria string form the non-blank search boxes and apply to the form's Filter. Dim strWhere, task, SearchDateRange As String 'The criteria string...
  15. D

    Export Filtered Form Data to Excel

    I am having issues with another problem. I created an on click command button to clear the fields in my form after a search. When I click the clear fields button and perform another search by entering criteria in the fields I get an error message - Runtime error 3075. Thanks for any...
  16. D

    Export Filtered Form Data to Excel

    I figured it out and it works. Public Function Send2Excel(VendorListing As Form, Optional VendorList As String) ' frm is the name of the form you want to send to Excel ' strSheetName is the name of the sheet you want to name it to Dim rst As DAO.Recordset Dim ApXL As Object Dim...
  17. D

    Export Filtered Form Data to Excel

    My form's name is "Vendor Listing beta - CombinedV2" and my command button is: "cmdExport." The function name is "Send2Excel" The code I have to call the Function on the OnClick event of the button is: Call Send2Excel(Forms!"Vendor Listing beta - CombinedV2", "strSheetExport"). Public...
  18. D

    Export Filtered Form Data to Excel

    Hello All - I am also having difficulty with exporting data from a filtered Access split form to Excel by click on a command button.
Top Bottom