Search results

  1. A

    Add new record for existing ID (fk) and append to table creating new pk

    Hello, I have a customers database and within in there, I have tabbed subforms within tabbe subforms to view specific and organized data. For example, users can click on the Employment tab (all tabs within this form correspond to my emp_tbl) which will take them to subform with tabs (Skills...
  2. A

    Import DBF files and create relationships that are updateable

    Hello, I am trying to convert a DOS system to an Access database. I have all of the .dbf files from the DOS system and have imported them into Access but am having trouble establishing the relationships. I have a Customers table with all personal identification of users. I also have three...
  3. A

    Query to create payment schedule

    Hello, I have a form with loan information containing fields: first_pay_date, last_pay_date, pay_amt, term, and balance. The term is not standard and ranges from 12-36. I need to do the following things all based around today's date: 1. Calculate the next payment date based on today's date in...
  4. A

    Import file and updated/add new records to table

    I am looking for VBA to do the following things for btn_click () on my form in my Access 2016 database: Import my excel file (import.xlsx) into an existing table (tblCustomers) where Cust_ID is the common field in the import file and table. This import will occur monthly so the table needs...
Back
Top Bottom