Search results

  1. R

    auto number problem on primary key

    this is nearly working hy coyote thank u very much for giving me reply this working on load event and next record button. every thing is ok but little modification is needed. if i load a form next number is generated. and if for example i dont want to create new record then this number is also...
  2. R

    auto number problem on primary key

    hy i hope all r fine. sorry for disturbing you again. i have problem in auto generation of primary key field. on field i have written on enter event the dmax function. but when cursor is going on that field automaticaly next number is appered and also it update the old record if i first time...
  3. R

    auto populate field based on other table

    this is working hy Mr. Wayne thank u very very much for helping me. the code u have given me is working properly. thank u again take care bye
  4. R

    auto populate field based on other table

    i have written this code in item code dept name field Private Sub DEPTNAME_Enter() Me.DEPTNAME = [SELECT description from department where department.detpcode=me.DEPTCODE] End Sub but getting the error 2465 one record is coming but giving error pls help me bye
  5. R

    auto populate field based on other table

    hy i hope all are fine i am in huge trouble. actually i am oracle programer. but my user has asked me to develop a small program in access. now approximately i have developed the program. but one problem remaining. my problem is this i have one table in which i am taking value based on other...
  6. R

    combo box value problem

    hy thank u very much for reply the problem with me is this i have combo box on the dept code item i want to to see when i click on combo box a list appear with dept code i want to see deptname with this also so that user know that he slected this dept. by code only no one know which dept is...
  7. R

    combo box value problem

    hy i hope all r fine i am in trouble and i need some one help very badly i have one table called department where deptcode and deptname is present and i have one item master table where dept code and deptname is present. here on item master form i have made combo box on dept code. now i want...
  8. R

    coding problem

    hy thank u very much for reply ok if i not use autonumber but how can i solve the problem of code 001 it is coming 1 if i am entering 0012 it is coming only 12 any help should realy be appriciated thank you
  9. R

    coding problem

    hy i hope all r fine i am making item code through access form to help my erp program the detail of coding is we have 13 digit code and to make an item we have five group example first group contain 4 digit 1001 2nd group 3 digit 001 3rd 2 digit 01 4th...
  10. R

    delete record

    hy bro and sis i hope all r fine i have a mater/detail access form and when i press delete button it is just only deleting master record not detail record. when i am viewing the record it show both mater and detail record. i have define relationship just only on form not table. any solution...
  11. R

    combo box problem

    combo box hy i hope all r fine first of all thank u very very much for reply. i understand ur logic. u r right. but i was using logic of oracle . i have got it. thank u take care bye
  12. R

    combo box problem

    combo box hy thank u for ur reply. if i will not make combo then what i will do if user want to modify the detail record. the only to select the required record from the list. i dont have any other option if i use it as unbound then i am not able to save the data. msg is coming primary key can...
  13. R

    combo box problem

    hy i hope all r fine i am facing problem in combo box. here i have master/detail form and this is working fine without combox. when i am creating combobox for list of item and go to that item the record is showing. but when i click on detail record then it is giving the problem of primary key r...
  14. R

    problem with form

    hy i hope all r fine sorry for disturbing u i have problem in my master detail form and single form. the problem is this when i want to see the detail record against the master record and i pree scroll bar it is giving error and ask me that u can not duplicate primary key and also i want to have...
  15. R

    auto save problem

    auto save problem solved hy bro sorry yesterday i did not used internet. and thank u very much for help me and giving me very nice information . this code i have tried and working very nicely thank u very much
  16. R

    navigation button help

    navigation help hy dear bro i hope u r fine first of all thank u very much for ur reply. the code u gave me is working fine in single form. but when i used this code on master/detail form it is not working and all button r disable. i think there some kind of set code is mising can u elaborate...
  17. R

    navigation button help

    hy bro and sis sorry for disturbance i have one more question about navigation button "first,last,previous,next" is there any coding if we r on last record then last and next button is disable. if we r on first then first and previous button r disable. any help should realy be appriciated. thank...
  18. R

    auto save problem

    hy bro and sis i hope all r fine i have one problem in access and that is when i am entering the new data it is save automatically. i want to save data when i press save button otherwise it will not save data and also for update i also want updation through command button is there any solutiion...
  19. R

    crystal report 10 problem in access

    crytal report hy i hope u r fine. first of all thank u very much for ur reply. i have solved my problem by using this code Dim stAppName As String stAppName = "c:\crw32.exe c:\abc.rpt" Call Shell(stAppName, 1) now this is working fine ur solution i will also check thank u very much...
  20. R

    crystal report 10 problem in access

    crystal report problem hy sir first of all thank u very much for reply my access scurity is already set to\ low can any one here who will give reply thank u very much waiting for reply take care bye
Back
Top Bottom