Search results

  1. C

    How do i add a textbox to a graph ?

    As subject, please advise because during run time, the text box appear at the back of graph although I have send the text box to the front and bring the graph to the back.
    • cheer
    • Thread
    • Replies: 3
    • Forum: Forms
  2. C

    Refresh Report (Report On top of Form)

    Let say I got report which contain bar chart on top of form (GUI), how to refresh the report live when data is changed ?
  3. C

    How to bind ADODB recordset to SubForm ?

    I know how to bind ADODB recordset to MainForm, how about the SubForm ? Can anyone suggest as I have worked out the below through Main form concept, however, it won't work for SubForm. Codes that I have tried it out are :- 1) Forms![MainForm]![SubForm].Form.Recordset = rsTemp 2)...
  4. C

    Object variable or With block variable not set

    I am using ADO to made connection to SQL Server. I got the error saying "Object variable or With block variable not set " intermittent when SQL to issue to select a table via the ADO record set. To further explain the scenario, the table is tightened up with a Sub Form permanently and the main...
  5. C

    Error : "The database has been placed in a state by user <name> on machine <name>

    Error : "The database has been placed in a state by user <name> on machine <name> After reading the link, http://www.source-code.biz/snippets/vbasic/10.htm , I am still facing problem intermittent having the error "The database has been placed in a state by user <name> on machine <name> that...
  6. C

    VBA code to check each MS Object object size

    I would like to ask if the MS Access provide codes to check the size of each object such as Access table, linked table, linked query, Access query, form, table, macro, module and etc.
  7. C

    Send a printing to a selected printer

    How to send a printing to a selected printer chosen in a combo box ?
  8. C

    Merging 2 PDF File Under The MS Access 2016

    Under the MS Access 2000, the StrStorage.dll is workable if you are using the download library file from http://www.lebans.com/reporttopdf.htm However, the library file is not working under the MS Access 2016 and error stop at hLibStrStorage = LoadLibrary( "StrStorage.dll") although you have...
  9. C

    Delete A File API Windows 2012 Server, 64 b

    Can anyone suggest what are codes to delete a file by using the API method ?
  10. C

    Copy File API Windows 2012 Server, 64 bit

    Can anyone suggest how to modify the below to suite to the MS Access 2016, 64 bit and Windows 2012 Server, 64 bit
  11. C

    Browse Folder Screen (Windows 2016 Server (64 bits))

    Anyone know how to write API codes to display the Folder Browse under the Windows 2016 Server (64 bits). My previous API codes fine under the Windows 2013 Server (64 bits) and the Windows 7 (64 bits). The previous API codes (compliance with the Windows 2013 Server [64 bits[ and the Windows 7...
  12. C

    Customised Ribbon To Call Form

    Anyone know any sample can be downloaded to write codes to create customised ribbon and then to call form. TQ
  13. C

    Break / Pause VBA command

    If I Step Into (F8) codes, application won't produce any error in DB connection, but if I execute / run the entire application, it will produce error "ODBC--connection to 'erpServer' failed" The only different I can think off is there is a break / pause during Step In activity regardless how...
  14. C

    OLE Connection String - Access 2016

    Anyone know what is the right OLE Connection String for the MS Access 2016 (64 bits) as I have tried Microsoft.ACE.OLEDB.12.0 , sometime it is working, sometimes the connection can't be established. OLEDB.12 should the driver for the MS Access 2013
  15. C

    How to write shortcut menu ? (See attachement)

    Presently, I have a sub function to create shortcut menu for a table as shown below Can anyone suggest how to add on further extra shortcut menus as shown in the attachment below ?
  16. C

    Remove MS Access startup screen

    Remove MS Access startup I have few forms and one form has been chosen to set as startup. During the execution of the accde file, the MS Access has prompted the startup screen. Can anyone give some thoughts how to remove it . I have shown it in attachment for better understanding. TQ
  17. C

    Date Type Default Value : =Date() Error

    Can anyone suggest how to fix the error inside the attachment ?
  18. C

    Code works when stepping but not when running

    It work perfectly when in MDB when execute from main screen till the screen you are looking for. However, after migrating to Access 2017 (64 bits) and Windows 2012 Server (64 bits), a lot of problem errors seem like appear. Anyone know why it behave abnormally at the highlighted code in red...
  19. C

    What is the msoControlButton ID to create "Filter For" or "Text Filter -> Equal"

    What is the msoControlButton ID to create "Filter For" or "Text Filter -> Equal" As subject, is anyone know what is the msoControlButton ?
  20. C

    CopyMemory API Crash At Windows 2012 Server

    Program show crash after migrated from Windows 2003 Server to Windows 2012 Server and crash happen at CopyMemory Can anyone help to modify the code ?
Top Bottom