Recent content by furnitureheaven

Hi, I am new in .Net, so i really don't know much. I have a file in XML (with Parent Nodes and Chiled nodes) in it. I want to write a contents from XML File to text file in VB Consoule Application. i have done some code, but its give me the following error. Could anyone guide. Error:- My...

Sorry for late responce, and Thanks for the soluation, you got pretty much the logic. Its shows the right date in the Main Form, but it pick it from the child table. I want it to pick the date from the child table and update the parent table column, and then display it from the parent...

Hi, I got stuck in the update table record. Actually I have a parent form with subform (child form) attached with two tables (Obviously one is Parent table and other is child table). Fields in Parent Table:- RefNo ….. ….. Revwdate (Depend on Child table Revdate against Type) Fields in...

Sorry, I just missed the code which cause problem in the above attachment file. I have added a code which I have originally on the project. Now you can now check the attach db and problem which I am getting still. Thanks for looking again.

hi i thought if i attach a db then its eassy to give you an idea. please look in the program. Desperately waiting for suggestions. Thanks

Hi I have got a error message in access 2003. I have 2 forms where (in one form user input the data and its store into a table) So when user clicks the save button it’s save record in table and update a lookup table. And same time it open a 2nd form and shows the last record in the table...

Thats now work, thanks for your help.

Not exactly, as I said, I have Combo and Text box on form, what I want if I select Combo box value =1 and Text box value =158 then It should store in the variable 10158 So It = 10158 So if I use this it = [Forms]![LegFile].[Combo8] + 0 + [Forms]![LegFile].[frmRefNo] then its only...

Hi, I am stuck in this, I have a form with combo box and ref no( text field), I want to concat the value of Combo box with 0 and concat it with Refno. In my table combo box field is in number and RefNo field is in Text. Could any one tell how I can set this, My code is this. Dim it...

Thanks for your help, its great and know working ok. Thanks again.

This is a number field in Database if i do as you said, its says datatype mis match critria. how we could error handling here.

hi i am writing a code in select record from table, but if user enter letter or $ same its produce error, i want to do some error handling, but don't know how to do this. could anyone guide me here, my code is like this. On Error GoTo E_Handle Forms!LegFile!frmRefNo.SetFocus Dim rs As...

Great, that’s solved, could you also help me in the update query. When its update the record, its show message “Your are about to update 1 row(s).” I don’t want to show this message on update record. Could you tell me how I could stop this message? I have an update code as this DoCmd.RunSQL...

Hi, I am writing a code in VBA, but receive a error No 3464 (data type mismatch in criteria expression) I have a table with 2 columns (Ftype and FRefNo) and I also have a form with a Combo Box (Combo8) and a Text box (frmRefNo). I want, when user select value in Combo box (combo8) it should...

I am still looking for a solution, Could anyone can help me on the above attached program.