Recent content by hamzack

Thank You!! Thank you Pat Hartman. I had been having trouble displaying the record via form, and solved my dilemma by altering the join properties of the query the form was based on. :) :)

Hi! I've encountered another stumbling block. My form is almost done except for some minor details. However, one calculation does not work even when I use the correct terms. This calculates the tuition balance per customer based on data from 2 subforms on the main form: sbfTuitionAccount and...

:) Thank You!! Thanks a lot guys, worked perfectly fine! :)

Hi! I'm in the midst of a database where a subform 'producttotal' textbox 'txttotal' would be automatically filled with a value from the mainform combobox 'product'. my code is Private Sub Level_AfterUpdate() Forms!sbfproducttotal![txttotal] = Me![product].Column(1) End Sub However...

Thanks, but... The link you gave was helpful in so many ways. However, the format of the sample database is a little different from mine as I have to deal with set modes of payment that entail different amounts per payment schedule. For example, to purchase product A, a customer has three...

Thank you! Thanks for your input. I'll try it out and let you know if it works out :)

Hi! I am new to Access and am trying to create a database for my customers that tells me what product/service they avail of and the status of their payments. My tables are Customer Info CustomerID LastName FirstName Address ContactNo Products (A,B,C) ( A customer can only purchase one...

Hi! I'm a newbie with MS Access. My blank database consists of customer info, product (A, B & C all priced differently) and schedule of payment (Annual, quarterly and monthly). I've created a general form and subforms for each payment schedule w/ details (e.g. total amount, quarterly/monthly...