Recent content by pirseinkim

Rock on!!! Thank you! That worked and thank you for the info adding the WHERE 1=0 I didn't know that! Thanks again for all your time :)

okay so this is the logic I have on AfterUpdate of my checkbox Private Sub AddToMailing_AfterUpdate() Dim rst As ADODB.Recordset Dim strSQL As String 'Do-It Added Logic KP 11/12/2015 On Error GoTo HandleErr Set rst = New ADODB.Recordset rst.ActiveConnection =...

I cannot attach my whole db. But I can attach the code. Will that help?

So on subform 2 I would reference subform 1? Where do I need to do this? And once I do that then my click event on subform 1 should copy my data to suboform 2?

I did that. The only thing the button code does is a me.refresh. I put it in my logic on the checkbox and it doesn't populate the form.....or table....

I have a main form, Customers. Within that form I have a contacts subform and and mailings suboform. On my contacts subform I have checkbox, 'Add To Mailings', once that is checked I want it to add it to the Mailings subform. However, I cannot seem to get that to work. I have to add a command...

Thank you very much. I will try to work with this and see where it goes!!

Btw - the RibbonXML field is a memo field so I guess it does have a limitation of 65,536 characters. Is there a way to expand that? Seems like there would be a way since I know that excel, access and word's ribbons are much larger than what I am working with.

I have created an xml file in Microsoft visual web developer for my ribbon. Then I copied and pasted it into the USysRibbons table in access 2010 in the RibbonXML field. My xml file is pretty lengthy. I went in to add about 7 more lines to show under my report button but I get this error: 'The...

I have a report where I would like to count the records. I can do this in a typical way to count the records but I'm a little stuck on this scenerio. In my report I pick a date range of 04/01/2013 to 04/30/2013 it displays all my records. I have 3 records for 04/01/2013 what I would like is...