Search results

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

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

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

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!!!

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

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:

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

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!

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

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?

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

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

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!

Thanks - I'll try that!

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

VERY VERY WEIRD!!! Thanks for trying!!!

PS, I believe you can export a recordset to a specific Excel location (using recordsets?)... so this would go the other way.

Hello - I have an Excel workbook that has a complex structure, and so I can't just import the whole thing into Access using VBA. Rather, I want to import certain rows into a pre-existing Access table (all Cols exist in Access, but all Cols may or may not exist in Excel). I have coding working to...

Very strange. I would end up getting "Only.accdb". PS, I also have an "!" in the beginning of the final folder name (e.g., \TDS Economy\ in your example, would be \!TDS Economy\, but that shouldn't impact things I would think.

Hmmm... the filename has a "!" at the beginning... would that impact things?