Search results

In the mouseMove event of the textbox, set screen.mousePointer = 1

I am using a textbox as a button. When I hover over that textbox, I want the cursor to be an arrow, not an insertion point. The only way I found to do this was to set "enable" to false, but I can't do that because the textbox has to be clickable. Is there any way to set the cursor to an arrow?

Private Sub txtFilter_Change() If Nz(Me.txtFilter.Text, "") = "" Then Me.FilterOn = False Me.txtFilter.SetFocus Exit Sub End If Me.Filter = "lastName like '" + Me.txtFilter.Text + "%' or userName like '" & _ Me.txtFilter.Text + "%'"...

Note: I'm working in an ADP I'm trying to filter the records shown on a subform based on what is typed in a textbox on the subform. The subform is called Users, and it is on the Group form. On the Users subform there is a textbox called txtFilter. If I type "W" in txtFilter, I want to show only...

I have a form with a subform (see red arrow). I'd like the subform to resize automatically to fit the records it contains (and the form to resize to accomodate). Also, I want the form to be invisible (and take up no space) if there are no records. I can't figure out how to do this. I've set the...

Is there a way to take a screenshot with vba? (Ideally of just the active form). I want to send it as an email attachment.

Thanks to reading about error handling on StackOverflow, I discovered Mz-Tools. However, I am wondering if there is a way to simultaneously update all the error handlers added by MZ-Tools. If I add an error handler with MZ-Tools and then change the default error handler (via Options|Error...

I am trying to make a generic notInList function that is called when the user types a value in a combobox that is not part of the list. In middle of that function, I want to insert the new value(s) into a table. For some of the combo-boxes, more than one field has to be filled out in the...

I want the entire body, including the dlookup, to be saved as a string in the table. (I want to do it this way so that every email can have an entirely different body and I can use one email function for all of them). Is there any way to keep the dlookup in the table?

I have a variable, emailBody, which is set to a string stored in a database. The email body is set to a string via a dlookup function. emailBody = DLookup("emailBody", "listAdditions", "Id = " & itemType) The string that email body is set to includes an IIf function (which includes a...

The problem was that the datatype for the field was a "bigInt". I changed it to "float" and now everything works. Thank you!

I do not get any of the options, even if I scroll down.

Yes, that is correct.

There still are no options by the format property.

Yes. (The form is a tab on a form. The outer form is bound to a different table.)

Yes. It's still not there.

The dropdown box doesn't contain any options.

I have a bound form (which is used to enter data) and want to format some textboxes as currency. I see that there is a "format" property for the textbox, but I can't figure out how to set it to currency. Thank you!

Thank you! This worked! :D

How can I do that?