Search results

I am trying to paste a hyperlink using a send key function. Problem is, the sendkey function will not work if I try to close the workbook I copied from. The code is below Private Sub CommandButton1_Click() Dim linkedsht As String 'if selected sheet was not changed or rates was selected, exit...

Hi guys, I have a pivot table where I use code to break out several files based on a certain category. I created some more code that will highlight any cell that is changed. My question is... How do I transfer this code to these new files I created? Basically, the pivot table creates a new...

My SQL will not work in one of my queries. I keep getting "must contain 1 table or query". Bit I do list the table... Any ideas what is wrong with the SQL below? INSERT into xxxxx (Project, costType, jobCharge, ResourceDesc, [upper/lower], Cat, SumOfhours, SumOfcost, SumOfoverhead) SELECT...

Hey guys, I was hoping someone could help me out. I need to edit an old DB but I can't access anything when I open it. All I can use are the forms that were made. I need to be able to being in the queries, tables, moduels, etc. I've tried holding down the shift key when I opened it and that...

Does anyone know how to get around form filter issues displaying only "is Null" and " is not Null"? I also have issues with creating pivot tables. I know its due to an OLE object. Is there a way fix this? Thanks

Hey guys, I was hoping to add new labels and comboboxes to my forms using code. My problem is that Me.Control.Add does not work. The problem is with Add, it keeps showing "Method or data member not found". Can anyone help me out with this?