Search results

Where should i add this code?

I have attached my database, do take a look. Thank you.

I do have a temp table

Private Sub cmdImport_Click() Dim filepath As String filepath = "C:\Users\User\Desktop\FabricPO.xlsx" If FileExist(filepath) Then DoCmd.TransferSpreadsheet acImport, , "TempFromExcel", filepath, True If IsNull(DLookup("[Date]", "NewFabricPO")) Then MsgBox "No new data to add" Else...

Yes, it return my records

Alright thank you!

Hi guys, I have an issue whereby my code does not detect new data when i import the excel file to access. I have posted this question in another forum, unfortunately i cannot get much help from there. I hope i will be able to get helps and solve this issue here! Any help offers is appreciated...

Hi guys, how to import excel data that are only approved into access? Below is my code for importing data: Private Sub cmdImport_Click() Dim filepath As String filepath = "C:\Users\users\Desktop\FabricPO.xlsx" If FileExist(filepath) Then DoCmd.TransferSpreadsheet acImport, , "TempFromExcel"...

I tried and run, the results is not what i want. What i want is that by using the unmatched query as the subform on my form, it will be able to show me what are the records that are not added in my main table (Which its working). Next, when i add the record from the unmatched query subform...

Thanks! It works, but how i click on 'Save" button and the records on the from will automatically clear and the "Edit" button will be able again? Currently, when i save my record after editing, i will have to click on clear button before i can proceed to use the edit button to edit the record...

This is the error i get when i run the append query

Sorry, I think I did not express myself clearly. I want my button to look (at the picture below) like that when i open my form and after i have click save.

oh! i have the unmatch query into my form, how do i add the record from my unmatch query into the append table? Currently, my save button is tied to another subform which is link to my main table

After creating the append query, i should use the append query as my subform?

oh i see, but when i append the query, it shows me error " there is an an duplication" when i open my form and the details on subform on my form is gone

Why do i need to append the query?

Hi, I have tried the unmatched query but when i want to add the record into another table, the record does not appear in my another table. How do i Fix that?

How to disable button on form Hello guys, how do i disable my edit button on my form after clicking on "Save" or "Clear" on my form?

Is there a shorter way? Like just automate all of this in just one button? as i am doing it for a company and the users who are using this system are not very tech savvy. Therefore, i would like it to be as simple as possible and minimal amount of steps

hmm, but the excel file that i will be importing into access will be updated every night so user will have to import data first thing in the morning everyday. If i would take your advise, when user import the data into the temp table, i will have to create a append query every time a user import...