Search results

  1. B

    Heading Rows

    Dear mr/mrs, Can someone help me with vba, I use below VBA to export data from Access to excel. I have problem with heading rows, not to be delete please help how ( see photos) Private Sub Command0_Click() ExportToXLS End Sub Public Function ExportToXLS() Dim objExcel As...
  2. B

    Export to workseet name "Data" instead of (sheet4)

    Dear mr/mrs, Please help With below VBA the data from access wil be export to excel with file name DataStaf.XLSX worksheet (sheet4) the data must be export to excel with file name DataStaf.XLSX worksheet (Data) instead of (sheet4) DataStaf.xlsx with worksheet : Data Sheet2 Sheet3...
  3. B

    Export data from MS access to NS Excel from Form

    Can someone help me with vba to export to Excel format (Access 2010). I use below VBA, Export from combobox working fine see(frm_ExportDataExample) but how to export from FORM see (frmToExcel) Private Sub cbo_ContactName_AfterUpdate() Me.cmd_Send2XLS.Enabled = Not IsNull(Me.cbo_ContactName)...
  4. B

    Export from ms Access to Exel

    Can someone help me with vba to export to ms Excel format (Access 2010). I use below VBA, I Need the result in Excel : 1. without Field Name 2. Range("A4")CopyFromRecordset (see attachment) private Sub Command487_Click() On Error GoTo SubError DoCmd.TransferSpreadsheet acExport...
  5. B

    Advanced Search and Export to Excel Spreadsheet

    Dear all, Has somebody got an example database Access VBA Automation Preview Advanced Search and Export to Excel Spreadsheet. Thank you in advance, Bunga
  6. B

    Automatic Datasheet Columns Width

    Please help, I set the new columns width in Datasheet view, then I save and close it. but after re-open the Form in Datasheet mode, the columns width (all columns) returned to previous amount !! What is the solution (with VBA Code Access 2010) for set "ALL columns width" in "Best Fit" due to...
  7. B

    error messages

    Dear mr/mrs, I am getting the attached error on desktop.I've researched the error but I haven't found the solution for my particular situation. My original published database was an .accdb please help me to resolve this issue
  8. B

    Add Data With Combobox

    Dear mr/mrs could you please help me with the following problem : If on Product ID = T100 on Description must be : Tshirt on UnitPrice must be : 15 on Merk must be : W QTY and Color wil be Manually field. Thank you in advance for your help
  9. B

    size form to fit to screen on form load

    I have 4 users with various screen resolutions all using Access 2016. Is there a neat bit of code that will check the resolution on load and re-size. I have tried DoCmd.Maximize with no luck. Any help would be great. Thanks Bunga
Top Bottom