Search results

Thank you all! TheDBGuy, your solution seems to work well. I am not sure if they'll ever change the first bit of the document name to be more than two characters in the future, but for now, it always starts with two characters before the first "-". Would there be a way to do this if they did...

Hi. I know I've done this before, but for the life of me, can't remember how. I need to be able to extract a string that will vary in length, that will always be between to characters. For example, these are document names: 02-20-00-AI-0035 02-2006-00-HG-0137 02-21-00-JW-1001...

I have a table with one column being a new, consecutive date in each record. For each date there are three columns that gives the day's total received count, verified count and cleared count. I would like to add three new columns with the running totals for each received, verified, and cleared...

Okay, apparently the DoCmd.Hourglass False IS right, I just had it on the wrong line of code. I needed it to be the first line. Thanks!

I appreciate it, but I've tried that. No go.

Hello, I have a table that is linked to SharePoint with two columns. One is the ID, the other is a checkbox labeled "Activate." I also have a form for this table that, when "Activate" = -1, displays a msgbox to all users that an update is being pushed out (from the back end database) and...