Search results

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

:o How to put [SOLVED] in the thread subject.

That worked great!. I first had to set the default on the load form event so it would default, but then I added the code to the after update event and it worked great for all 15 combo boxes! Here's the code for just one of then in case someone else out there is trying to do the same thing...

Hi All, I have a combo box with three columns, the first one is the bound one, the second is text in English, and the third is text in Spanish. Currently when the form is open, both the English and Spanish texts columns are visible. What I would like to do is set up a command button on a...

So, it did turn out to be a Window's issue, some corrupt files so that SQL was no longer recognizing me and instead of sending me the typical error message it just disconnected everything. Once we got all that fixed you method worked great! Thanks again for your help.

I look forward to investigating this further. Unfortunately, I think the reason it didn't work when I tried to replicate your example with my tables is because my computer has other issues suddenly, it isn't recognizing me as an administrator anymore. That maybe be why my table wasn't updating...