Search results

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)

Perhaps using the scrollbar activeX control instead the default vertical scrollbar in the continuous form can solve your problem, because you'll have to code when and how scroll the records.

Perhaps this can help you, but I suggest you to listen the advice you have been given: ? Format("49","####") 49 ? Format ("49","0000") 0049

You shoudn't link an image from your local/shared disc, the image must be accessible from the internet. If you want to embed the image into the mail body, you have to search information about "AddRelatedBodyPart" Set Attachment = Message.AddRelatedBodyPart(CurrentDBDir() &...

If I print some hexadecimal values, this is the result: ? &HF 15 ? &HFF 255 ? &HFFF 4095 ? &HFFFF -1 ? &HFFFFF 1048575 ? &HFFFFFF 16777215 ? &HFFFF = &HFFFFFFFF True ? &HFFFF , &HFFFFFFFF -1 -1 All hex decimal values from &H0000 to &HFFFF are considered signed integer type so...

Characters that are shown in a textbox depends on the font you are using in the textbox. Some fonts have more unicode characters defined than others.

Are you talking about twinbasic? I can't post links, but if you are talking about twinbasic it would be easy for you to find it.