Search results

Hi, I am working on MS Access 2010 and have come across a bit complex situation. I have a table with about 20 fields. In a main form, I have added 4 sub-forms where each sub-form is showing 5 fields of each record from the table. This is because of step by step data entry into the same...

Hi, I have come across a situation. I need to develop a database for HR department for hiring. There are about 30 departments in the office and these departments are distributed among 12 HR officers. Each HR Officer works on 2 or 3 of these departments at a time throughout the day...

Hi, I am working on the time attendance system for employees of a company and stuck into time calculations. The situation is that in a company there are three shifts: 1. 0700 hr to 1500 hr (NS-Normal Shift) 2. 1500 hr to 2100 hr (OT1-Overtime Shift 1) 3. 2100 hr to 0700 hr next day (OT2-Overtime...

Hello, I am stuck in a problem and need some help. I have a table having the following fields: ID, VehicleName, Date, MeterReading In a company I need to maintain records of vehicles so that after every alternate day, I need to put the odometer reading of every vehicle into database. Now I...

Hi all, I have got a situation. I have made an Inventory database and have maintained available stock quantity in a table field "StockQty". I have another field in the same table "MinimumQty" which keeps minimum quantity required in stock, like MinimumQty=5. It shows that if available Stock...

Hi all, I have got a situation to which I am not familior with. Please help me in this regard. I have two forms; Form-A and Form-B. There are 5 objects (Text Box, Combo Box, etc) on Form-A, and 7 objects on Form-B. I put button on Form-A to open Form-B. I want that after opening Form-B, few of...

Hi all, I am developing a small scale inventory system which will record all the tagged items into a table. I am expecting 2000+ entries per month, which means that in a year there will be 24,000+ records in the table. I have a perception that with this size of table, it will become bulky...

Hello, I have got a problem and need guidance. I have developed a database for maintaining the records of invoices. I want to save the scanned copy of actual invoice along with database record. How should I do that? There can be two options; either I store the image into database directly or...

Hello all, I am trying to shift from access 2003 to access 2007. I want to create customized toolbar in access 2007 but can't find the way to do that. In access 2003, I usualy go to View>Toolbars>Customize options and create/modify my tool bar. But how to do it in access 2007. I have tried...

Hi all, I have got a problem in Access. I am using Access 2003 and have developed a Database for my company. Now some other user will be using this Database for data entry. I want that other users should be allowed to Insert-Update-Delete records and should not modify/alter database structure or...

Hi all, I have got some problem is query. I have a table "Expenses" which has many fields like ID, Code, Date, InvoiceNo, Amount, etc. Now I want a query that will take Code from user and add the amounts of that code from "Expenses" table and show it up. Taking input from user is easy but...

Hi all, I need some help in making a check on a form. The situation is that a company get invoices and these need to be maintained into a database. For that I have made a table with fields: On the bases of this table, I have designed a form having all the above fields. Now I want that if a...

Hi all, I am working on a database and want to generate reports of different types. I have a table Expenses having different fields. The requirement is that I want to generate reports Year wise, Month wise, Week wise and Department wise. This is the requirement of project. What I understand is...

Hi all, I have got a problem in subtraction of two fields. I have two tables Department & Expense. Department has Name , Budget, etc fields and Expense has all the expenses of these departments. I a query, I have joined these two tables and sum up all the expenses of Departments. Now I want...

Hi all, Again bothering you for a very simple thing. I have a table Expenses having fields ID, InvoiceNo, Date, Expense, Approved Where Approved is a check box. I want to build a query (from Queries) such that along with other things, my query shows Total Expenses off all invoices and Total...

Hi all, Sorry for bothering again :o I have got another problem.I have two tables Department and Expenses. Department has the following fields: ID, Name, Budget Expenses has the following fields: ID, InvoiceNo, Department, Budget, Expense, Description, etc. I have designed a form for Expense...

I have a table Table1 having the fields ID, Department, Expense, etc. Each department has many expenses that are listed in this table. I want to make a query such that all the fields of Table1 are there AND an additional field should be placed into query such that it shows total expense of that...

I have a table Table1 having the fields ID, Department, Expense, etc. Each department has many expenses that are listed in this table. I want to generate a report such that on a page all the table fields will be displayed AND the total expense of each department should also be there. Each page...

Hello everybudy I have got a problem and I want help from some buddy. I have two tables Table1 & Table2. Table1 has two fields ID and Department. Table2 has 3 fields ID, Employee & Department. In a form, I have 2 Combo Boxes cmbDept and cmbEmp. I populate cmbDept from Table1 with...

In an access form, I am using a combo box and a label object. I want that when I select any value in combo box, its value be picked up and match in a table, and add corresponding values of all the entries with the same combo box value. I am using this function to calculate SUM of values from...