Search results

Dear Orion, It's working, Well Done I want to thank you for all the support and concern. Bunga

Dear Orion, Please help, Private Sub Command0_Click() ExportToXLS End Sub Public Function ExportToXLS() Dim objExcel As Excel.Workbook Set objExcel = Workbooks.Add() Dim objSheet As Excel.Worksheet Set objSheet = objExcel.Worksheets.Add() objSheet.Name = "Data"...

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

Dear Ranman256, Thank you is working :)

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

See below the excel file

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

Dear The_Doc_Man, Thank you for your advice

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

See video link https://www.youtube.com/watch?v=vwnLZHIc31c

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

Wat I Mean about " Best Fit " is zie attachments !

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

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

Dear Paul, Thank you for your help, do you know how to Clear an Access combo box for entering the next record ? Thank you in advance for your help

I'm beginner in ms access, I was wondering if you could help me ! Thank you

Thanks for the reply. I tried both code u mentioned: =ComboName.Column(2)....this code made the Description text box auto populate but did not save the value in the Main Table. Please help

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

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