Good day my mentors. I was able to export my Ms Access table to Excel. But whenever I update the table it doesn't update in the Excel table until I go back to the VBA to click on run before it update it in the Excel table. Please what will be added to the code attached below to automatically...
Hi everyone
Please I need help as am a novice in Access. I have been trying create search button.
I create a query with the following fields
Customer ID
Product ID
Customer name
Date of transaction
Amount paid
Balance
I want the search button to search more than one Field i.e.
1...
Hi everyone
I have a subform which have Combo(ProductID) and when click on a productID(which contains items: Biscuit, Sweet and Milo) it will display the price. The problem am encountering no is that if I select sweet for the 1st customer it will display the price and I will enter the quantity...
Hi everyone
I have a subform which have Combo(ProductID) and when click on a productID(which contains items: Biscuit, Sweet and Milo) it will display the price. The problem am encountering no is that if I select sweet for the 1st customer it will display the price and I will enter the quantity...
Thanks for your response sir?
honestly am a beginner in Acess and am not that good sir am still a learner sir.
So I don't really understand your solutions sir
I would be glad if you will come down to my level sir
Hello good morning sir
Please sir I need your help, i design a database in MS access for a pharmaceutical shop. These are the field I have in my form
a. Name of drugs (in combo)
b. Quantity
c. Unit price
d. Total
e. Grand Total
Sir, if a customer bought more than one drugs how do i add...
Hello good morning sir
Please sir I need your help, i design a database in MS access for a pharmaceutical shop. These are the field I have in my form
a. Name of drugs (in combo)
b. Quantity
c. Unit price
d. Total
e. Grand Total
Sir, if a customer bought more than one drugs how do i add...
Hello good morning sir
Please sir I need your help, i design a database in MS access for a pharmaceutical shop. These are the field I have in my form
a. Name of drugs (in combo)
b. Quantity
c. Unit price
d. Total
e. Grand Total
Sir, if a customer bought more than one drugs how do i add...