I encountered several problems while doing the database, please help

toptime

1\How to convert a string into a time class?

I use the following to change the date
Format (CDate (txtvalue.Text), "yyyy-mm-dd")

But turn time
Format (CTime (txtvalue.Text), "hh: mm: ss")

Looks like there is no ctime function


2\I now have an mdb database named default. There is a table of "test records" ...
Then I wrote this program
Dim conn As New ADODB.Connection
Dim rs_data1 As New ADODB.Recordset
Dim connectionstring As String
connectionstring = "provider = Microsoft.Jet.oledb.4.0; data source = default.mdb"
conn.Open connectionstring
rs_temp.CursorLocation = adUseClient
rs_temp.Open sql, conn, adOpenKeyset, adLockPessimistic

Now the data record is in re_temp ... but how to make the searched record into a table in default?

Thank you all in advance!

toptime

The first issue has been resolved:
Format (CDate (txtvalue.Text), "hh: mm: ss")
You can also use cdate ... haha ​​... I found a good dish

toptime

Nobody know?

大嘴王

It is best to add a judgment if isdate (format (txtvalue.text), "yyyy-mm-dd") = true then whether it is a date format
.

direman

The second problem I have encountered before, we can quit and think about it. In the program, we do not use the program to create. Then we create a new table to process or release the records you searched out: "But it will trouble you. Multi-connection data sheet:

toptime

Does the upstairs mean that the table is created manually in access?

siyonggang

It's no different from handmade
Just use the code to create a table in the default, and then write line by line.

But what tools should access do for this?

四不像君

You can directly execute a SQL statement.
Insert Into [table1] Select [Columns] from [table2]
or
Select [Columns] From [table1] Into [table2]

charrrr

To manually create a table in access and then execute the insert statement in the code, this is the idea, check the syntax specifically.
Generally for tables and other things, it is still built in the database. The functions completed by the program are add, delete, and modify. Tables are not normally created in the program.