Recent content by hubcap750

I was hoping it was just a matter of knowing what the default ribbons were named, but on further research it seems like it would be very complicated. If my heart is set on having the sort, filter, and search features available for this particular datasheet form, I would be better off just making...

Thanks for the reply llkhoutx, but that site explains how to set up a custom ribbon, and I just want to use the default "Home" one. There doesn't seem to be an object name for it, so it looks like I am just stuck with either creating a custom ribbon or letting the user figure out where the...

Hi All, When you open a form in datasheet view, the default ribbon is of course the "Datasheet" tab. I would rather have the "Home" tab ribbon open up, because I have one field in this form set up as hyperlinks to open another form, so the filter and search buttons would be more helpful to the...

Neither the button nor the textbox's hyperlink property was filled in, but your code works fine, only opens once. The code was so complicated because I copied it from somewhere else. up until now I haven't used hyperlinks, so thanks very much for helping me simplify things!

Hi all, I have a form with a textbox with the "LinkedIn" profile address that I want the user to be able to pull up when they click a command button. It works, except that the link opens twice in two tabs in the browser. I've checked over the code for the whole form, and this code is only being...

Getting closer. The function works great, does what it is suppose to. Only problem is that the query runs when the form is opening so I get an "invalid use of null" error. Since I know what the problem is I just inserted a on error resume next in there and that seems to have fixed it. Thanks...

Hi All, What I want to do is set the criteria of a query to the value on a form if the form is open, and set it to a different value if the form is closed. I tried using a function on the OnLoad event of the form to set a variable called IsOpen to 1 if the form is open, and reset that variable...

You are right vbaInet, I missed your post and didn't know it was a navigation form.

try setting the focus on a control on the tab you want the form to open to.

I'm not sure what you are trying to do here, but I'm going to guess that you want certain tabs visible to some users and not to others for confidentiality or security reasons. Is that what you are trying to do? If so, how many different levels are we talking about?

try this either after the docmd.openform command or the on load event: YourFormName.YourTabControlName.Value = either 0, 1, or 2 depending on which tab you want opened.

That did it, that was the little piece of code I needed! Thank you so much, you have no idea how much sleep I've lost over this.

Here's another twist. If the contact on the first tab I select has more than one record in the subform in the second tab, it works fine. It seems to only crash if it is the first record on the subform if it is the second time it is being selected if that makes any sense. Once I've selected the...

This is a test database so it is already shaved down. It opens with Editar Contactos form. Select a contact from the subform on the bottom and click the "Editar" button. Next click the "Empleo" tab, select a record from the subform and click the "Editar" button to populate the fields at the top...

Hi All, I have a tabbed form from which the user can select a contact's record from a subform on the first tab, click a edit command button, and the unbound text boxes on the top of that tab populate. The user can then click the second tab with employment history which has blank unbound text...