Recent content by Galaxiom

  1. G

    Give me some Advices

    Really basic backups can be done using the Windows Scheduler to run a cmd script with something like XCOPY or a powershell script to copy files to another network location. You also need to use a script to manage the archiving of the backups at the other location. You need to be aware of the...
  2. G

    Looking for Correct Snbtax

    Try this; m = Form_frmMain.DoDur(i)
  3. G

    Want to Challenge Yourself to Better Troubleshooting?

    Yes not really the case in T-SQL. I have written queries that appeared to choke the server but they always turned out to have errors in the joins that ended up returned many tens of millions of rows. For reasons that don't make sense to me, it is possible to join two tables with a condition that...
  4. G

    Want to Challenge Yourself to Better Troubleshooting?

    BTW T-SQL queries and Stored Procedures incorporate virtually all of the functionality that Access developers use in VBA. They have variables, code loops, can work with the equivalent of Recordsets (known as 'cursors' in T-SQL) and build dynamic SQL commands to be executed. Consequently a T-SQL...
  5. G

    Want to Challenge Yourself to Better Troubleshooting?

    That particular query starts by writing a lot of temp tables using OPENQUERY on a Linked database connected to a Universe database via ODBC. By design, the Universe ODBC interface is sequential so multiple simultaneous connections are not possible. Performance with more than a couple of...
  6. G

    Want to Challenge Yourself to Better Troubleshooting?

    My opinion is objectively substantiated. Let me remind you of what you said. On another thread you claimed that "T-SQL was a very limited language" which clearly demonstrates you have VERY limited abilities in its use. You obviously don't realise that your knowledge of the platform is...
  7. G

    What's your best/worst joke?

    We had two channels that were selected by a very clunky knob. There was also the fine tuning around the outside of it. Then the vertical hold to stop it rolling up or down. Reaching over the back of the set there was the horizontal hold occasionally required to stop the picture getting all...
  8. G

    Error assigning a value

    Using the bang (!) is not a good practice for controls. It is a Late Bound Reference to the Default Collection of the Parent Object. As such the control it refers to will not be validated as existing during compilation. The dot (.) is an Early Bound reference and will be checked during the...
  9. G

    Error assigning a value

    It is often used, but the word "container" is a poor choice of terminology for the subformcontrol. Access already has a Container Object.
  10. G

    Error assigning a value

    The first one will only work on a specific form that is already open with that subform in it. Otherwise it will throw an error. The second one will open a hidden instance of the specified form object if it doesn't find an already open instance somewhere.
  11. G

    Setting RecordSource

    Since setting the RecordSource of a form programmatically is a trivial task per se, I assumed the OP was trying to set it before it opened so that the user wouldn't see it before it changed. Of course no well designed database should ever need to open any objects in design mode.
  12. G

    Setting RecordSource

    Open the form with it not Visible, set the RecordSource then make it Visible. IIRC the visibility can be controlled in the parameters of OpenForm
  13. G

    How to identify orphan variable/functions?

    Use the Total Search in V-tools.
  14. G

    Want to Challenge Yourself to Better Troubleshooting?

    Your dismissive arrogance is reaching new levels. You seem fixated on justifying your obviously limited knowledge of SQL Server. Are you really that insecure about it that you need to belittle others? What you are doing is systematically destroying the respect than many of us have always held...
  15. G

    Option Explicit ?

    Require Variable Declaration setting in the VBA editor will put Option Explicit on every new module. Am I missing something in what you are saying?
Top Bottom