Search results

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.

Try this new attach file i am sure this will be ok.

Hi This is my 2nd post on the same issue, but I haven’t solved it yet. I have 2 tables LegFile and LegLook related to form LegFile. I am trying to select a RefNo from LegLook table against a Combo Box Selection and after selecting a Refno I want to Update LegLook.RefNo with (add) 1. Steps are...

What happened, Program guru don't find the solution. I can't believe this. Some body must have a solution.

Hi, I am still new in access, although I have asked so many questions in this forum but still don’t understand how things work. Any way now I am again stuck in the following project. Details are I have 2 tables. Table A contain fields (Type, Refno, Fname), Table B got fields (Type and...

What function you are talking about. this is the whole code to add new ref no. do i need to mention function here. please mention brifely. i don't have much experience in access. database version is current. Add button is worked fine but only not generate any Auto number.