Search results

  1. I

    VBA Code doesnt not run. No error message displayed.

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

    Button to kick everyone out of database

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

    Duplicating DB from existing DB

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

    Duplicating Form and Subform records

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