Recent content by Happyz

Hi all, I would like to import multiple excel worksheet in one excel file into my access database, how can i do that? Below is my code for importing excel file: Private Sub cmdImport_Click() Dim filepath As String Dim user As String user = Environ("username") filepath =...

Thank you!

Thank you, I tried re-enter the dates and it works perfectly now!

I formatted the excel file but still cannot work

I have tried saving, but it giving me error" Potential loss of data, save it as excel"

I have tried changing the format, and it still wont work.

Hi, I have attached my database

I changed the file format to date in excel and try convert it but it still does not work. I realize that, the excel file i import into access does not import the date range 13-31. For example for September date, the date shows from 01/09/17 - 12/09/17. the cell for the date is left blank from...

The import error show type conversion error

Hi all, I faced this error when i import my excel file into access by using VBA Code. As you can see in the image i attached below, it shows that when i import excel file into access, some of my date are blank which is not the case in my excel file where all the date are fill up. How can i fix...

Hi Arnelgp, Thanks for your help. I appreciate it a lot. However, there is another error message that came out after amending the codes you've written. I have attached the error above. Hope you could clarify it with me. Thank you:)

Hi, I thank you for your help, but i do not really understand your reply. It would be great if you could give me a clearer explanation! Thank you once again:)

Hi, for the branch fill, the fill is always oversea, even before i select any data. my plan is to have all the fills empty, and then when i edit a line of data, all the data will then be added in to the respective fills. for now, all of the branches are oversea. the right condition for the...

Hello all, I would like the form to auto populate my result in the textbox without me having to click on it to display the textbox. How can i do that? By the way, I am currently using unbound form. What i am currently doing now is that i write a VBA code to help me differentiate if this is...

Hi Arnelgp, the codes you've send me can be used now. Thank you so much for your help. Really appreciate it. :)