Search results

Hi I keep getting an error "Compile error. Expected: End of Statement" when using the following within VBA? DoCmd.RunSQL UPDATE [tblBACS Charge File report] SET [tblBACS Charge File report].Field4 = "0"+[Field4] WHERE ((Len([Field4])<"4")); I am trying to update a table where a text field...

Hi – I am relatively new to Access and am using Access 2010 macros in my database. The db works well [it seems?] when running on my ‘full’ version of Access 2010. However an error occurs when I attempt to run the same db on either: a) A PC running Access RunTime , or b) When the db is...

Hi - I am encountering a problem in a Navigation Form when moving from tab to tab following the use of filter on (any) of the sub forms! I unexpectedly get a prompt to save the form!? [Sorry - hope that makes sense as I am new user!]. One of our forum members "williamlove" posted a similar...

Hi . I am trying to filter a crosstab query using tempvars! e.g.From a table 'Paid' Field "PayDate" where criteria "between [TempVars]![SeasonStart] AND [TempVars]![SeasonEnd]" i.e. [TempVars]![SeasonStart] = #1/9/2011# and [TempVars]![SeasonEnd] = #31/8/2012#. The engine states...