Search results

Hi guys, is it possible to have VBA code that can merge cells in excel before clicking on the import button? As i would like to merge three cells in my excel file into one cell and when i click on import button on my access form, the imported file will only show as one cell instead of three...

I will try out tomorrow, thank you:)

I have no idea if having two subform on a form is causing the code to prompt me error

Yes, i did.

I tried and i am still facing error

I now face syntax error CurrentDb.Execute "UPDATE mxd" & "SET ID = " & Me.txtID & _ ", GLGPO = " & Me.txtGLGPO & "" & _ ", GLA = " & Me.txtGLA & "" & _ ", StyleNo = " & Me.txtStyleNO & "" & _ ", Content = " & Me.txtContent & "" & _...

Ok, noted. Yes, it does exist

Hi guys, I am facing issue with my code whereby it show me method or data member not found. I check the spelling of my code against my textbox on the form and they are the same! Besides that, I am sure this code is working as i am using the exact code on my another form and it is working! so I...

Hi guys, I would like to ask if it is possible to show only recordset that are not added into another table in the subform? For example; My subform is link to table 1 with all the details from table 1 but i want to add the data from table 1 to table 2. Besides that, once i save the data...

Hmm, by adding series number will not help as my excel spreadsheet will import into my access database every morning but i only want the new data to be added into the table that i imported

Hello guys, I would like to retrieve excel data from a folder from my desktop into my access. My code: Private Sub Command0_Click() Dim filepath As String filepath = "C:\Users\chelsia.koh\Desktop\Unused\Fabrication.xlsx" DoCmd.TransferSpreadsheet acImport, , "ImportFromExcel", filepath, True...

Thankyou! It works!

Hello guys, How do i add a msgbox that display "Record added" when user click on the save button on the form? Thank you!

Opps, I am sorry!

Thank you! It works~

Hi guys, how can i add the code where it will display "No record found,check again" error message when user key in PO number that are not saved in the database? PO: ABC17/123 Thank you guys!

I use ADO as at the end of the project, i will be retrieving excel spreadsheet from a local desktop and not from the local table.

i have no idea how to continue the code on my display tho

Hello peeps, Can you all take a look at my database and tell me where i go wrong? have been stuck with this for a long time

Hi, my remarks managed to align yesterday in my report. However when i print preview report, it does not align again :(