Search results

ATT is PayType Code saved in one table. Report is based on query and that query have this code and its description. The description is showed in the report.

Below mentioned image shows the dialog box. If I enter ATT i.e is shown in the dialog box the report will filter. This dialog box for entering parameter should not appear. Regards Muaz

Thanks for your reply. I copied this code during google search and modify as per my report name. During debugging it shows that when it execute .FilterOn = True the dialog box appear "Enter Parameter Value".

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

Thank you, I copied every object to a new file and then create the new .mdw file and its working fine till now. Thank you again. Best 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...

Thank you all for your support. Issue Resolved. I use the following logic to solve this problem. Set rst = dbs.OpenRecordset("SELECT Max(Val(Mid([nBadge_Num],InstrRev([nBadge_Num],'-')+1,4))) AS MaxNo " _ & " FROM newMain " _ & " HAVING InStr(1,[nBadge_Num],'" & Me.NBadge_Num & "')=1")...

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 Rx_ The excel file is attached with some data. The reason behind is we have different site, we are collecting employees attendance, per day, information in excel format. But when we receive that excel sheet that exists plenty data entry mistakes. To reduce and control the amount of mistakes...

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

Crystal Report version is 9.2.2693, Access Version is 2003 (xxx.mdb) while one installed on my system is 2007 but I am updating .mdb database, I tried on Access/Excel (DAO) that give me this error (mentioned), There is no password on the database.

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

Issue Resolved. Thank you very much for your HELP. Best Regards Muaz

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; I am also facing similar problem, to make certain fields mandatory, on different tabs of the same form. I download the attached database to get some idea but unable to open. Can someone provide me this data base in Access 2003 format ? Thanks in advance. Regards Muaz

Issue Resolve. Thank you JHB. This is what I want. The code is working exactly what I want. Thank you again. Thank you all for providing the solution of my problem, it was not possible by me without your support. Regards Muaz

Dear Mihail; I have checked the details in the link you mentioned but my case is slightly different. In my case the staff number start with alphabets then 4 numerics. I have to check the next counter of the last four numeric. If the first alphabet is AKA- then pick the next counter of the AKA-...

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