Search results

Hi Sorry for the late reply... I use (TBL1.Deleted=False OR TBL1.Deleted=True) because I dynamically line-edit the SQL string (using the replace function) so it acts as a placeholder. Why do you use alias names? Long story this... but I often join tables for my form recordsources... and...

And, of course, the nomenclature of (probably) most prolific use of that symbol in history, gave it the name "dit".... coined by a certain American, Mr Morse. As in dit-dit-dit-dah-dah-dah-dit-dit-dit.... my example, appropriately enough, being SOS! :)

Hi Thanks ChrisO, MissingLinq, SpikePL, Pat, Smig, RainLOver and G.A.H. (hope I did not miss anyone) for such amazingly comprehensive answers. This has filled out further gaps (some known and, to follow ChrisO's theme, some I didn't even realise I didn't know!). When one is totally...

Hi Spikepl Thanks for reviewing my rules-of-thumb... Yes, apologies, my point 1. was ambiguous. Interesting point about string-to-date conversions, thanks. When msgbox'ing DATE() on my machine it returns local UK format of dd-mm-yyyy... from what you say, this is because it has been...

Yikes! For those of us who don't yet quite have the depth of understanding, I think a few rules of thumb would be useful? I hope these are correct and clear up some of the confusion I experienced?:- 1. The date format property of the column in table design-view, does NOT define the column...

Phew! Thanks for your forebearance! Yes, I think I have been conceptualising this incorrectly. I have hit my head with a saucepan and now understand that, by using:- Format(Add_Date, "dd-mmm-yyyy hh:nn:ss") "mmm" converts the month to 'names' of "Jun","Apr","Feb" etc and this assists the...

Hi Smig Thanks for the reply... I think, though, that if you always use #[US format]# in the SQL strings, when setting a date it will appear in the tables and forms in the US (mm-dd-yyyy) format?? rgds

Hi Thanks for all the input... Been experimenting and I'm curious to understand why the two techniques below render different results... Method 1, where the date is formatted 'in-line', is the one I'm going to use as it renders dates in UK format. Method 2, where I format the date first...

Geez... this really is a minefield and a half.... :) Sorry, mine was a poor example. I guess a better question is if I enter dates as per Spark80's Rec_Date = NOW() SQL_STR = "UPDATE My_Table SET Date_Rec_Added = # " & Format(Rec_Date,"dd-mmm-yyyy") & "#" Execute... blah blah And then...

Thanks Gents... I'd read Allen's excellent article.... plus many others but confused myself even further... At one time I was adding dates into [date formatted] columns using quotes... so... Date_Rec_Added='" & Now() & "'" .. this displays nicely in local format in forms and tables...

Hi Access 2007, MDB file, Local Machine Just when you think you've got your head around this..... I am in the U.K. so I want dates to be displayed in forms and tables with the local format of dd/mm/yyyy. When I call Now() I do indeed get the correct format returned e.g. 01/04/2012...

Hi Access 2007, MDB file, Local Machine Here's a cracker!... I have a VB module in Access which I run from a Macro Action... It fails with Error 16 - Expression Too Complex. When I run it in debug it works perfectly... many times over! Is there some way I can at least find the line...

Ah I see my problem... I was running this in a RunCode Action of a Macro which doesn't seem to comprehend the syntax... As you say, I have called it from VB and it does indeed work... Thanks for the advice gents.

That syntax did not work so I'm guessing MS Office VBA is not the same thing as MS Access VBA? Will the real VB please stand up! :)

Ah you see that's what touch typing was invented for! :) I'll give that syntax a whirl ! Thanks!

Hi Seems like a basic question but I can't find an obvious answer... When calling a procedure in VB I often get snow-blinded by the keywords and parameters (AKA 'arguments'). On the world's greatest operating system (ICL VME/B) we used SCL. One of SCL's features was to be able to call a...

Hi Sorry for late reply.... yes I have Option Explicit and Option Compare Text in all my modules.... thanks

Curses! Thanks for the confirmation!

Hi Access 2007, .mdb file, local machine only I open an ADO recordset but can't update the fields in it. The .update below:- Set Prc_RstADO_A = New ADODB.Recordset Prc_RstADO_A.Open First_Select_Str, CurrentProject.AccessConnection, adOpenForwardOnly, adLockOptimistic Do Until...

Hi Access 2007, .mdb on local machine Just toying with the idea of giving my advanced users a button on a form which permits them to create and apply a filter to that form. Been dabbling with DoCmd.RunCommand acCmdApplyFilterSort I created a query and saved it and then called...