Search results

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?

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

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!

I have a form with a tab control. The rightmost tab is always open when the form loads. I want the left-most tab to be open when the form loads. I can't seem to figure out how to change it. I tried... 1) Me.TabCtl0.Value = 0 2) Me.TabCtl0.Value = 11 ...in the form_load() sub. One of them...

I can't select an item in the listbox on a form. Any ideas why that would happen?

There is a combo box with a list of revenue types. If the user types into the box a value that is not part of the list, a msgBox pops up and asks them if they want to add that value to the list. Here is my problem: In that msgBox, I want to give the user a combo box list of revenue groups to...

I'd like to make my switchboard form open automatically when a user opens my access file. How do I do this?

When a form opens in MS Access, it displays its name on the title bar of the form. I want to hide the real name of my form and display a more user-friendly name on the title bar. How can I do this?

I'm importing a CSV string using TransferText. I want a dialog box to pop up that allows the user to pick the file to transfer. How do I code the transferText option so that a browse dialog box pops up?