Search results

Hello All, I have three tables Vendor vendor_id vendor_name vendor_address order order_id order_name order_date orderDetail order_d_id description quantity unitCost Now on the form i want to select vendor from the drop down list and it should...

Is there a way we can count how many times a report is printed and display the count result on the report. I want this because my office wants to know that once the Purchase Order is printed it should not be printed again and if it printed it should show the print count so that an explanation...

Hello All, How can i create a customized auto number field for table Order in ms acess if i already have a id field with Auto Number as type. example id (auto number) ---- order_id (custimize auto number)---- order_detail 1 100023...

Dear All, I am making a simple database in MS Access for handling the store in our office, where there will be a table1 having the items names, quantity etc and table2 for people who were issued those items and the quantity. I want to make the database in a way that whenever an item is issued...

OK, i habe two tables "employee" and "warnings", one employee can be given many warnings, i have made there One to Many relationship and now i want to have a report where user will input employee ID in parameter and the report will be displayed of that particular employee on the upper half of...

I have let say 300 employee records in my DB, now how can i search for a specific record by name or by id and then edit in the form directly. usually its only the NEXT and PREVIOUS option when going through the records, i want to search the record and then by pressing the edit button i should be...

I am making a small HR system in ms access 2003, i am stuck in making the tables for calculating the leaves of employees, what kind of logical tables will there be i need e.g. we have 22 Annual leaves, 9 Sick leaves and 3 special leaves. i want to manage the leaves and i want to display when...