Search results

Don't I feel foolish...sorry, brain not working so well this morning...

I was actually hoping to find inside of queries or text boxes in forms or reports. What are google v-tools?

Hi, Is there a way I can find out where certain customized functions are used in forms/queries/reports?

That works great. Thanks.

How do I create a combo box listing all the time available between now and end at certain time of today with increment of certain interval? Example below. I started to load a table worth of time in the range of 6:00am to 11:00pm and created a query with criteria of > now (). It resulted...

Well, I'm not sure what the problem was, but when I first tested the code, I only asked for the label on the main form to be visible by using That never worked, so I was convinced the syntax is not right. But from all the research, it just seems that simple, so I made the associated text box...

I tried that before, but received "Method or data member not found".

I want a button in a subform to trigger a label and text box to become visible in the main form. Isn't the code quite straightforward like below? It does not seem to work. Forms!MainForm.ControlName.Visible = True

Ditto on the Expression Builder. I hardly ever use that. To be honest, I couldn't ever figure it out :confused: Thank you RainLover and tranchemontaigne for taking the time to help me, but due to my deadline, I had to abandon the concept of subforms within forms. I've decided to go back and...

Yeah, as you suspected, Repaint and Refresh did not work, neither did other methods, such as On Load, On Focus, On Open...etc, so I ended up coding as you suggested, which was setting the recordset behind the command button of subform1. That was painful. Now I have other issues...too long to...

The code is working fine. When I first open the main form and click on a button of subform1, subform2 becomes visible and all the buttons within subform2 are populated correctly. It is when I click on a different button on subform1, subform2 does not change. If subform2 was a just another...

Well, subform2 contains nothing but command buttons with initial "visible" property set to "no". The number of buttons that become visible when the form is open and their captions are displayed is based on a query result that is triggered from subform1. However, I have used VBA codes to...

I'm not sure which method to use, but requery does not seem to work. I basically have a main form with many subforms. One of the events in a subform (call this subform1) makes another subform (subform2) visible. The first time when the main form is open and the event is triggered from...

I just noticed my mistake. The button that triggers the event is actually a subform within the main form, thus, "Me." didn't work. Now I replaced it with "Forms!frmOrder.Form(FormType).Form.Visible = True" it worked. Thanks Bob for your help.

Name of main form: frmOrder Name of control: sfrmCategoryMenuSelect

Thanks for the quick response, Bob, but when I incorporate your code, I get an error message of"...can't find the field 'XXX' referenced to in your expression." I know XXX was found as I debugged it using msgbox.

I have a main form with many subforms in it. One of the subforms has many buttons. Depending which button is clicked, the caption of the button and dlookup function will determine which subform within the main form will become visible. How do I reference the subform based on a variable? The...

That works great. When it works, it sure seems logical, but it's always getting there, that's tough, at least for me. I'm still learning. Thanks for your links and the final solution.

That's what I did originally, as seen on top. I have remove the parenthesis, tried quotes, quotes at different places. None worked until I broke out the variable away from the string.

Yes, but I couldn't quite figure out the exact syntax when using a numeric variable in the conditional statement.