Search results

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

    Using Access to update a Sharepoint "Choice" field

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

    Using Access to update a Sharepoint "Choice" field

    I'll give it a shot...
  4. 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.
  5. 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...
  6. 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...
  7. 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?
  8. 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!!!
  9. C

    Cannot update Sharepoint list

    Ha - turns out it wasn't a lookup field, but an unrelated choice field that was causing the issue.
  10. 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:
  11. 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...
  12. 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!
  13. C

    File Dialog with Default Value that has Spaces

    Not easily since these are files that are sent periodically by an external source.
  14. C

    Quickly copy Excel rows to Access

    It's the row number in the Excel sheet. I wonder if I could use the row function on Excel somehow in the SQL statement?
  15. C

    Quickly copy Excel rows to Access

    Right - the row # needs to be tied to another column which tells me the Excel worksheet. So row #1 might repeat many times.
  16. C

    Quickly copy Excel rows to Access

    No, and would be difficult since the PK would be based on several fields.
  17. C

    Quickly copy Excel rows to Access

    Works like a charm. Follow-up question is how to add a running "row" # to the SQL statement in case a specific record needs to be audited. Thanks!
  18. C

    Quickly copy Excel rows to Access

    Thanks - I'll try that!
  19. C

    File Dialog with Default Value that has Spaces

    It's just the !, not really "!". But also these are the filenames that a client sent us.
  20. C

    File Dialog with Default Value that has Spaces

    VERY VERY WEIRD!!! Thanks for trying!!!
Back
Top Bottom