Recent content by David S

Hi guys - Result! Many thanks indeed to you both - the update with quotes as per 'namlian' post is spot on. I doubt I would have got there on my own. Very kind regards David NB As stated in my original post, the 'Field4' is a text field and the syntax appears to work perfectly [for me].

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

Bob. Am new to this! Did you mean "put in the OnClick event" not GotFocus? I can get it to work on the onclick but not gotfocus. Am I missing some point here? I know default action on using Tab to enter a field is to select all the text and this property can be changed [see PeterF - above]...

Sorry but I have wasted your time with the above. On further research I have found that “The value to store as a TempVar must be a string expression or a numeric expression. Setting this argument to an object data type will result in a run-time error.” Obviously, where I have Macro code...

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 Steve. My understanding is that when you move between Navigation Form tabs ACCESS "fires the open and load events thus it always re-queries the forms"

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 vbaInet I cannot see a reply to your (above) request to share a link? I have found a link but as I have not yet posted more than 10 times the system disallows my sharing it with you. But I hope the following broken link is sufficient for you to recreate fully: – social.mdsn.microsoft.com -...

That's it! I needed to add the TempVars in the Parameters list of my crosstab query. I would never have got there alone. Many thanks indeed.

Hi again. This was my first post and I am really impressed with speed and knowledge content of your replies. Many thanks indeed to you all. Particular thanks vbaInet, I thought I was going mad … “References to TempVars or controls on forms are not recognised in Crosstab queries.”. Why Microsoft...

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