June7's latest activity
-
June7 replied to the thread Field to enter ONLY time..Interesting, when I type 14:00 into table field or bound textbox it is not showing date component. Shows 2:00:00 PM. Format property is... -
Perhaps look at TimeValue? ? now() 26/07/2025 19:51:02 ? timevalue(now) 19:51:09 There is also a DateValue() function when you want...
-
June7 replied to the thread Solved Tab in RTF control.AFAIK, Access RTF accepts a very limited set of HTML tags. Can only try and see what happens.
-
June7 replied to the thread Solved IsNull not working in query.I edited my previous post while you were reading. Review again. Did you run UPDATE? I thought it would be an empty string because...
-
June7 replied to the thread Solved IsNull not working in query.I did a manual progressive filter (right click filter menu) on the table and I can get the 52 records. The problem is with DD_ReceiptNo...
-
June7 replied to the thread Solved IsNull not working in query.It's simple. No records can meet all 4 criteria with AND operators. The first 3 criteria return records where WO Date is null for all...
-
June7 replied to the thread Solved Tab in RTF control.Why would listbox use ValueList? Isn't the RowSource still a table/query? That's what I do.
-
June7 reacted to cheekybuddha's post in the thread UPDATE with LEFT-JOIN (conditional update query) with
Like.
The point is why have tblRecords.LockID at all? Couldn't you just have a simple query like: PARAMETERS SpecifiedRecordID Long; SELECT... -
June7 replied to the thread UPDATE with LEFT-JOIN (conditional update query).Apology for my error. Why do you UPDATE LockID field? Perhaps sample data would be helpful. Access does not allow UPDATE when join...
-
June7 replied to the thread Solved Tab in RTF control.Should "VPN" be "VBA"? RTF is formatted with HTML tags. There is no TAB tag. Why is textbox RTF? What formatting do you want? Exactly...
-
June7 replied to the thread UPDATE with LEFT-JOIN (conditional update query).What is qryOutstanding SQL? Why do you UPDATE Outstanding field? I suspect this value should just be calculated when needed and not...
-
June7 replied to the thread syntax error with null values.UNBOUND textbox. A subtlety I never focused on before. Gets more interesting. UPDATE action set text field to Null although I had to...
-
June7 replied to the thread syntax error with null values.And where did I disagree? Basically along same lines as I was saying - Variant defaults (initializes) to empty string but accepts all...
-
June7 replied to the thread Misleading Grouping Claim.It's my experience if control does not get positioned within tab page, it is actually just a control on form sitting on top of tab...
-
June7 replied to the thread syntax error with null values.Access will do implicit conversion if you give it something to work with. Variant accepts any value therefore it can equate to any...