Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jgeneie

    Bitting of line

    I have start up 2x VoIP boxes and they are working fine. but the problem is that when any party hangs up, the line will still be hook-on for around 3 mins. seems like the box doesnt recognise the "hanging up" tone. im using voltel mosa 4500 series. my senario is pstn --> pbx --> Voip...
  2. jgeneie

    limitation on access

    Hi all, I am starting a database using access. but b4 going into it, i have to make sure if access can do the job. i have heard that access has some limitations but im not very sure what is it. I am actually doing a database where i would input authors, books and book ID ( and maybe dates...
  3. jgeneie

    Expression using AND, OR

    hi jim, juz a little question on input mask. 1)Can i use input mask to force the first letter of a word to become a capital letter when a user enters in a txt box?? 2)what can do to prevent duplicate records being stored. like mayb a pop up msgbox stating " duplicate record" thanks
  4. jgeneie

    Expression using AND, OR

    hi jim, juz a little question on input mask. 1)Can i use input mask to force the first letter of a word to become a capital letter when a user enters in a txt box?? 2)what can do to prevent duplicate records being stored. like mayb a pop up msgbox stating " duplicate record" thanks
  5. jgeneie

    Expression using AND, OR

    thanks jim, u have been a great help i couldnt have completed my task without u regards jgeneie
  6. jgeneie

    input mask regarding capital letters

    hi all, juz a little question on input mask. Can i use input mask to force the first letter of a word to become a capital letter when a user enters in a txt box?? thanks
  7. jgeneie

    Expression using AND, OR

    hi jim, using the code u provided about i am only able to do it on a form but not a report. it states "compile error: method or data member not found" Private Sub report_Open(Cancel As Integer) 'have change form_open to report_open If Me.RecordsetClone.Eof and Me.RecordsetClone.Bof...
  8. jgeneie

    count record

    Hi all, i have a search form that searches records from a table 1) how do i use VBA to count the number of records and display as "n of records found" in a pop up menu and then display the output after clicking ok. 2) and to have a pop up menu that says "no record found&quot...
  9. jgeneie

    Expression using AND, OR

    hi jim, sorrie, but i dnt really understand what u mean can u give me an example using the previous code u previded me thanks
  10. jgeneie

    Expression using AND, OR

    hi jim, sorrie but i not very sure what u toking about can u give me an example using the previous sample u sent me?? thanks
  11. jgeneie

    Expression using AND, OR

    hi jim, how do i make use of a pop up menu to "count" the number of records that is within my criteria and display a "no record menu" if no record is found?? eg. Private Sub Form_Open(Cancel As Integer) If Me.RecordsetClone.RecordCount = 0 Then Cancel = True...
  12. jgeneie

    Expression using AND, OR

    hi jim, I still not able to able to display out as a report/form directly. i need to query it out as a table i display it to a from/report. is there a way to display it directly. i have tried : DoCmd.OpenForm "customer profile" where "customer profile is my form name regards
  13. jgeneie

    Expression using AND, OR

    hi jim, regarding your sample program. the chkboxes has 3 states rt? if i leave the chkbox of "dealers" state as "white box" instead of "gray shade", the query will still look for those not involve in "dealer". Is there anyway i can go around this? regards
  14. jgeneie

    Expression using AND, OR

    hi jim, what more can i say, u r a genius! btw how do i display my resulted query in a report rather than a table format. regards
  15. jgeneie

    Expression using AND, OR

    hi jim, i have received your second email but still cannot open the database due to same permission error regards
  16. jgeneie

    Expression using AND, OR

    hi jim, i got the attachment but i cannot open the database due to some permission problem. its states: " the current user account doesn't have permission to convert or enable this database regards
  17. jgeneie

    Expression using AND, OR

    hi jim, thanks for your help u are a life saver can u send to another email as well juz in case it doesnt get through space_7@hotmail.com thanks again
  18. jgeneie

    Expression using AND, OR

    hi jim, have u received my query?? regards
  19. jgeneie

    Expression using AND, OR

    hi jim, i have sent the query to your email. thanks alot
  20. jgeneie

    Expression using AND, OR

    hi jim do u have a email address so i can attach the query to u?? thanks

Part and Inventory Search

Back
Top