Search results for query: *

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

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

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

I have designed a form in which when the user clicks the "Close" button in the top right hand corner, a msgbox will popped up. If user clicks "Cancel" in the msgbox, the form will NOT be closed. As shown below, I have tried: Me.Undo However, it doesn't work. Private Sub...

I have a field named "approver", which is a textbox for storing names of approvers. Each name will be in a new line in the textbox by pressing "Enter" key. I would like to ask is it possible to extract each name back by writing codes? Follwoing is part of my codes: Dim...

I have opened a form (say Form B) from the main form (say Form A). I have writted in Form B: Private Sub cmd_select_Click() ... ...set values to fields in Form A... ... DoCmd.Close End Sub However, when the "Select" button in Form B is clicked, Form A is closed instead of Form B...

I have created a "Delete" button, in which when clicked, will delete all the records in a specified table. However, a message box which is popped up by the system will result for the confirmation of deletion. I would like to ask is there any method for avoid the message box, so that...

I would like to ask if anyone know the correct way for 1.changing the RecordSource in a subform 2.Refresh the subform to show the corresponding data I have 3 subforms in a form, Add_Company_Record_Form (Form) Add_Company subform (subform - add company details) Add_Department subform...

First of all, thanks for your help in advance. I am a new user of VBA in Access, so I am not sure how to declare global variables in VBA in Access. More specifically, I have created many "private Sub_xxx" for all forms in Access. But I would like those forms to be able to fetch and...

I have 3 textboxs with a command button besides each of them on a "add_order_f" form in which when clicked will open the form "search_user_f". After the user has chosen a particular record in the "Search_user_f", the user_code of that record will be extracted into...