Activity Stream

Perhaps explain a little more of why they are like that. Generally, repeating groups become separate records, but that is not 100% all the time.

There is an other way to design. But, it would Take more complicated way to code it in VBA and SQL. I'm not professional ..

All of those fields should not be in 1 record

Hi, I made this design because there is relation (formula) taking in consideration qte1m to qte6m ... or nb1m to nbm4m in the same record ..

Yes cascading, sounds like what you need. Plenty of data on those. Might want to start with a quick Google...

Use a fixed width font?

Hi You need to look at the design of your tables. Your table MVMT has what are known as repeating groups. The fields qte1m through to qte6m...

This article may help Accurately Move Forms & Controls (isladogs.co.uk) See sections on trips, pixels & points together with the use of the hidden...

Thank you CJ_London, I tested the date format yyyy-mm-dd and it works perfect :thanks:

other problem you have - in sql, when dates are expressed as a string they need to be in the format of mm/dd/yyyy or the sql standard of yyyy-mm-dd....

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