Recent content by iimusicdev

  1. I

    having problems using public variables

    You don't use the public variables directly as the ControlSOurce Set the form fields to UNBOUND and then move the public variables into them or if they are linked to a table move the public variables into fields. It always works fine no problem. eg set Controlsource for Field1 = Unbound...
  2. I

    having problems using public variables

    Make sure the VBA code module for the form contains Option Explicit at the start. This forces it to check all variables actually EXIST. It should be mandatory but I think it's optional Without Option Explicit, the code generates the variables by itself as it finds them. It means that if...
  3. I

    ODBC disconnect after many time does not to use

    The problem is the setting of the timeout on the MYSQL Server. It's intended to be short so that Web Users are not hogging the resource. For a private system, like your Access Front End MySQL Backend, you should change the time out value to be much higher, so allowing a much longer connection...
Back
Top Bottom