Search results

  1. X

    Solved query based on a snapshot query retrieve the ability to modify data !

    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!
  2. X

    Unicode string utility functions

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

    Unicode string utility functions

    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...
  4. X

    This database was created with the 64-bit version of Microsoft Access. Please open it with the 64-bit version of Microsoft Access.

    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.
  5. X

    The Name function

    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.
  6. X

    Solved MsgBox Stops Detect Idle.

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

    Solved Global Object

    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...
  8. X

    Solved Global Object

    Perhaps you are talking about the TempVars object?
  9. X

    Getting old forget mdb password

    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.
  10. X

    32 bit to 64 bit?

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

    Looking for Faster way to update Table - boolean field

    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)
  12. X

    Stop Vertical Scroll bar from go down after reach the end of continuous subform

    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.
  13. X

    Format to result in 4 digits

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

    Solved Format Email Body

    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() &...
  15. X

    Warning when using Hexadecimal values in VBA.

    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...
  16. X

    Insert Unicode Character in textbox

    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.
  17. X

    Request for Assistance in finding a particular post.

    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.
  18. X

    32Bit To 64Bit Conversion.

    Perhaps the basMouseHook by Wayne Philips disables the mouse scroll wheel in Access forms, it only works in 32 bit MS Access. AFAIK there is no 64 bit version and no way to disable the mouse scroll wheel in 64 bit MS Access. If I'm not mistaken if you want to disable it, you have to comment...
  19. X

    .send - anyway to continue processing & not wait. Using CDO. schemas to send emails

    According the code you posted, SSL is not configured.
  20. X

    .send - anyway to continue processing & not wait. Using CDO. schemas to send emails

    No you should ask your SMTP provider what configuration you have to use when using SSL and then configure it in the CDO procedure. Search in google: 'sending messages using SSL authentication in CDO' Lately it's recomended to use SSL when sending messages.
Back
Top Bottom