Search results

Another quick question... is the back color a string? Because that gives me a type mismatch

Oh you are so right! Thank you.

I have a form of Accounts with a subform of register. The subform is Parent/Child Account number. I'd like to tie the register background color to the account color. I can't figure out which event to use. Change of account triggers the Parent/Child connection. So I tried the Current Event...

Well nuts! you had me worried. It works fine to close the form from another. Tested. Worked.

Hmm... Ok button makes invisible... Go back and close form. (y)

@MajP With your training, piece of cake: DoCmd.OpenForm "popDate", _ WindowMode:=acDialog If CurrentProject.AllForms!popDate.IsLoaded Then dtstart = Nz(Forms!popDate![begDate]) dtend = Nz(Forms!popDate![endDate])...

um... nevermind... I see there are other people with the same issue that's been answered. Thank you!

@MajP posted this function for retrieving values from popup forms: Public Function getValueFromPopUp(formName As String, PopUpControlName As String, Optional MyOpenArgs As String = "None") As Variant 'FormName: Name of the popup form 'PopupControlName: Name of the control on the pop...

@arnelgp Finally! an answer that helps. I was playing with this and you have just fleshed it out. Thank you so much!

I don't need to know the clickable button's size or location. I need to know the name of the field I'm occupying when I shortcut key the transparent button. It could be one of two options on each subform. The previous control works but it's dangerous? Not dependable?

Oh big misunderstanding. Not hidden but transparent. Can't see it but it's there.

OK. OK. got it.

Oh if only I would think before speaking! The answer is strControlName = Screen.PreviousControl.VALUE!!! Thanks for your replies! @Pat Hartman The tab key is right above the Capslock key. Very nasty.

OK. Point taken. I don't want to call from the field because I use the keyboard and not the mouse. Double click moves to another field, single click the same... Is there a way to use shortcut keys? Open for suggestions here. Here's where I am: Private Sub btnCalc_Click() Dim rtn As Variant Dim...

Thank you! I also discovered there's a PreviousControl. Screen.PreviousControl.Name. Discovered it (thought of it, whatever) after I'd posted.

I have a hidden button that calls a calculator (with a shortcut key). There are several fields on one form that use this button so I need to know the field name that's calling the button. Me.ActiveControl.Name returns the hidden button. How do I get the name of the field that is actually...

Yes, I know. That's what I'm using to get here. I have 3 filters on that form. I just don't filter the date values until the popup. The repetition is because the popup is used for more than one form.

I know. for just a tiny little form. It's called "big and ugly but works" ;)

Thanks to @MajP this thing is now working! Sub ListUsage() Dim ID As Long Dim NWhrStr As String Dim CWhrStr As String Dim strRange As String ID = lngInfoXchg strRange = GetDateRange("CkDate", cboDate.Value) NWhrStr = "NameID = " & ID & " And " & strRange CWhrStr = "CategoryID = " & ID & " And "...

wow. In a nutshell! THANKS!