Search results

  1. 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...
  2. 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...
  3. 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!
  4. C

    Using Access to update a Sharepoint "Choice" field

    Thanks - will try when I have some more time later this week. Thanks!
  5. 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.
  6. 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.
  7. 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.
  8. 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!
  9. C

    Using Access to update a Sharepoint "Choice" field

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

    Using Access to update a Sharepoint "Choice" field

    I'll give it a shot...
  11. 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.
  12. 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...
  13. 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...
  14. 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?
  15. 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!!!
  16. C

    Cannot update Sharepoint list

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

    Cannot update Sharepoint list

    Thanks. All the same options as you have above (i.e., no requirements that the field be filled in, or unique values). No lookup fields. Here's the error:
  18. C

    Cannot update Sharepoint list

    Hello - trying to run an update query on a linked Sharepoint list in Access. I can manually change SOME of the rows, but not all (get a valid values/data integrity error). I'm not aware of any validations within my list, the field I'm updating is a text field, and I can't see any obvious...
  19. C

    Determine which tables are no longer used

    Hello - inherited an Access database with lots of tables that I suspect are not being used. How can I "audit" which tables are not not being referred to in any queries, modules, etc. so that we can slim down the DB (I would move the un-used tables to a backup DB just in case of course). Thanks!
  20. C

    File Dialog with Default Value that has Spaces

    Not easily since these are files that are sent periodically by an external source.
Back
Top Bottom