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!

Register Log in
  • Congratulations Chriss Miller 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. Begin76

    When Got/Lost Focus Event Occur on Subform

    I was trying to do something similar with the not in list event. Possibly this thread will help you. thread702-565103 Luck
  2. Begin76

    Not In List

    Hello, Thanks a million to both of you. I was able to get it to work with a few modifications. I have posted it below. I like the way this event works because it promts you before opening the form with the Category name to add. Allows you to verify typing errors. A star to Bob for this...
  3. Begin76

    Not In List

    Hello, I tried to erase the second instance of the Response = acDataErrContinue but am contining to get a error on the Comboboxcleanup line. Ideally I would love to open the form but I can't seem to get my head around the problem I am having with this line of code. If...
  4. Begin76

    Not In List

    Hi Judge, I was trying to open the form as there is a category description that goes with the category. What I was trying to accomplish was to open the category form enter the data, then when the OK button is clicked it hides the form and focus is set back to the original form. It then runs...
  5. Begin76

    Not In List

    Hello, I have a form with a list box. I want to use the not in list property to allow entry of new items. I have coded the not in list as follows Private Sub CategoryID_NotInList(NewData As String, Response As Integer) If MsgBox("Category Not Found, Add?", vbYesNo + vbQuestion...
  6. Begin76

    Append only Specific Record

    Sorry, should have provided more detail. I have two tables that are alike. Fields are as follows; tblvendor.vendorid tblvendor.companyname tblvendor.address tblvendor.city etc... tblmanufacturer.manufacturerid tblmanufacturer.companyname tblmanufacturer.address tblmanufacturer.city etc...
  7. Begin76

    Append only Specific Record

    Hello, I have two tables - Vendors and Manufacturers. I wanted to use an append query to append those vondors that are manufacturers as well. I have created an append query and it works but it appends all the records that are not the already there. I set the Company name property as a...
  8. Begin76

    FedEx and Purolator Tracking from Form

    Hi, I was able to figure it out last night. Thought I would post the code so anyone interested in doing the same could. This is coded in the Form_Current event of a queried form. If Me.ShipCompID.Value = 1 Then checkfedex.HyperlinkAddress =...
  9. Begin76

    FedEx and Purolator Tracking from Form

    Hello, This is a great site and has allowed me to further my knowledge of access greatly. Thank you to all the people that make it happen:) My question has to do with tracking shipments from within my database. I am in the experimenting mode so I don't have a full table yet but it works...

Part and Inventory Search

Back
Top