Recent content by maxim

I figured thins out DoCmd.OpenForm "frmContacts", , , "[PlanID] = " & Me.PlanID If IsNull(Forms!frmContacts.[PlanID]) Then Forms!frmContacts.[PlanID] = Me.PlanID End If

Not exactly. I did create form and datasheet subform. In the sumborm Property Sheet on Date tab I had an option to select Maste Field and Chiled Field to link form and subform and it worked very well. But I need to enter data not from subform but from linked form.

Is there a way to link two forms by master and child fields so I can add new records from linked form?

I have a table with contract information. It's got Contract #, Customer ID, date contract was signed, quantity purchased. When customer makes purchase again system creates another contract with a new number. I need to compare each contract for the customer with the contract signed next time by...

Appreciate your help. I searched high and low and couldn't find a solution.

I set up a table with first due date and interval (weekly, biweekly and monthly) and I need a due date to be calculated based on todays date. What you suggesting works only for the first date and all following dates get pushed too far since I multiply them by 2 (see the SQL statement) SELECT...

I need to calculate payroll due date. Payroll can be weekly, biweekly and monthly. I used DateAdd function and was able to calculate weekly and monthly payroll date but I can't figure out how to calculate biweekly date. Can anyone point me to the right direction?

Thank you. I tied you approach. Now I see that there is no need to record check amount in payment table since it can be calculated as a sum of applied payments from junction table. But now I have problems creating the forms. I want to be able to enter checks in the subform or in the form linked...

I guess adding applied amount is the only easy solution. Thanks for your help.

99% of all payments are one order - one check. If I follow your advise data entry workload will increase because I would have to record same amount twice. Is there any way to make it automatic if order is paid in full with one check?

I have two tables Orders and Payments with many-to-many relationship. Two different orders can be paid with one check and one order can be paid with several different checks. To link Orders table with Payments table I use third PaymentsOrders Table which has following layout: PaymentsOrdersID...

Thanks. I will look into replacing temp table with nested query. What kind of problem can primary/foreign key inconsistency cause?

Hi, I’m working on the database to reconcile stock trade and cash for retirement fund. We receive checks from our clients which we need to invest. These deposits are logged into database and clerk orders purchase of different funds. This is a contribution. If client wants his money back we sell...