Search results

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

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

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 everyone, i am encountering syntax error in my insert statement. How do i solve it? Private Sub cmdAdd_Click() 'add data to table CurrentDb.Execute "INSERT INTO...

Hello everyone, i am facing this error " Item not found in this collection" in my code. Can someone help me? Thank you!