Activity Stream

Thank you, F_MENU is not the principle Form, it is an other Form that is already open before principle Form ( and subForms ) Load

Subforms load before the main form so if F_Menu is your main form, the line mydate = !! will fail

Difficult to advise without seeing your code. Unfortunately macros are not very developer friendly for debugging. most developers here use vba....

Try something like: select @bnchmark = Benchmark from hvvmgrpt.dbo.tbl_benchmarks2 cross apply string_split(@tmpstr,',') where ID = value and...

What I'm displaying varies and can be any length. All that I'll know is the number of characters. But the space they need varies because of the...

Truncated in dropdown list? Will not wrap. Will wrap in the text box part if you increase height.

Thanks June , that is working great - but now I see another problem. If the text doesn't fit it is truncated. Can it wordwrap? Or failing that, can...

I revised my previous answer, perhaps after you first read. Initial test with UNBOUND combobox with ValueList exhibits same results you...

Likewise moke, no change. I can see ItemData(0) though.

June Unfortunately that had no effect. There's nothing in the combo box until the dropdown is clicked. Can this work, or is it a lost cause. In...

try Form_frmtest.cboA.DefaultValue = Form_frmtest.cboA.ItemData(0)

I just tested with combobox that uses query for source. Setting DefaultValue to first item ID works, item is selected. But why bother with...

Read and set listbox Height property in VBA as TWIPS. 1440 TWIPS per inch. Fonts are measured in points, approx 72 points per inch. ...

While I asserted that the height could be calculated, I had no formula in mind. I would work it out via trial and error.

I'll check out a combo and pick whatever works best to display data. Re listbox, what's the formula to calculate height exactly? Can't find it on...

don’t disagree but I was thinking of navigating from one control to another

Sorry thought I had put that after the code tag. yes tmpstr it's not the value being returned is < 25 characters. It kept erroring and I was...

Please edit your post so the narrative below code is not between CODE tags. And when you say "tempvar", did you mean "tmpstr"? bchmark is declared...

After several days of frustration i deleted the .edit command and the error went away!!!! Incredible!! Many thanks for the responses.

In my experience, your form is fairly simple. The multiple similar name fields of AttributeX indicates a non-normalized structure. All 6 are...

I made the directory and it works again. Thanks

Have you moved the DB?, is it in a Trusted location? So the code is not running? Put a breakpoint on the first available line in that code. Does...

So here's a screenshot of the form's current iteration. I've consolidated the Owner's address & Owner's mailing address sections, thus reducing the...

Thanks again. Your first recommendation reminded me that I already had a query that placed X's in blocks assigned to morning and afternoon sessions...

I see that visual basic code in my program but it does not work. I am lost. Clear filter does not clear the box and the number in the box does not...

Why VBA? In File Explorer and with the folder view set to Details right click on a column header and choose Dimensions from the columns list. Done.