Recent content by Doraemon

I have a program which exports data from Access to Excel through VBA. But I find the following problem for the Excel file. I have a merged cell called "Remarks", in which its value is very long that it have many rows in the cell. But whenever I open the Excel file, I find only one row...

That's exactly what I want. Thanks a lot!

Yes, I want to ask if I can export data to a text file, what specifically is the coding for opening a file and then write things to it? I want to write a module to output data together with some defined set of characters to a text file. How can I do that? Is that the TransferTextfile can...

I would like to export data to notepad, and wonder if it is possible. If possible, then how can I do it? Thanks a lot in advance.

I am trying to export data to an Excel file, which has a title "Application List" placed across cell A1 to cell E1. I want the title to be align in the center rather than in the left. However, error is found in the indicated line, saying: "Unable to set the HorizontalAlignment...

I would like to ask is it possible to add double quote in a string. Since when assigning value to a string variable, we have to use double quote to quote the text, so I wonder a double quote can be included in the text, so that double quote can be displayed. Thank for your help in advance.

I am trying to export data from a query to an excel file. The following codes work fine. But, I would like to ask is it possible for the system to start writing data to cell A13 instead of A1? Private Sub cmd_export2_Click() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9...

I found my answer from the following thread: thread705-629861 Thank you for your attention.

I would like to export data from Access to Excel, with some formatting done in Excel. When I run the following codes, two errors are found, in which I don't know how to correct them. Private Sub cmd_export_Click() Dim strFile As String Dim xlobj As Object, strExcelFile As String strExcelFile =...

As I am trying to open an Excel for reporting from the Access database, I would like to set the format Excel using VBA. I would like to know specifically what is the coding for mering cells(e.g. D3, D4, D5) into one and then check the "wrap text" property for it. Thank you for help...

I have a textbox named "Remarks" in the form which is bounded to the Text field "Remarks" in a table. My problem is: Text field can only store 255 characters. But the value input in "Remarks" field will sometimes exceed that length. I would like to ask what can I...

Thanks for your reminder. But I would like to ask how to combine two rows into one with a space in between? That means, First Name Tai Man Cecila Ka Man Tin Yan Choi Fan, Mavis Last Name Chan Wong Leung Fung Chan After combinatin as (First Name + space + Last Name): Name Chan Tai Man Wong...

Great! It can help to remove the extra space. Thanks a lot!

I have two columns: First Name & Last Name In the column, Last Name, each value in it has an extra space in front. What I would like to do is to remove the extra space for all values in that column. Originally the column is: Last Name Tai Man Cecila Ka Man Tin Yan Choi Fan, Mavis What I...

Thanks for all who have given help! I finally overcome my problem by refering to the following thread: thread705-659353