Recent content by dejones923

TL_Mike: Made a couple of modifications. --Your filter was a littel "jacked up" --You must create a recordset before updating the "MemoPrinted" field. See attachment

Backing out Weekend Days This is what I used to back out the weekend days between two different dates in determining lagtime; basically by using DateDiff function.

Take a look at the example below and use it to modify your code: Your 'where' clause seems to have a conflict. It seems like "hireno" is an integer, but your previous code seems to be treating it as it is a string. If "hireno" is indeed an integer then change the SQL to the following line of...

I would recommend setting a reference to "Microsoft Scripting Runtime" and use the "Scripting.FileSystemObject" to do what you stated.

Use FileSystemObject I recommend referencing "Microsoft Scripting Runtime" library and use the "Scripting.FileSystemObject" to do what you need.

I am trying to replace a tab characters from a string with nothing, see below: "tab1 here" SCOPING AND SCREENING RESULTS: ELECTRICAL AND INSTRUMENTATION "tab2 here" "tab3 here" AND CONTROLS SYSTEMS The following line of code removes all but tab3. I have checked to see that it is a tab using...