Recent content by imsuneaik

Yes both files are stored under a trusted location/directory. I tried stepping through the code execution but still no display of errors messages or popups. Thanks

Hi everyone, I have a VBA code that allows me to ultilise File Dialog to import Excel file into Access Database. The strange thing is the same vba code works for one DB file but not the other. Both the 2 DB files are identical in some ways. However, when running the code on the other DB, no...

Hi all, I am trying to create a button to kick users(everyone including myself) out from database. My database is stored in the shared folder on the network. Currently, I realised that my code would only kick myself out. The code is written below Option Compare Database Public Loops As...

Thank you. It works!

Thank you for the reply. I am trying to first method, of deleting it manually. However, some of my tables are autonumbered, as a result the records will not start from 1 right?

Hi everyone, I would like to create a new fresh database (same objects, without data) from the original one. While ctrl c + ctrl v works for the objects, I realised that relationships can't be copied in this manner. Using the inbuilt import function causes all datas to be copied in as well...

Thank you all. It works already! Much appreciated.

Hi everyone, I am trying to duplicate my main form and sub form records. By using queries, i was able to make the duplicate the record for the main form as they are from the same table (eg. No. 150 and No. 151) I have 2 tables named List and Item, linked by ID as their relationship. -...