Recent content by Waheed2008

Hi, I have got PK in the main Form. How can I link it with other sub-forms? Can you please guide me about it? Regards

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 followed spikepl and Solo712 recommendations. I have made one table to keep data for all departments and made one Form to enter data. Then I split front and back end of Database; keeping back end on central location and distributed front end to 12 users. These users can access the...

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

Than you very much. It worked for me. The was with component isolation.

I have also tried this: ShiftStart = "6:00:00 AM" ShiftEnd = "2:30:00 PM" But it also does not work. What should be the values of ShiftStart & ShiftEnd?

Yes. You are right. ShiftStart and ShiftEnd are not valid time formats. When these values are used in DateDiff function, the results came wrong. I mean that ShiftStart cannot be subtracted from LogInTime which is actually a Date type field. Now what to do in this situation? Is it possible that...

Hi, I have solved this issue. The module name & function name should not be same. I have changed name of function. But now the calculations done by DateDiff is very strange. Here is my function: ---------------------------------------------------------------- Public Function NStime(InTime...

Hi, Thanks for the help. I have tried the same and made a function in a module. Then I am using this SQL statement: SELECT [AttTable].Name, [AttTable].EDate, [AttTable].LogInTime, [AttTable].LogOutTime, getNStime([LogInTime],[LogOutTime]) AS NS, * FROM [AttTable]; But when I run this...

Thanks for response. The field types are standard Time that can be either 12 hrs or 24 hrs formate. Time 7:45 will be represented either as 7:45 AM/PM or 09:45 (in 24 hrs formate if it is in the evening). The type is "Time". How should I create the custom function and add it into query?

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

Thanks a lot. I have got it and my issue has been resolved. Thanks again

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