Search results

Yes, CUST_ID is the primary key in my customers table and the foreign key in my employment table. I let Access set the relationship between my master/child forms. CUST_ID is a field in both main form and sub form. I am not using a list box to filter. I think I need to pass CUST_ID between my...

CUST_ID is used to link the child to the parent.

Yes, I have them related but when I try to just add a new record, I get the error that access cannot find a record in my cust_tbl with the matching CUST_ID...it does exist I just want to add a new employment record for the customer record that i am currently viewing.

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

Thank you for the responses. I will look into the documentation and videos. Appreciate the direction.

Plog, I agree the tables are not set-up correctly which is what I am trying to fix. A screenshot with all fields visible is impossible, some of my tables have the max 255 fields. I can elaborate on what each of my forms is capturing if that is helpful. For existing customers, if personal...

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

Thank you so much! That worked perfectly to calculate my remaining balance. I tested it by changing dates to make them older. I need to add in a statement to account for when balances have been paid in full but I can handle that. I appreciate the help the balance remaining part of my question. :)

first_pay_date last_pay_date pay_amount orig_term balance 9/15/2017 8/15/2020 $169.10 36 $6,087.60 9/5/2017 8/5/2020 $84.54 36 $3,043.44 9/5/2017 8/5/2019 $97.09 24 $2,330.16...

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

Ranman256, Thank you. I was able to get this to work with a macro and below is the macro converted to VBA. But this is how I set it up: 1. ImportExportSpreadsheet (imports records to temp table for update/append) 2. SetWarnings: No 3. OpenQuery: Update Query (updates values from temp table to...

Thank you for your response. I get a compile error: syntax error. Public Sub UpdateCustomerFromExcel(strFileToImport As String) Dim strSQLUpdate As String strSQLUpdate = "Update Import_Macro As A Right Join " & _ "[Excel 12.0...

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