Search results

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?

I have a formula, =VLOOKUP("*"&TEXT($A5;"000000")&"*";Vlookup!$A$2:$O$1405;4;FALSE) and would like to drag the lower corner of the cell to the right columns. How can I make the "4" to automatically add 1 for next cell? Thanks!

It now turns out "#NAME?". Very strange!

Thanks for your idea! It does not work out my issue. Upon close examination, the looked blank cell is not blank using isblank function. The cause is the looked numeric value is not a numeric value, text value. If I use value function with looked numeric value, the sum output is correct but...

I have two columns getting the values from other worksheet. On other column, I have a simple sum function, such as =sum(P3,Q3). When the P3 is 0.01600046 and Q3 is blank, the output is 0.00000. Can someone advise the possible error for this scenario. Thanks!

I agree to have better data entry method ensuring data integrity. Each unique record does contain multiple skus and models. The different no of skus and models are unique records. Now I have data validation helping to input the comma and space but in the past it still replied on the user...