Search results

Hi All, Not sure if this belongs here so please bump it if it does not. I've been trying to find a way to make my database read only after 1 year for annual licensing/support. Once client inputs a license code/key provided by me the database will be fully functional again. I found one...

Hi All, I have a form which records payments for a membership. The form also displays the total amount paid by summing all the payments and the balance owing by subtracting the total paid from 50 (50 -txtTotalPaid). The AmntPaid field defaults to $50. I need to check if the AmntPaid is more...

Hi All I have a DB I'm developing and I need some advice on table development. I'll try keep it as brief as possible. Essentially the database is for a counseling service. A client attends the service and pays an annual membership. The membership starts from the first date the client attends...

Hi All, I've been at this for hours and can't get it to work. :banghead: I have main form and continuous subform with payments, in the subform header is a unbound textbox that totals the payments based on criteria. Query sums the totals and Dlookup displays in the textbox. All works well until...

Hi, I've been struggling to figure this out. I have a main form "frmClient" with a continuous subform ("sfrmMembPayments") which deals with membership payments a client makes on their annual membership. One year a member might pay in full $50.00 then the next year the client might pay in...

Hi All, I have a DB split into FE and BE used in a network environment in which I need all bound fields and and subforms locked until the user clicks an edit button to allow edits. In the header of each form is fast find utility using an unbound textbox for criteria and an unbound listbox to...