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...

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...

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...

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...

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...

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...

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...

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...

Hi, I have a table in access with 600 records. a field RefNo got numbers in non sequences. I want to put a auto number on this field. so when user click on Add button, its automaticlly generate a number in a RefNo Coloum. I have a code like this, but its not worked. Could anyone help in this...

Hi i have a table with first name and Middle name in same field(length of names is variable). like Derake Simon K. Ak D. Paul LM. Dixxions DYJ. etc. i want to split them into two columns, so after space it should split the first name and middle name separately. like FirstName...

Hi, I have a main form and multiple sub forms in my project, main form and sub forms have primary and foreign key relationship. I want to delete a record from main form, this should also delete all records (related to that reference no) from the all sub forms. I have tried different tricks but...

hi, i am using vba modules for "Mail Merge", the module code is working fine upto office versions 2000. but when i install office 2003, it give me an error i.e. "The MailMergeToDoc command is not available because the document is not a mail merge main document." could anyone have an idea, how...

Hi I am currently building a report. I have one reports, and one form with 3 buttons to generate 3 reports, I just want to create one report with 3 different titles against each button. (e.g if user click on button 1 then title should be Button 1 and if they click on button 2 then title...

Hi I have some data in excel sheet in mix (Letter & Number) format e.g A SCCL 1574 LC08199 KS03559 SC70341 SCCL 2033 LC08758 AB04291 KS04018 I want this field to split into 2 (Letter should be in separate and number separate). e.g A   B SCCL   1574 LC   08199 KS   03559 SC   70341...

hi Hi I am new in access, I have a database in access and design some forms, I have just create a user login form. If user “Akoo” login the “frm_sara” will open and other user login with user name and password then “frm_lynn” should open. I have tried but due to limited knowledge in access...

Hi I am new in access, I have a database in access and design some forms, I have just create a user login form. If user “Akoo” login the “frm_sara” will open and other user login with user name and password then “frm_lynn” should open. I have tried but due to limited knowledge in access, could...