Search results

hi trying to get vlookup and sum but unsucessful yet. help will be appreciated. Example attached Thank you in advance. Regards Muaz :banghead:

hi trying to get vlookup and sum but unsucessful yet. help will be appreciated. for example id text vlookupresult id2 value 1 aa 15 1 3 2 bb 7...

Hi All; I am using a frame on form to get report. Below is the code used to filter report. Select Case Me.fraReportType.Value Case 1 strReportType = "Like '*'" Case 2 strReportType = " Is Null" Case 3 strReportType = " Is Not Null" End Select The second...

Hi; Which third party reporting tool is good to work best with Microsoft Access ? Regards Muaz

Hi; I am using .FilterOn = True , when it executes the system popup "Enter parameter Value", I do not understand why ? I have designed a report. By default it executes for all records. After execution there is a form where a list box contains values to filter the report. After selecting the...

Hi, I have a report in access having multiple columns. because of multiple columns it is not possible to display it in A4 size. I want to hide the column when there is no data, Is there any possibility to hide column on the basis of criteria ? Regards Muaz

Hi; I have two database files. One is A.mdb that consists of Queries, Forms, Reports etc. Another File B.mdb is having tables only and that tables are linked with A.mdb I prepared System.mdw file that have user rights. When I am trying to log in, after the password the system give the below...

Hi All; I have a text field having data i-e HO-1, HO,2, ACW-25 and so on. The field name is nBadge_num and is Unique. The data in this field is sorted automatically like 1, 10, 11, 12, 13, 2, 3, 4, 5...because this is the text field. The number on the form is automatically generated, when the...

I make one form in Excel having ListBox, When I click on the record the details are shown on the text boxes on the same form. Up to this I have done. After the data in the text boxes changed/update the record should be updated in Excel sheet after pressing Button "Update". Any help/idea ? Thanks

Hi; I am trying to connect my MS Access database, but it gives me the following error: Logon Failed Details: DAO Error Code 0xbd9 Source DAO Workspace Description: You do not have necessary permissions to use ..(database path)... object. Have your suystem administrator or the person who...

Hi All; I have a text field having data i-e HO-1, HO,2, ACW-25 and so on. The field name is nBadge_num and is Unique. The data in this field is sorted automatically like 1, 10, 11, 12, 13, 2, 3, 4, 5...because this is the text field. The number on the form is automatically generated, when the...

Hi; When I make a query to collect the data it looks like: Staff No. Basic Salary House Rent Overtime Medical But in report I want something like below i .e Description Employee 1 Employee2 Employee3 and so on Staff No. Basic Salary House Rent Overtime Medical Is it possible...

Hi All; I have a table having the following fields: StaffNo TextField PrimaryKey Name .... ... The data in StaffNo will be alpha numeric, like AKA-111, AKA-112, LMN-100, LMN-102 Here AKA and LMN describes the Sites where employee is working. On Add New Employee, When user enter AKA- in...

I have the employee data record... I want copy of the same record to insert in table but with different employee id and Site through forms. StaffNo is the primary key. For example existing record StaffNo, Site, Name, hiring date, etc AKA-111, 10, John, 25-10-13 new record StaffNo, Site...

I am facing one problem and needs our guidance. My scenario is as follow: I have employee attendance in Excel i.e Emplpyee Number, Day1, Day2, Day3....Day31 I have a table in access that have columns Employee Number, Day1, Day2, Day3...Day31, Presents, Annual Leaves etc Excel file data needs to...

Hello! Very happy to find this community My name is Muaz Qazi and I live in Abuja, Nigeria and I belong to Pakistan. I am in the field of IT since 1997. I worked on IBM AS/400, IBM System/36, RPG and COBOL. I also become a SAP Development Consultant in NetWeaver-ABAP in February, 2007. My...