Recent content by ScottXe

Currently I manually export a query result to an Excel file. I would like to create a button that is clicked to generate an excel file with the query result. How could I start with?

Thanks for your hint! I found the setting in the BrowseForFileClass in red as below. It works fine. Is it possible to put the setting in the Browse event? I can use the same class for other application with different starting directory. Option Compare Database Option Explicit ' Thanks...

Currently the starting director is c:\Documents. I would like to change to other one. Is there any variable of OpenDlg to set this parameter or elsewhere? :confused: Your advice is appreciated. Thanks! Private Sub cmdBrowse_Click() On Error GoTo Err_Handler Dim OpenDlg As New...

It looks beyond my capability! However, I love to try it during this weekend to see what I can learn from you. Many thanks for your advice!

I open the file and see your design - perfect but I may not need Admin approval and just supervisor approval and disapproval - the application on one line only. However I could not see the operation - no password! I have no idea how to copy it into my spreadsheet and necessary configuration...

Great idea! Does it require programming? If not, I appreciate how to set up the pop-up User form. Tks!

I would like to create an approval column in a spreadsheet that contains holiday applications. My initial idea is to have a locked column with password protected. However, it has more than one person to approve for different sections. Any idea to accomplish this requirement? Thanks!

Done many times without success.

I had upgraded my Samsung ATIV Smart PC Pro 700T to Windows 10 successfully and the touch pad on keyboard was working correctly. Yesterday, I reset the pc and the pointer was working briefly at the beginning and then the touch pad malfunctioned. Can someone advise me how to fix this issue. Thanks!

Surprise to know it but glad to hear it works. However the system still states not a number field and captured the format. It happened on two pcs. Which setting will affect the result? Pls check the attachment and advise possible deviations. Thanks!

Hi arnelgp, I have attached an example file. On the table of Access file, there are two number fields. In the query, I have modified one of number field using Val() function. The exported Excel field contains General format like the one without modification in query. Looking forward to...

Thanks for your suggestion! I tried it but strange: no change at all - still in General & wrap text format, not number format.

Yes, there are empty values for some lines. In addition, some users put 0 as no value instead of leaving it blank. I made a trial test with your suggestion by adding one more field (IIf(IsNumeric([Ttlweight]),Ttlweight,0) AS Ttlweight1) next to original field. By comparison, the marked...

I need to export a query in Access to an Excel file but discovered that the number field became text field. All numbers are stored in text (General & wrap text). It causes further calculation incorrect. How can I prevent it from Access? Thanks!

Hi CJ, Thanks for your suggestion! I tried columns(A$:A)+3 without success but fine with columns($A:A)+3. I am at loss of the syntax and could you please shed some light on this function?