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 IamaSherpa 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: *

  • Users: Np02
  • Order by date
  1. Np02

    A stupid question?

    OK. Thank you.
  2. Np02

    A stupid question?

    Yes, you are right. I am using VB.net in my PC. But the book I am using is a VB 6 book. If I like to keep using my VB.Net in my computer and able to use the immediate window to see the control number like the example here, how should I change. Sorry for the insufficient information because I do...
  3. Np02

    A stupid question?

    Thanks, Robert. I use the CTRL key and Break key at the same time. It did stop the program. (I got the Form1 in code view after I press the CTRL and Break keyat the same time.) I then open the immediate window through Debug tab in menu bar and type in " ? Form1.Controls.Count", then...
  4. Np02

    How to create a buton to "fax"?

    Hi, jbehrne, Very good information. Let me figure out first. Please accept a big star from me! NP02
  5. Np02

    A stupid question?

    Hi, I just start to study VB by book. Try to get to the immediate window. I started a new project with a form, follow the book instruction : Run the program, pause it, then type the following statement into the immedicate window" Statements:"? Form1.Controls.Count". I click on F5...
  6. Np02

    How to create a buton to "fax"?

    Hi, like to make a command button in a form of Access be able to fax the report associated to the form. (assume the user's computer has PC phone setup). Ex: After I enter a note in the frm_Note, I have a button to preview the note report (through a qry_Note and preview report). I like to have...
  7. Np02

    Open a form based on specific field in current form

    Sorry, I mis-copied the code. You are right. The form name need to be changed to frm_Contract. However, I copied the line of stLinkcriteria code to my command button, It does not work. (stii open to the first record). Any comments?
  8. Np02

    Open a form based on specific field in current form

    Hi, Hope some body can help out: I have a form call "Template" (frm_Template), In this form, I have a field called ContractID. I have a command button in this form to open frm_Contract. Frm_Contract has a field called as ContractID too. Now the command button will open frm_Contract...
  9. Np02

    Make a Combo in Subform follow a Combo in Main Form

    Hi, Jfgambit: Sorry getting back so late. Your code works. Thank you a lot. NP
  10. Np02

    Make the Add New Navigation key come back?

    Paul: Thanks. I just find out it is primary key issue. I put one of the field on primary key. The new button appears. Thank you anyway. NP
  11. Np02

    Make the Add New Navigation key come back?

    Hello, I have a form that I want to add new record, but I find that in the Navigation bar, the Add New button is grey out, (The Previous and Next buttons still work). I checked the Form DATA property, Allow Addition is checked "Yes". The Control Source of DATA of the Form is written...
  12. Np02

    Derive member ID automatically from Last , First name and DOB?

    Hi; FancyPraire: Great, it works. Good code. Get a star from me. NP
  13. Np02

    Make a Combo in Subform follow a Combo in Main Form

    Hi, Trendsetter: I tried, but not working. Maybe I did not explain the question clear. The combo1 is a bound Combo box in the Main form, has its data source from a field (ID) in Table1. Combo2 is in a subform(Subform1) that is inside the Main form. Combo2 is unbound and does not have a query...
  14. Np02

    Make a Combo in Subform follow a Combo in Main Form

    Hi,Everybody: I have a Combo (Combo1) box in Main form. Inside this Main form, there is an unbound Combo (Combo2). I want the Combo2 to change and match the Combo1 data everytime I pick up a choice in Combo1. I tried using (Child Link (Combo2) and Master LInk (Combo1), but it doesn't work...
  15. Np02

    Derive a string form fields of subform and main form

    Hi, I have a field called VID (visit ID) in the frm_Main Main Form). There is a subform called "Member ID Subform" placed inside the frm_Main. There is a field called DOV (Date of Visit) defaulted to enter Date()(Today's date) in the frm_Main. I want to make the VID field in...
  16. Np02

    Hit "Enter", go to next line instead go next field.

    I have a problem in my database. In a form with 5 memo fields. In field1, I finishe 1st paragraph and hit Enter key to go to next line to type 2nd paragraph (inside same field), but the cursor always jump to next field (field2) instead. How do I get rid of this problem?
  17. Np02

    Derive member ID automatically from Last , First name and DOB?

    Hi, Michael: I do not have problem to replace asterisk with something else. What else letter or symbol will you suggest? And, I still do not know how to change Fancy's code to make it work? NP
  18. Np02

    How to do digital signature ?

    Hi, Foolio: I agree with your points regarding Form security.But, ... I did try to follow your advise to make it work, I found several problems: 1. Your code to check password is hard to understand for me. On Error Resume Next Dim ws as Workspace Set ws = DBEngine.CreateWorkspace...
  19. Np02

    Derive member ID automatically from Last , First name and DOB?

    Fancy: Your code looks good to me, but I tried and it didn't work. I have the frm_Member with 4 fields: LastName, FirstName, DOB, ID. I copied your code to Form Before-Update event procedure. Tried acouple of entry, didn't work. The ID field remians empty. Any problem of the code, please...

Part and Inventory Search

Back
Top