AOB's latest activity
-
AOB replied to the thread Solved Format textbox with special case for "1".Sorry, final comment on this... Turns out Excel does provision the option for custom conditional number formatting natively. You can... -
AOB reacted to sonic8's post in the thread Solved Making an old 32-bit MDB file 64-bit-compilable with
Like.
That's what I would have recommended to consider. Just keep in mind: It is not 64bit only, but VBA7 only. So, your converted code only... -
AOB reacted to arnelgp's post in the thread Solved Format textbox with special case for "1" with Like.
you can try Adding another Unbound textbox and hide the Original textbox with Calculation of days. the ControlSource of the New Unbound...
-
AOB reacted to June7's post in the thread Solved Format textbox with special case for "1" with Like.
Could have "day/days" text in a separate textbox and use an IIf() expression to display appropriately.
-
AOB replied to the thread Solved Format textbox with special case for "1".Apologies for the delay in acknowledging these replies, there seems to be a weird firewall / extension block on the site from my work...
-
I have a textbox control that displays the number of workdays between two dates. I am using a custom format to suffix " days" after the...
-
AOB replied to the thread Solved Continuous subform displaying boolean results differently to underlying query.Figured it out... The subform property Recordset Type was set to Snapshot. Changing this to Dynaset somehow made the results in the...
-
AOB reacted to ebs17's post in the thread Solved Continuous subform displaying boolean results differently to underlying query with Like.
SELECT C.CategoryID, SC.SubCategoryID FROM ( SELECT CategoryID FROM tblCategories WHERE...
-
AOB reacted to arnelgp's post in the thread Solved Continuous subform displaying boolean results differently to underlying query with Like.
Nz() function returns a Variant type, so convert it to Numeric: SELECT qC.CategoryID, qC.SubCategoryID, Val(Nz(jE.Selectable...
-
AOB reacted to ebs17's post in the thread Solved Continuous subform displaying boolean results differently to underlying query with Like.
If I understand this correctly, then the problem here lies in information that is too much and incorrect in terms of content. SELECT...
-
AOB reacted to ebs17's post in the thread Solved Continuous subform displaying boolean results differently to underlying query with Like.
True, the WHERE clause is wrong, my mistake. As the note before: Of course you have to implement your desired logic, I wasn't aware of...
-
AOB replied to the thread Solved Continuous subform displaying boolean results differently to underlying query.Thanks @arnelgp , very interesting! However... I have followed the steps you suggested and modified the query thusly (bearing in mind...
-
AOB replied to the thread Solved Continuous subform displaying boolean results differently to underlying query.Thanks @ebs17 I do take your point on the superfluous INNER JOIN and have moved those details into the initial "combo" query thus ...
-
AOB posted the thread Solved Continuous subform displaying boolean results differently to underlying query in General.I'm getting really strange behaviour trying to apply a (relatively simple) query as a data source for a continuous subform. The query...