Search results

Apologies.. can't duplicate it now and it's working here too.

I found this from a Google search Literal strings are enclosed in single or double quotation marks. You can use literal strings just like you normally use a column name in the SELECT statement. The literal string will be displayed in very row of the query result. And this is proven in query...

Many thanks, all locked in nicely.

Have searched but found no answer I could use. How might I correct this to show only records where MyField has chr$(34) ? Select * from table1 Where MyField Like "***" Thanks

Haha thanks very much everyone for setting me straight. Never even though about "Current". Too confused why it was failing. As for why - the data in the table is not vbcrlf delimited, which I think is the sole text box requirement That that can't changed, can it ? I will use better, names this...

I hope this isn't too dumb a question, but something that really basic isn't working. I have a Form with 2 text boxes, text2 is bound and text0 isn't. My goal is to copy text2 to the unbound text box. I thought it would be simple, but have failed with Me.Text0 = Me.Text2 in the Form Open Event...

Hello Pat, Yes I needed a string as it's expected that way. And I wanted to understand what was going on and why I could not reformat it. Ideally it would be a date and problem gone, but too many changes would have been required. I believe the Windows regional settings were overriding Access...

It's like that already Arnelgp but *still* returned the leading day and comma. I was surprised... also tried Cstr but no change.

I think I sorted it.. however must be in a module, not code in Form. Function Caller2(i) As String If IsDate(i) Then Caller2 = Right("0" & Day(i), 2) & " " & MonthName(Month(i), True) & " " & Year(i) End If End Function

Appreciate the feedback, thank you. isladogs, The textbox is bound to a table, where the Field is a Date type formatted 'dd mmm yyyy'. That format is also in the text box properties. I read it from the textbox with Dim sd As Date sd = Me.[TheDate] and send this to a Form via OpenArgs. VarType...

> Either change your settings or (re)format the date to match your desired output. The latter is what I'm attempting but the Format command does not seem to return the right value e.g. d1 = "Thu, 12 May 1987" Debug.Print Format(d1, "dd mmm yyyy") = Thu, 12 May 1987 d2 = "12 May 1987"...

Thank you June, I've read a bit about this and I think the problem is related to the Windows regional settings... I tried this same Dlookup test in a different computer and it printed dd/mm/yyyy. In both cases the format was that set in Control Panel. How might I get the date into VBA code...

Is there an overriding date Format in Access? My table data type and bound textbox property are 'dd mmm yyyy' and that's how it shows in the Form. But if I read the value from the Form, (or from the Table with Dlookup) there's a 3 character day and comma added e.g.'Thu, 13 Apr 1967'. I've not...

> Access code can't see Forms in Design View. Thanks.. I'll stop trying then !

Thank you... found it. But a Form opened in design mode and in the debug window, what command should print a property like left or height of a control? Yes Boyd,form exists and it was in Design mode. Errorr were "object required", "Access can't find field.." The expression you entered refers...

There's a text box named "txtSides" on a Form called "frmRecSelect" In the debug window I'm attempting to print it's Left Value. But none of these work, all give various errors , and I wonder where I'm going wrong ? ? form_frmRecSelect!txtsides.left ? forms!frmRecSelect!txtSides.left ...

Hi Bob, What I envisaged was the calendar would disappear after selecting a date. Then I use that date to do other stuff within the Form. At the moment a date is typed into a text box, but this (might) be more elegant? PS Even after a lot of searching I can't see how to change the Year, if...

I'd like to put a date picker on a Form but having trouble with the Access one. The Form was Unbound, but a text box bound to empty table with a date field was added. But I don't want to see the text box, or click it, just have the calendar icon available. Is that possible ? Also can't see how...

Yes, if requested that data is shown to the user.

Thanks for the replies and advice taken on board. It was as developing this I suddenly thought why populate a table if I can put the data straight into a form. It was/is just a temporary display. But couldn't see how to.. then got hung up on is that possible or not. I've gone with the temp...