Search results

Please check the attach file for details.

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

i have install hot fixes but no effect, same error i am keep getting. i think this is a code we need to chang, but how i don't know. Hope somebody can help in change the vba code.(mention above)

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, Thanks, i have done this, and its working fine. Thanks again for your help

Not Yet, i tried a vba coding, but on run time it won't accepting a record source, so i think we cannot define a record source on run time bases for report. i might be wrong. because i don't have enough knowledge in Access.

Thats solved but i also asked, that i have 3 command buttons and 3 queries, i only have one report. i want if some one click on 'View By Open Date' button, then it should ask the parameter value from user and open the report against the parametter value on the report. same as on other command...

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

Thank you every one for help. i have learn many things. thanks again.

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 yes now its working fine, thanks for your help Thanks

following code i have done, but still got error, the error is Compile Error:- End IF without block if. Code is Dim password As String password = DLookup("UPassword", "Users", "[UserName]='" & Me.UserName.Value & "'") If password = Me!Upasswordcontrol Then Select Case Me![UserName]...

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