Search results for query: *

Hello, I’m looking for some ideas (no source code yet) I have a user form which I have thoroughly tested, it functions well, and I use it often. Now I want to create multiple instances of the same user form to analyze different sets of data side by side, simultaneously. The form is very...

I am looking for a way to 'End' all code execution for a single excel workbook only, regardless of excel version, without stoping execution of code from other workbooks / add-ins. The 'End' statement seems to stop execution of all code across all workbooks and add-ins. Any ideas? -Joshua If...

I am the administrator for an access database at our production facility and have developed a complex excel add-in to act as the user interface (I really don't like Access forms VBA!). I want to test how the program will handle corrupted fields in the backend data and possibly develop a tool to...

I have a multiselect listbox in an excel userform. Initially there are no items selected in the listbox. When the user selects an item in the list box for the first time it selects both the item the user selected AND the very first item in index 0. It only does this the very first time the...

All, I have a userform with a multiselect listbox used for search and filter options. When the user selects a value in the list box I want it to highlight light green to indicate to the user that a filter is in place. However for a multiselect listbox it will not change the backcolor - at...

All, I'm making a user log-in form in excel that interfaces with a background database. I would like the form to signal when capslock is on and off. I have figured out how to test if it is on, but I cannot figure out how to detect when it is changed by the user. I tried inserting some code...

Access 2007 - I am trying to make a form invisible when it loads, but it still shows. I used the following code as well as Me.Visible = False. Neither work Forms!frmSplash.Visible = False -Joshua If it's not broken, it doesn't have enough parts yet.

Access 2007 I am trying to set a property in my class module an MSForms listbox control (lstItemLinks) on my user form, but the listbox shows as null when I run the code. Why is the listbox NULL? It works fine when I code the list box from the form module. All of the other controls are access...

Access 2007 I have a form with a listbox of records that can be selected. When the user selects and Item from the listbox I want the form to load that record for editing. How do I move the current form record to a specific ID? I see some gibberish about something.Boomark but I'm not sure how...

Visio 2003 I am trying to find where I can lock and unlock the aspect ratio for resizing a shape. Anyone know? -Joshua If it's not broken, it doesn't have enough parts yet.

Access 2007, ADO Library 6.1 I am trying to use a vba function to build an ADODB recordset based on various inputs. I want to return this data to a query in access. However it does not seem to accept an entire recordset from a userdefined function. Here is a very simple example of what I am...

I'm using a VBScript to copy an excel addin to a common location on the user's computer (not under the user's profile) and then automatically install the addin in excel. Everything is working great except the command for excel to add the addin file. The problem is with the optional CopyFile...

Quick question - I'm used to mainly coding in VBA for Excel and I like to assign variables to specific parameters when I make function calls (the ':=' ), such as: MsgBox Prompt:=strMsg, Buttons:=lngButtons, Title:=strProgramTitle Just my own personal discipline I guess. Well I'm trying...

I'm trying to use an fso file object in microsoft excel 2010 to access and manipulate a file. However when I try to access the Type property excel tells me that the object doesn't support this property or method. All of the other properties of the file object work fine, such as Name, Size...

We have a word document with numerous tables. On one network computer the all of the tables overlap on top of each other. Many of the other computers on the network display the document with no issues. We have checked the printer settings and all seems okay. Changing the table overlap...

I wrote a quick script to delete useless rows in a monstrous table that don't apply to the situation I am looking for. For some reason the macro keeps breaking into debug mode at the .Row(F).Delete line. It gives me the message, "Code execution has been inturrupted." I can click the 'Continue'...

Windows XP / Excel 2010 Pro. I have a snippet of code that I use to format form controls based on user input. This code seems to run perfectly fine in one workbook, and not at all in another. The code in both workbooks is the exact same and both are located in a public module. The only...

Ok I'm trying to migrate to vb.net 2010 from Excel VBA. I'm trying create a parent property for my user form so that it can identify which form called it into existence. Here is how I did it in VBA: Private frmParent As MSForms.UserForm Public Property Get ParentForm() As MSForms.UserForm...

Anyone know how I can use API functions (I'm assuming it would be API functions) to detect how many monitors a user is using and then decide which monotor to display user forms on? -Joshua Well, You can try banging your head against the wall, but you just end up with lost-time injuries and...

Excel 2010, Access 2010 I'm very new to ADO and I'm trying to update a record in a connected database. The code executes fine, but it is not changing anything. Can anyone show me where I am making a mistake? The offending code is the in Change event of the txtFlakeName textbox...