Recent content by lodhi1978

Hi All, I am using Access 2010, I have made web forms and web reports, Now I want to export the web report data to excel file, I use below subroutine Sub Test() Dim outReportData As String Dim xlFileName As String outReportData = "rpt-Cities-Completed-2011" xlFileName =...

Hi All, I want to create a cross tab web report in Access 2010, The query is below TRANSFORM Count(AssetsExtended.Item) AS CountOfItem SELECT Year([RetiredDate]) AS [Year] FROM AssetsExtended WHERE (((AssetsExtended.RetiredDate) Is Not Null)) GROUP BY Year([RetiredDate]) ORDER BY...

Hi All, I have created a bound form that contains 5 unbound fileds. I want to filter the data thru the values of unbound fields. I wrote following code on a button "ON Click" event. Private Sub PBApplyFilter_Click() Dim row As Variant Dim itemdata As String Dim ActiveFilter...

Nobody.....

write a macro on "ON Ente" event of subform.combox as and problrem is resolved

I have added the code on Client on After Update event as Me.[SubForm].[Subformcombo].requery but it did not work

Hi All, I am using MS Access 2010. I have created a query as "Policy Info" Create an unbound form, with controls as District (combo Box), Due Date (Combo box), Cancel Only and its a check box I have created a subform that contains bound controls from the query "Policy Info" I want to...

Hi All, I am using MS Access 2010, I have three tables, Policies (Id, Client Id, Address, Policy Amount, Paid) Payments (Id, Client Id, Total Amount) Payment Details (Payment Id, Policy Id, Paid Amount) I have created a form "PAYMENTS" that include a sub form "PAYMENT DETAILS". In the sub...

Thanks CJ, You are right, I dont want user to left some fields blanks, and also wanted to prompt him immediately if he left the field blank. I tried Not isNull in validation rule but it is not working, I also wrote the suggested code on "On Update" event but it was also not working, I then...

Hi, I am using Access 2010 on Windows 7 (64-bit). I have create a table clients that contains multiple columsn i.e. Id, First Name, Last Name, Starting Date, Company , while defining the table I did not mark REQUIRED property of any column I have created a form based on this table...