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...
Pls how do I continue to Add item, Qty and Unit price maybe by clicking on a button called Add Item. So by clicking on the button the following should be display: Items (Combo), Qty, Unit Price, and the total. Thanks
Good morning to you all
I design a database that contains the following fields in MS Acess:
1. Items in combo
2. Quantity
3. Unit price
4. Total
I will like to click on a button that will enable me to insert the field above like this
1. Item. Quantity. Unit price. Total
2...
Hello I design CBT using Ms Access. My question now is can I put it online so that people can have access to it any where? and secondly will my Ms Access code work when published online?
I really need help on how to go about it.
Thanks