need help to save date to access in vb6

Question

1.00/5 (1 vote)

See more:

Hi all , in my vb6 project i have a button that adds new row to ms access database from textboxes
, One of the fields is with date data type . i tried this code but it does not work

VB

Adodc1.Recordset.AddNew
Adodc1.Recordset(0).Value = val(text1.text)
Adodc1.Recordset(1).Value = text2.text
Adodc1.Recordset(2).Value = val(text3.text)
Adodc1.Recordset(3).Value = "# " & Text4.Text & "#"       ' this to send date to specified cell in a field

Adodc1.Refresh
DataGrid1.Refresh

if any body have this solution , so help me :) and thanks

Posted 12-May-14 11:21am

Hamdi Choban

Add a Solution

Comments

j snooze 12-May-14 17:32pm

I see a space between the first # sign and your date textbox. Are you sure its the date, what is the error?

Hamdi Choban 12-May-14 18:06pm

the error was .the date can not be saved to database and the error msg from vb was "multiple step generated error"

[no name] 12-May-14 17:36pm

"does not work" tells us nothing about what you see on your screen or what errors you get.

Hamdi Choban 12-May-14 18:07pm

i see error message like that "multiple step generated error"

2 solutions

Solution 1

I assume that you know how to add reference to MS ActiveX Database Objects x.x libary[^].

To add data to MS Access database, you need to create ADODB.Connection[^]. Next, you need to create ADODB.Command[^] with this sql statement:

SQL

INSERT INTO <TableName> (NumericField, TextField, DateField)
VALUES (1, 'SomeText', #yyyy/MM/dd#)

Finally, you need to call Execute Method[^].

Note: Connection string[^] depends of MS Access database version (*.mdb or *.accdb).

Posted 12-May-14 11:54am

Maciej Los

Comments

Hamdi Choban 12-May-14 18:14pm

thanks Maciej Los :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hamdi Choban · Accepted Answer · 2014-05-12T12:12:00

Solution 2

i found my error , it was wrong to send date from vb6 to database with two # [in begin and end] in case if used adodc1.recordset.addnew Method .... But we should add # to begin and end of the date if we used the method of sql query .. thanks for you all for you comments and Answers :)

Posted 12-May-14 12:12pm

Hamdi Choban