Search results for query: *

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

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

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

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

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

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

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

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

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