Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.73K
~1K People Reached
Favorite Forums
Favorite Tags
1 Posted Topic
i have this code worked for me. thanks for the idea. Sub createTblOnTheFly() Dim strSQL As String strSQL = " CREATE TABLE TimeRecord (IDNo Text(30), DTR_Date datetime, TIME_IN datetime, TIME_OUT datetime, LB_IN datetime, LB_OUT datetime, CB_IN datetime, CB_OUT datetime)" Dim myConnection As ADODB.Connection Set myConnection = New ADODB.Connection myConnection.ConnectionString = …
The End.