Search results

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

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

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

I am abdul a member of this forum.

Good day experts Pls let say i want a user to use Access form for 40Mins. Is there any code that will make my Access Form to have start time and stop time. And i will like the Access Form to close when the time decreases to 00:00:00. I really need help.

Hello house Hello experts I have been trying for months to get my login form to open up to a specific record on the main form(NOTE PLS my main form is called "Navigation Form"). I have a table that store (ID, name, sex, country, Address etc) which i used to create my main form. I also...