Recent content by cheer

  1. C

    How do i add a textbox to a graph ?

    I got my answer by replacing text box with label. TQ
  2. 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
  3. 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 ?
  4. 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)...
  5. 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...
  6. C

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

    Re: Error : "The database has been placed in a state by user <name> on machine <name> My BE is SQL Server, of course the basic understanding is the linked tables. I have other Access tables locate at same place as other objects such as queries, forms, reports, macros, module. Those tables are...
  7. C

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

    Re: Error : "The database has been placed in a state by user <name> on machine <name> Sometimes connection just work without problem. Intermittent is OK. What is the best way to split?
  8. C

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

    Re: Error : "The database has been placed in a state by user <name> on machine <name> What FE do you mean at here ?
  9. C

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

    Re: Error : "The database has been placed in a state by user <name> on machine <name> Are you saying the DB size is too big ?
  10. C

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

    Re: Error : "The database has been placed in a state by user <name> on machine <name> Yes. Through ADO connection.
  11. C

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

    Re: Error : "The database has been placed in a state by user <name> on machine <name> I also have read link from https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother/database-has-been-placed-in-a-state-that-prevents/e9cafb89-38d9-47db-a798-d4b6c8d031c1 , but no...
  12. 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...
  13. C

    VBA code to check each MS Object object size

    TQ. I got what i am looking for ! :p:p:p
  14. C

    VBA code to check each MS Object object size

    Should be linked table. Not the linked query. Besides the solution that you have provided on the above for the number of rows, anyone can suggest codes to check for each object size ?
  15. C

    VBA code to check each MS Object object size

    TQ. How to do that ?
See more
Top Bottom