Search results for query: *

The error is occuring on a Microsoft Access database where Microsoft Access is both the front end and back end. The tables in the Microsoft Access front end is being relinked every time the front end is opening. However, the specified library it is referring to is the name of the database...

I see, lol It looks like I'll have to owe you lunch or something. Thanks very much.

I currently have the following code: For Each ctl In Me.Controls If ((ctl.Name = "PurchaseOrderNum") Or (ctl.Name = "ID")) Then ctl.Locked = True End If Next ctl For some reason, I'm getting a Microsoft Access runtime 438 error. It occurs at the ctl.Locked...

Thanks very much MajP

I actually have the form working exactly the way I want it now, except for one problem. I have my code the exact opposite of how I want it. I want the user to choose the columns they want and show only those columns that have been selected. Right now I'm hiding the columns they selected, and...

Tried that already :). Not sure why it's not working.

How would it work for all controls regardless if they're textboxs or not?

I already tried that lol. :)

Hi guys, I need help hiding all subform controls when a form opens Thanks

I guess I should start a new post lol, since you did solve the original problem.

That didn't seem to work for me.

Thanks MajP Each solution solved the problem. It was a great help. How would you hide all the subform columns when you opened the main form? As you'll notice, I also gave you a star:).

LOL....never mind. Very helpful. Thanks

Thanks MajP for your quick response, but what's blnHide?

Opps, this is my first post to this forum. I created the post as a programmer instead of as a technical user:).

Hi all I have used Microsoft Access for a few years and I would like to use VBA to hide/unhide several columns on a subform. I'm sure there is a simple answer to it, but I can't seem to find anyone who has spelled it out yet. I would like to use a multiselect list box to hide/unhide fields in...