Search results

Hello AW, I can open up my tables using the code below in a distributable runtime version, but I cannot filter and sort in the table. Right clicking does nothing. Dim strTableName strTableName = Nz(Me.cboTableNames, "") DoCmd.OpenTable TableName:=strTableName, View:=acViewNormal...

Hello WA! Hope all have been well. How can I change report Sorting and Grouping through code? I tried: Dim rpt As Report Dim strReportName As String strReportName = "ReportName" DoCmd.OpenReport strReportName, acViewDesign Set rpt = Reports(strReportName) rpt.OrderByOn = True...

Hello AW! I am using Access 2003. I would like to be able to open a versatile form that can open any selected table in data sheet form. Currently I am using Command Button with the names of the tables as the trigger. I need some help with the VBA that would change the form's Record Source...

Hello AW! For a text box in a Report, I am trying to use the "SumOf([UnboundTextBox])" as the Control Source in the Report Footer to add the unbound text box in the Details section. I know it works with a bound text box, but does it not work with an unbound text box? Thank you for your help...

Hi Everyone, I would like to consider myself an intermediate Access designer/programmer, however, many times I feel like a beginner. I have a deployed database written in Access 2003 that has been well received, but it sure does need many improvements. It was pieced together by several...