Recent content by ismailr

Thanks CJ, I added excel liab through preference and it work perfectly. Now i added below code to further format the excel data It is giving the below error. Run time error 438 Object doesn’t support this property or method Please help me to fix the same. thanking you in anticipation. Ismail

Hi, I wrote below code to export data from query to excel and then format the excel data. I am getting run time error ‘1004’ Unable to set the Horizontal Alignment Property of the Range Class. Below is the piece of code. Kindly help me to have correct vba code to format Table Column Headings...

The cross tab query does not work because of different data type. I wrote first query to join two tables and extract data. Then script crate table and modify the table structure to include additional fields. Then script transform query output and insert into report table created above. Thiis...

Hi, I have a query based on multiple tables which extract different fields from tables based on parameters. I am using this query as source for report. The query result will have different number of fields so there is no fix template for report. On run time VBA should first clear all existing...

Hi, I managed to the expected result from the below query. Please validate; Thanks Ismail

Thanks for the quick response. What i understood from The FND Duplicate query wizard can analyse single table and find the duplicate. I have two tables which are connected through two fields. I don't think the FND duplicate query wizard provide me the sql. thanks Ismail

Hello, Request quick Help. I have two tables; TableA (fields CoCode, EmpDept) and TableB(Fields CoCode, EmpDept, ReportingMapping) Both Tables are linked through CoCode and EmpDept Need help to form delete script to delete records from TableA, only those records which does not exist in TableB...

Hello Galaxiom, Thanks, even if I get a solution to hide the access window will serve my purpose. Can you share the link of the previous post to hide access window. Thanks Ismail

Thank you very much for the response. Can someone share the code for API to capture the Minimize button with detail steps for it. Thanks Ismail

Dear Experts, Please advice and help to achieve. Thanking you. Ismail

Hi, I have a form in my db. It has button to minimize the application. These code I copied from MS site to minimize the application. Once I click on “Minimize Button” it minimize access application. This same function I wanted to have on minimize control of the form instead of button on form...

Dear, I am in big soup since yesterday, unable to find out the correct reason why my form is behaving abnormal. I need your help to understand to resolve this issue. The issue is; when i one main form and sub form. On Main form on load i the code is docmd.maximize is return. But unable to get...

Dear CJ, i am new for MS Access and always taking help from expert from this forum like you. I will be very thankful, if you change my sample and put the necessary code in it. please make is simpler to understand. Thanks. Ismail

Thanks CJ I wanted to achieve both, fisrt on open form should be maximize and then the contains should be displayed at center. Is it possible? Please advice or make the change in thr sample which i uploaded. Thanking you in anticipation. Ismail

Hi Expert. I am facing a challenge to show the form at the center of the screen. I am using Access 2010. I search on net but unable to get the correct guide line. I wanted to open the form in maximize mode to cover complete screen. The contains of the form should be displayed at the center. I...