Recent content by jschneider998

Hi, I have a contract database for all of our vendors. I also have a mail merge set up in Word to link the information from the database into the contract. My question is how can I create a button on the form to open the specific word document that contains the mail merge information...

Hello, I have a form with a subform listing vendors. The subform is in the datasheet view and has several entries. I would like to be able to double click on any of the vendors in the subform and have a pop up form launch giving more detailed information on that particular vendor selected. I...

Does anyone know how to change the color of a command button on a form?

Hello, I am trying to create a report based on a query. I have generated a query to specify what work has been done for what customers. The results give me a listing of company (customer) name, part worked on, and date work done. Now when I do a report is there a way that I can have the dates...

Thanks SOOOOOO MUCH!!! I am so happy it works perfectly!!

Thanks for your help. I put the code in the NotInList Event and I am getting a compile error on both Dim statements. Saying that the user defined types are not defined. I am very new to VB Code and I am not sure what that means, any ideas?

Thank you, I have the limit to list property set to "yes" and the code I have for the NotInList event is as follows: dimMySQL as string MySQL = "insert into [tblPartNumbers][(part no)] select '"& NewData & "'" Docmd.runsql MySQL Combo.Requery I have a form with several combo boxes on it, my...

Hello, Can anyone help me? I am trying to figure out a way to be able to add to my combo box dropdown list without having to keep going back to the original table....YIKES!!