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

Thanks for the help. The cat is in there to keep me company when I get lost inside the MAZE of SQL.

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

Got it. I had to open the VBA window before I opened the DB. I then used the code CurrentDB.Properties.Delete("AllowBypassKey"). I ran it, closed the DB and reopened with the shift key.

Will I be able to create code in one DB and then reference the directory of the locked DB? Thanks for all the feedback.

it's a MDB.

It's not. If I can just get into the tools and turn it all back on..

Thanks for the input, but I'm still locked out. Shift F allows me to edit the form. But the only thing I can do is move objects around. I cant even right click and view properties. Windows does not show the "unhide" option. Thanks again guys.

F11 doesn't work. I have no idea really what the existing structure is, that's why I need to get into it and dig around.

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

They want something that is point and click. Most of them don't know excel very well. Plus, I am VERY new to VBA and like learning and doing new things.

That's the route I've been trying to take. I went ahead and created several combos and hid them all. When the user opens a table, I count the fields, list their names as labels and open X combos. I then make a qry to give me the row source. This is the tricky part. There are so many...

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

Thanks for the help guys.

The controls I want to add are going to be variables depending on the number of fields in given tables. I want to create a tier structure with combos. The first combo will choose a table. Then it will make a new combo with all the records for the first field to choose from. The next combo...

Thanks for the quick responses! This should get me going in the right direction.

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?