Recent content by trimakassi

I use CStr(Now.ToShortTimeString()) thanks for your reply

hi all, I have a database with a field configured to accept date/time. I am more interested in the time part of the entry. the problem that i am facing is that I always get 12:00AM can't figure it out!!

dataview

no nothing it says that it can nor find column [x]

thanks abdulla I actually changed the datatype in msaccess field to decimal with estimate 2 and converted the textfield to decimal before updating my dataset and it worked fine. thank u though have a nice one

I created a subroutine to filter a dataview and i want to pass the colum to be filtered through a declared string variable ex. lets say I want to filter the date column x="date" then i call the routine and send x in the routine i have a dataview.rowfilter that looks like this Private Sub...

i am trying to store a numeric value in a textbox in a msaccess field. the field is numeric simple real type code: Dim dr As System.Data.DataRow = Ds1.Table(0).NewRow dr("number") = cdbl(txtnum.text) Ds1.Tables(0).Rows.Add(dr) OleDbDataAdapter1.Update(Ds1)...

thanks alot chrissie

i am new to programing, how can I use shared thigies or singleton classes trimakasssi

my application was working perfectly well before i tried to refine it. I have an mdi form and 3 other forms. Before the problem, for every form i had a new connection to my database with the required adapters. To make my application more effecient I thought of making one connection and connect...

thanks that worked, But i have another question is there anyother way to make a lostfocus run once or pause. thankss Jebenson

Hi everyone, I am new to programming and would need some help, I have an access database connected to my vb.net program. The user in my program inputs the txtdate, txtAmount, cboCategory,cboStore,txtReceipt, and txtMemo. example of ideal case: date.txt 06/12/05 Amount.txt 300$...

GHOST807 you got it on the spot, I just figured it out. it was indeed the []. thanks guys Trimakassi Boston

this is my new sql code that i tested and worked in a test example dealing with one table, one column, and one textbox. Now that I have adapted it to my program it gives me an syntax error in insert into statement!! Try OleDbConnection1.Open() Dim command As String...

Hey bob, I am sorry this might seem stupid but is the Datarowstate(lrow) an integrated function or what cause when I try to insert it it not recognized I tried actually using SQL code but without success.