Value not updating unbound ole object

18-Sep-2019 07:53

I have put in waits and msgboxs to see if it is a timing / load issue. Thanks I have a unbound MS graph object built as a pie chart that I set to a value list and I am updating programatically. But without the breakpoint the chart does not show until all the code in the button is completed (the graph is rebuilt about 6 times during this code).

value not updating unbound ole object-30value not updating unbound ole object-40value not updating unbound ole object-7

These objects are declared directly as OO4O objects, rather than as generic objects which are later reclassified as OO4O objects. Execute Sql("insert into emp values (: EMPNO,: ENAME,: DEPTNO)"); Next I 'ENAMEARR,: EMPNOARR,: DEPTNOARR are parameter arrays For I = 1 to 100 Ora Parameter("EMPNOARR"). Execute Sql("insert into emp values(: EMPNOARR," & _ ": ENAMEARR, : DEPTNOARR)"); ) option.

Are you looking for something fully automated based on the folder and file name or are you looking for something like drag and drop?

the filename is aquired via a browse option, I have it implented.

ADO is the default object library for Access, but DAO is still available.

If you use a DAO Recordset, you must explicitly reference it.

These objects are declared directly as OO4O objects, rather than as generic objects which are later reclassified as OO4O objects. Execute Sql("insert into emp values (: EMPNO,: ENAME,: DEPTNO)"); Next I 'ENAMEARR,: EMPNOARR,: DEPTNOARR are parameter arrays For I = 1 to 100 Ora Parameter("EMPNOARR"). Execute Sql("insert into emp values(: EMPNOARR," & _ ": ENAMEARR, : DEPTNOARR)"); ) option.Are you looking for something fully automated based on the folder and file name or are you looking for something like drag and drop?the filename is aquired via a browse option, I have it implented.ADO is the default object library for Access, but DAO is still available.If you use a DAO Recordset, you must explicitly reference it.Referencing both libraries is likely to generate an ambiguous object error.