Recent content by CedarTree

  1. C

    Macro settings

    I suppose they would be... didn't know there was a cost!
  2. C

    Macro settings

    Hello. IT policy is now limiting macros in Macro settings. They mentioned we could use a digital signature for our end-users. Any advice/suggestions on how to go about doing that? Thanks!
  3. C

    "Cannot open a form whose underlying query contains" error...

    Nope. No use of recordsetclone anywhere.
  4. C

    "Cannot open a form whose underlying query contains" error...

    I randomly will get this error when a form has been open for a while (whose underlying data is linked to an external data source, e.g., Sharepoint). I click Okay a couple of times, and life goes on as usual. The underlying data queries that support my forms/subforms are super simple - not using...
  5. C

    Visible property is variable?

    So, on_current was my thinking as well... the Project Type won't be changing (thankfully) -- but when someone navigates to a different project type, the on_current should work. Unfortunately, the Visible property I can't directly set to be equal to a boolean type function. Ah well...
  6. C

    Visible property is variable?

    Hello - I want to have a primary subform and then based on what a specific data field within that form is, e.g., "project type", have another subform appear or disappear. So, for example, if project type = "quantum mechanics" (QM), then QM subform would be visible. But if project type = "Time...
  7. C

    Failsafe ways to open Access and run a macro and close

    The solution: Task manager hides an app when you click on "Run whether I'm logged in or not" option. Now it works!
  8. C

    Using Access to update a Sharepoint "Choice" field

    Thanks - will try when I have some more time later this week. Thanks!
  9. C

    Failsafe ways to open Access and run a macro and close

    Right - I meant I can't EVEN just open Access. Eventually, I want to use the /x switch.
  10. C

    Using Access to update a Sharepoint "Choice" field

    Built from scratch. Definitely a choice field. A little hard to share due to proprietary data, etc.
  11. C

    Using Access to update a Sharepoint "Choice" field

    In SP, it's a choice field. And I just double checked the field names (in SP). Still no luck so far.
  12. C

    Failsafe ways to open Access and run a macro and close

    So when I try to open Excel or Access via task scheduler (on a 2019 MS Server), it doesn't open it -- or at least doesn't open it visibly? Any special hints/tricks here? And this is without any special X switches, etc. Just wanna open Access!
  13. C

    Using Access to update a Sharepoint "Choice" field

    Nope - I get a Method value of field error.
  14. C

    Using Access to update a Sharepoint "Choice" field

    I'll give it a shot...
  15. C

    Using Access to update a Sharepoint "Choice" field

    Right - I started with an update query and could not get it to work. So I thought maybe coding would give me more control/debugging capability.
See more
Back
Top Bottom