Recent content by AusDBGuy

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 Ari, I had tried that previously I did get it to work however it still doesn't do what I want. See the example below for what balance is displayed and what I need: Fee is $50 Paid|Balance | WhatINeedTheBalanceToDisplay 20 |50-20=30| 30 10 |50-10=40| 20 10 |50-10=40| 10 10 |50-10=40|...

Hi Ari, Thanks for helping. I was using mpClientID which was the Foreign key on the subform. This led to the solution to use the primary key on the main form which is the same value obviously. (Amazing how clearer you think after a sleep!) Now because there is always a clClientID on the main...

In the end instead of having a balance for each row I just created a textbox on the subform header and used a query to calculate balance and dlookup to display it in the textbox.

Hi Bob, Thanks for help. Gave it a try and get the same error. I have AllowAdditions turned off on the subform so there isn't even the space for a new record on the form hence there would not even be a Null mpClientID. Also because there is no records at all on the subform the OnCurrent event...

After updating the quantity field you could do a check using Dlookup, something like: If Dlookup("[StockValue]", "nameOfYourItemTableOrQuery", "[StockID]=" & [StockIDNumber]) < QtyValue then msgbox "You don't have enough stock" Else deduct the qty purchased from stock. end if You could...

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

Have you tried Forms!formname!subformname.Form.controlname

I've had a quick look at your code and there is some errors and inconsistencies with naming conventions. Can you post a copy of your Database? It would be easier to apply the changes directly to the DB and give it back to you so you can see the difference. Cheers

Can you post the code your using.

If your not worried about case-sensitivity,your using a combo box to list your usernames, and the combo box has the following columns as suggested above: UserID Username DeptID then you could use something like: If txtPassword <> DLookup("[Password]", "tblUsers", "[UserID]=" &...

I beleive Dlookup is not case sensitive either if looking up passwords. I use a binary string compare which allows for case sensitivity