Microsoft Access issue

Mhamd

New member
Local time
Today, 09:16
Joined
Mar 2, 2023
Messages
2
Hello sir
So i have a Microsoft Access program and i need some help I'm using it as a cashier so i have a 2 text box for cash amount received from customer and the change that i should return it to him
So i need the text box with the amount to refresh after adding more items to the list
 
Hello sir
So i have a Microsoft Access program and i need some help I'm using it as a cashier so i have a 2 text box for cash amount received from customer and the change that i should return it to him
So i need the text box with the amount to refresh after adding more items to the list
After adding more items to what list?
I think you need to explain more about what you are trying to do and/or post a copy of the db
 
Hi. Welcome to AWF!

Posting a screenshot could also help.
 
If you are using it as a cashier, do you also have the ability to change the code or design of that program? This change will probably require you to insert some code behind the scenes, code that is triggered by that addition of another item to your list. Since we can't see that level of detail from the question you asked, it will be difficult for us to be more specific.
 
Yes sir I'm an administrator and owner of the program
So i have:
Net sum
+ 2 text boxes:
Box 1)amount earned(by customer)
Box 2) Amount return(to customer(netsum - amount earned))
By calculation the number is correct
But if net sum changes i should re enter the amount earned to refresh
I need it to be auto refresh whenever net sum changes
Thanks in advance
 
add timer event to your form so that it will automatically recalculate box 2:

private sub form_timer()
[box 2].Requery
end sub
 
Hello,

Regarding your Microsoft Access issue, you can use the "After Update" event to refresh the text box with the amount. Here's how you can do it:

  1. Open your Access form in design view.
  2. Select the text box with the amount received from customer.
  3. In the property sheet, go to the "Event" tab.
  4. Look for the "After Update" event and click on the "..." button beside it.
  5. In the "Choose Builder" window, select "Code Builder" and click "OK".
  6. This will open up the VBA editor. In the empty code window, type the following code:
Me!AmountReceivedTextbox.Requery

  1. Save the changes and exit the VBA editor.
  2. Repeat the same steps for the text box with the change that you need to return.
This code will refresh the text box every time you update the list of items, and display the new amount received from the customer. I hope this helps!

Also, don't forget to ensure that you have a valid Microsoft Office 365 product key for your access program to function properly.
 

Users who are viewing this thread

Back
Top Bottom