• WSjaf90

    WSjaf90

    @wsjaf90

    Viewing 11 replies - 166 through 176 (of 176 total)
    Author
    Replies
    • in reply to: Create a new record in another table (2000) #754538

      Using an append table worked great – thanks

    • in reply to: Create a new record in another table (2000) #754539

      Using an append table worked great – thanks

    • in reply to: Create a new record in another table (2000) #754508

      I’m not familiar with DAO or ADO.
      The option of using an append query sounds a possibility – I’ll investigate that one further.
      Yes, the PODel table is linked to a table in another database.

      As I right in thinking that once I’m working with one dataset (I know as much about datasets as I do about DAO and ADO) the only way to add to another table is via this route of an append query or the DAO ADO option
      John

    • in reply to: Create a new record in another table (2000) #754509

      I’m not familiar with DAO or ADO.
      The option of using an append query sounds a possibility – I’ll investigate that one further.
      Yes, the PODel table is linked to a table in another database.

      As I right in thinking that once I’m working with one dataset (I know as much about datasets as I do about DAO and ADO) the only way to add to another table is via this route of an append query or the DAO ADO option
      John

    • in reply to: Slow startup (2000) #753257

      Open WSord…get blank Document`
      Double click on desktop replaces Document1
      I’ve checked for add-ins
      I’ve checked for other macros being loaded
      I’ve deleted the normal.dot to start afresh
      None of the above seems to speed up the loading
      Move on to next version of Office??

    • in reply to: Slow startup (2000) #753258

      Open WSord…get blank Document`
      Double click on desktop replaces Document1
      I’ve checked for add-ins
      I’ve checked for other macros being loaded
      I’ve deleted the normal.dot to start afresh
      None of the above seems to speed up the loading
      Move on to next version of Office??

    • I’m sure there will be plenty of other methods which much more able people than me will post, but the easiest way i have found is to use an unbound box and query on its contents

    • Check the location of your user templates and workgroup templates. Though you may not have write permissions to your workgroup templates, someone else may. This can cause a problem if someone else changes the template while you are using it – if they have changed the toolbars, then you will feel the effects.
      The only way to protect this is to make the workgroup templates read-only for everyone. Any changes can then only be made when by copying across a new version of the workgroup template while no one else is using the original.
      To test this, try changing the location of the workgroup templates to an empty folder – see if you get the problem – if not, then hit the IT department and give them the solution
      John

    • in reply to: multiple openreports (2000) #657065

      I just didn’t appreciate that the normal view sent direct to the printer – not sure what else i expected it to do, but i’ve only just moved into using VBA instead of macros – getting there slowly

    • in reply to: Report using critera entered list box (2000) #656520

      Thanks for getting back so quickly.
      I understand the idea of building a criteria line, but not the “how to”.

      I don’t know how to reference the entries in the list box to see if they have been selected or not.

      There is/are a variable number of lines per factory, so I can’t reference them as line01, line02, line03 etc

      I was expecting to have to do something like the following:

      start at the top of the line list box
      if not the end of the list
      if the line has been selected
      run report using the factory, date and this entry for line
      endif
      move down the list
      endif

      I know the syntax of the above isn’t right, but it’s the thought that counts

      Anyone give better guidelines for what it should be?

      John

    • in reply to: Check if a form is already open using macro (2000) #655024

      thanks all for your help – i’ve pieced together enough to sort the problem from your replies

    Viewing 11 replies - 166 through 176 (of 176 total)