Next would be the timestamp that is the next largest
Example:
Bob Sign Off Break 8:15
Bob Sign On Automatic 8:30
This would become:
Bob Sign Off Break 8:15 8:30
I have a table named Sign_On that looks like the following:
User1 Event1 SubEvent2 TimeStamp
User1 Event2 SubEvent1 TimeStamp
User1 Event1 SubEvent3 TimeStamp
User1 Event2 SubEvent1 TimeStamp
User2 Event1 SubEvent2 TimeStamp
User2...
I am in the process of trying to write a script that will send an individualized report daily to each user within a table.
Employees Table
EmployeeID - Key
Ext - Unique value but contains blanks
Email - Email address
What I am trying to do is to run a report daily for each Ext that shows the...
I did that as well, and I think I have something wrong elsewhere in the system. I put the correct connect strings in the MSysObjects table and the tables still open incorrectly, however if I leave out the UID and PWD and have the system prompt me for these values it works fine.
That did not work. I even broke it into two separate functions for "STO_" and "SAC_". Every time it links all linked tables to last DSN listed in tdf.Connect. Any ideas?
I have a database that has linked tables in it from two different data sources. The tables from the first data source begin with SAC_ the tables from the second data source begin with STO_. What I have go so far is:
Function refreshLinks() As Boolean
Dim dbs As DAO.Database
Dim tdf...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.