Search results

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.

Perhaps you want to take a look at this "Enhaced Message Box" . It can be configured with a timer.

Public and Global are nearly identical in their function, however Global can only be used in standard modules, whereas Public can be used in all contexts (modules, classes, controls, forms etc.) Global comes from older versions of VB and was likely kept for backwards compatibility, but has been...

Perhaps you are talking about the TempVars object?

AFAIK, because is not possible to recover the old password What can be done is to change the current password and assign a new one. After that VBA module protection can be disabled.

You are right. The 65K row limit is for XLS files not for XLSX files.

IMO the fastest way to update single record on a table with thousands of records is using the "seek" & "update" Methods in a indexed tabledef recordset (Only for MS Access BE)