HOW CAN SYSTEM DATE N TIME BE CAPTURED IN A TXTBOX

cnkumar74 · February 10th, 2007, 07:21 AM

Dear Member,

I am having a form, in which I have three fields Customer Number, Date n Time. I want the System date and time to be written in these textboxes.How can I do it? Ie, When a complaint arrives the Complaint Number should be automatically shown, and also the Date n time shown the system date n Time.

Nanda Kumar

HaveHave2222 · February 10th, 2007, 08:36 AM

In Vb2005

' Displays the date
Me.TextBox1.Text = DateTime.Now.ToShortDateString

' Displays the time
me.textbox1.text = datetime.now.ToShortTimeString

cnkumar74 · February 12th, 2007, 02:04 AM

Quote:

quote:Originally posted by HaveHave2222
In Vb2005

' Displays the date
Me.TextBox1.Text = DateTime.Now.ToShortDateString

' Displays the time
me.textbox1.text = datetime.now.ToShortTimeString

Thanks 4 ur reply.I tried it. but, not functioning properly. I changed the name of the textbox to txtDate and txtTime.

Me.txtDate.text = DateTime.Now.ToShortDateString

Me.txtTime.Text = DateTime.Now.ToShortTimeString. Is this statement correct?

I have another doubt. How can we connect Access and VB form.Should we use SQL Statements (Thru ODBC Conneection).

And also, How can we capture datas written to Acess DB be taken to a separate form. (For Eg. I have a Customer Complaint Form.When a customer enters any complaint about a product,the Complaint details should be entered in the form (like what we do when we click on a Button for Feedback Form, the feedback details directly goes to the Email id of the Concerned Person).There I have another field, along with Customer Name, Area of Complaint, complaint Details, Telephone, Email Id etc, Select technician (When the complaint is received at the concerned HelpDesk, it should be directly assigned to a technician. when we select the technician, the name of the technician should also be entered into the database.I am using VB 6.0.

woodyz · February 12th, 2007, 11:19 AM

On the date part:

In VB6 you just use "Now". You can format it as you please, but the simplest thing is:

Me.txtDate.Text = Now

Woody Z
http://www.learntoprogramnow.com

cnkumar74 · February 13th, 2007, 06:22 AM

Thanks a lot...
Another doubt I am having is that I have created a DB with ADODC and in the VB Form properties (ADODC) I have connected the DB with the VB Form. But When I try to enter some values in the Text box and when I go to next field, the earlier value (for example, the first field name is Name of Customer).I entered the value for the field.and when I try to enter the value for the next field, the first value disappears. Is it because of the ADODC connection.

How can I connect VB form and DB with SQL (INSERT) Command.The fields I am having are Name of the Customer,dept / Area, Area of compalint, Complaint details,Telephone and E-mail Id.

Can you please help me in these...........

Nsnda Kumar

Quote:

quote:Originally posted by woodyz
On the date part:

In VB6 you just use "Now". You can format it as you please, but the simplest thing is:

Me.txtDate.Text = Now

Woody Z
http://www.learntoprogramnow.com

woodyz · February 13th, 2007, 11:08 AM

Ah. Good old databound controls.

I must say - the mechanism of databinding in VB6 isn't worth using. Whenever I have consulted on a project where part of the design included using databound controls I would insist that they be removed and everything done in a more sane manner.

If you are stuck with having to use the data control and databound controls - I sympathize.

You can't connect with an insert command - only a select command. However, all the controls should be editable and you should be able to post your data back to the database. I am not the right person to troubleshoot this since it has been over 7 years since I last had to deal with datacontrols and databound controls.

Woody Z
http://www.learntoprogramnow.com

cnkumar74 · February 14th, 2007, 02:09 AM

thanks a lot

nanda kumar

Quote:

quote:Originally posted by woodyz
Ah. Good old databound controls.

I must say - the mechanism of databinding in VB6 isn't worth using. Whenever I have consulted on a project where part of the design included using databound controls I would insist that they be removed and everything done in a more sane manner.

If you are stuck with having to use the data control and databound controls - I sympathize.

You can't connect with an insert command - only a select command. However, all the controls should be editable and you should be able to post your data back to the database. I am not the right person to troubleshoot this since it has been over 7 years since I last had to deal with datacontrols and databound controls.

Woody Z
http://www.learntoprogramnow.com