Consulting

Results 1 to 4 of 4

Thread: As Soon As Possible / As Late As Possible switch for all activities

  1. #1
    VBAX Newbie
    Joined
    Mar 2022
    Posts
    5
    Location

    As Soon As Possible / As Late As Possible switch for all activities

    Hello and thank you for any help in advance.

    I would like to automate proces of switching all activities constraint type to "As Late As Possible" so I dont have to switch activity by activity. Is there a vba solution for this? Also, is there a way to return it back to "As Soon As Possible" with VBA?

    Greetings,
    Bdasovic

  2. #2
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    323
    Location
    Are you asking how to change value of a field for all records? You can execute an UPDATE action SQL. What exactly do you not understand about UPDATE action? Use Access query designer or wizard. If you want to automate in VBA, use DoCmd.RunSQL or CurrentDb.Execute methods.
    How to attach file: How to upload your attachments (vbaexpress.com) To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    VBAX Newbie
    Joined
    Mar 2022
    Posts
    5
    Location
    I am not sure how to use any of mentioned fuctions. I am using MS Project desktop application, and I have zero knowledge of SQL. Is there a way to change these values from vba withim MS Project desktop application?

  4. #4
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    323
    Location
    Sorry, I know nothing about MSProject. I was thinking this was Access database.
    How to attach file: How to upload your attachments (vbaexpress.com) To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •