Search results

I have a report of Employee’s jobs, named EmployeeReport. I would like to open a form named “Form1” when I click on an EmployeeID on the EmployeeReport. Form1 is not set on a table or a query. This form has some unbound controls. One of the controls is named “Employees”. So far, I know I should...

We have the following table: ID Staff ItemName Price Qnt Cost 1 John Book 5 3 15 2 Mori pencil 6 7 42 3 Tom Book 7 4 28 4 Tom paper 10 6 60 5 Mori paper 10 3 30 6 John pencil 6 2 12 7 John Book 5 1 5 8 Mori paper 10 8 80 9 Mori...

I have made a report such as the following Studentname yearlycost John 21000 Steve 27000 Jack 22000 Amanda 20000 The yearlycost is the sum of monthly_cost of each student and is created by the SUM function of the report. How can I sort the report based on the yearlycost? Since...

I have the following table: John's daily expenses: ID Date item cost 1 01/01/2021 milk 2 2 01/01/2021 apple 3 3 01/01/2021 cheese 7 4 05/01/2021 milk 4 5 05/01/2021 bread 2 6 05/01/2021 butter 12 7 08/01/2021 milk 2 8 08/01/2021 apple 5 9...

How to get a value from previous record in a query The Following query has brought records for John’s math record from student’s score table named MyTable Query1 ID ---- Studentname ------ subject ---- score ---- month . 12 ----John ---- ---- ---- math ---- ---- 17 ----...

I am going to record student’s scores in a table like the following : Student names are looked up from student_list table and subjects from subject_list table. students_cores table: ID, studentname, subject, score 1, john, mathematics, 80 2, john, physics, 87 3, john, history, 75 4, john...

Please help me to make this report: We are making an invoice which should be split for the costumer and also the store. Can we design a report to have the same identical result in one page such as the following? customer name: Akbar Bond Service-ID product adviser cost 54...

We have the following table: EmpName Payment 1 Jack 160 2 Steve 95 3 John 47 4 Jack 25 5 kate 12 6 John 23 7 Kate 21 How can we get the sum for each person? A result like the...

I have the following form based on a table: empName salary working jack 1000 yes/no Steve 1500 yes/no Janet 200 yes/no summary: [number] fields “empname” and”salary” are...

I have a report. I go to report properties, and open the record source to reach the query on which the report is made. I make some changes to the query. When I close the query it asks me to keep the change or not and I click yes. But when I close the report it doesn’t ask me to keep or discard...

There is a form with some fields and it has a button which goes to the next records. how can we make the button inactive otherwise all or some of the filed are filed? Thank you

Different users are putting data for our customers. How can we figure if we are making a duplicate record for the same costumers and prevent that? I mean for example a costumer name is “Scarlett Johansson”, and a record is made for her. Then another user is entering the same data for the...

I am putting the student names in a form. I want it to alert me that a name is duplicated. But thats not this simple. For example a name is “Jennifer Locus” but I type “jenifer” with one “n”. Can access guess that this might be the same person and suggest me to correct the spelling or enter it...

I have made a table which contains the data from some companies, such as company name, phone number and address, website, etc. I have also made a report over this table. How can I make this report, so that if I click on the box that has the company website, it automatically open an explorer...

is there a way to securely block the access of user to tables/queries, else in Microsoft Access? thank you

There is a DB with many forms and reports on which multiple employees are going to work. Is there an easy way to prompt each employee to enter his/her own password to be able to open the database? Since it is important to record who has put data in forms, a column is designated to record the...

I am selling some products, namely A to M. I record the orders of costumers in a table, named "orders". Can we assign a unique number, named invoicenumber here, for each set of orders that a costumer puts? Please see this table: ID costumer product quantity unitprice orderdate...

I am selling some products, namely A to M. I record the orders of costumers in a table, named "orders". For example, if costumer "Jack" has ordered as the following: ID costumer product quantity unitprice orderdate 12 jack A 4 10 25/11/2014...

We make a criteria in a query to get data from from1 like: [forms]![form1]![text1]. This requires us to have the Form1 open and there should be a data in Text1. Can we make the criteria to either take the data from Form1 like the above, or if Form1 is not open it gets data for the criteria from...

There is a query named query1, which has a column named “salary”. We also have a form with a textbox named “payements”. Can we design the form so that when it is loaded the textbox named payments gets the sum of column salary of query1? I mean: “payments” in form textbox = sum of “salary”...