Search results

Welcome Francesco.

Yes, I agree with you. My post is only a warning.

If I'm not mistaken, creating dynamic controls doesn't work on MDE/ACCDE databases, so I hope you don't have to convert your database.

I thing you'll need a dummy table with 52 rows, one for each week of the year and join it with your data.

I can filter both columns without any issue too.

Perhaps you should use transactions to assure the stock is properly updated.

Basic tests: - Delete browse cache and cookies. - Test it using another browser - Test it on another computer,

I have always had to execute scheduled tasks using the option "Run only when user is logged on" on servers.

If you change the fld1 and fld2 type to Longtext in the table tbl your database example works properly:

Look at:

Read Allen Browne's tips:

In the JSON data I see: "totItemCnt": 2, And the "ItemList" array contains only one item instead of 2

Try using Application.RefreshDatabaseWindow : Private Sub CmdCreateTable_Click() Dim dbs As Database ' Modify this line to include the path to Northwind ' on your computer. Set dbs = Application.CurrentDb ' Create a table with two text fields...

Hi zelarra821, In the ACCDE the error raises in the line: Application.RunCommand acCmdSave If I'm not mistaken this instruction saves the current object, and it can only be used on ACCDB files. If you comment or delete this line, the table is properly created in the ACCDE file but not shown...

I don't know if this can can help you: I've tested the code on 32 bit MS Access 365 using Early Binding with no issues: Call SendToExcel ("Consulta1","Sheet1","c:\Tmp\Cambridge.xlsx") strTQname: Consulta1 strSheetName: Sheet1 strPath: c:\Tmp\Cambridge.xlsx

FYI, the same behaviour on MS Access 2010 and on MS Access 2003. I agree with The_Doc_Man, it has to be considered a bug!

Perhaps I should be used the nomenclature "decomposed form of a character" instead of "composite character" Some references (I can't post links) :

VBA string functions: Len(),Right(), Instr(), etc. don’t work as expected with Unicode strings that contains code points above 65535, so I developed some string functions to manage this kind of strings. I know that Unicode characters above 65535 are rarely or never used, but I think it’s...

ACCDE databases can only be oppened with the same bitness of MS Access they were created. So 64 bit ACCDE can only be opened on computers with 64 bit Ms Access and 32 bit ACCDE can only be oppened on computers with 32 bit Ms Access.

Try to change the statement "Name ..." with "VBA.name ..." (Not tested). Because "name" Is also a property of the form object. If you include VBA. name you'll force to use the statement.