Home > Archive > Programming Jobs > August 2006 > Newbie VB6 database question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Newbie VB6 database question
|
|
| bdannels 2006-07-19, 7:44 am |
| Hello:
I am trying to build a program in VB6 that connects it to a MSaccess database using
a Adodc control with a DataGrid.
In the program, I have a text box (txtStartDate) bound to a date field in the database.
When I enter a date in the (txtStartDate) it adds the date to the database field (ldate).
Sometimes I need to remove the date from the field. That is, put the database back the way
it was before I entered a date. When I delete the date from the text box
and the database updates, I get a error: ERROR OCCURED WHILE TRYING TO SET CURRENT ROW.
Looking for some help to be able to remove the date from the database with out the error.
Thanks for your time
Bill Dannels | |
| bdannels 2006-07-29, 5:54 am |
| quote:
Originally posted by bdannels
Hello:
I am trying to build a program in VB6 that connects it to a MSaccess database using
a Adodc control with a DataGrid.
In the program, I have a text box (txtStartDate) bound to a date field in the database.
When I enter a date in the (txtStartDate) it adds the date to the database field (ldate).
Sometimes I need to remove the date from the field. That is, put the database back the way
it was before I entered a date. When I delete the date from the text box
and the database updates, I get a error: ERROR OCCURED WHILE TRYING TO SET CURRENT ROW.
Looking for some help to be able to remove the date from the database with out the error.
Thanks for your time
Bill Dannels
| |
| bdannels 2006-07-29, 5:55 am |
| Just checking to see if this forum works. | |
|
| Hi,
Instead of using the control, you program to get more control.
Regards
bhar
knowledge is power
http://www.vkinfotek.com
quote:
Originally posted by bdannels
Hello:
I am trying to build a program in VB6 that connects it to a MSaccess database using
a Adodc control with a DataGrid.
In the program, I have a text box (txtStartDate) bound to a date field in the database.
When I enter a date in the (txtStartDate) it adds the date to the database field (ldate).
Sometimes I need to remove the date from the field. That is, put the database back the way
it was before I entered a date. When I delete the date from the text box
and the database updates, I get a error: ERROR OCCURED WHILE TRYING TO SET CURRENT ROW.
Looking for some help to be able to remove the date from the database with out the error.
Thanks for your time
Bill Dannels
| |
| bdannels 2006-08-06, 5:55 am |
| bhar:
Thanks for your reply, it was very helpful. :(
bdannels
quote:
Originally posted by bhar
Hi,
Instead of using the control, you program to get more control.
Regards
bhar
knowledge is power
http://www.vkinfotek.com
|
|
|
|
|