Search results

  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.
  16. C

    Using Access to update a Sharepoint "Choice" field

    sql = "SELECT * FROM Table" sql = sql + " WHERE ChoiceField.Value = 'N/A' OR ChoiceField Is Null" Set rst = CurrentDb.OpenRecordset(sql) If Not rst.EOF Then rst.MoveFirst While Not rst.EOF rst.Edit...
  17. C

    Using Access to update a Sharepoint "Choice" field

    Hello - I have a choice field in SP, that has as one option this "---". In fact, that is the default value in SP when adding a new record, although (perhaps b/c of the format), it doesn't work so I have to go in and choose "---" as the choice for new records. I figured I would try to...
  18. C

    Failsafe ways to open Access and run a macro and close

    So I'm guessing I set-up a CMD line bat file that I run on a schedule?
  19. C

    Failsafe ways to open Access and run a macro and close

    Hi... looking for best ways to use Windows task scheduler to open up Access (not hidden!), run a macro, and auto close. Say once a day. Use a batch file maybe? Sample code please? Thanks!!!
  20. C

    Cannot update Sharepoint list

    Ha - turns out it wasn't a lookup field, but an unrelated choice field that was causing the issue.
Back
Top Bottom