Search results for query: *

I am having an issue opening an old database somebody else created, and I can't figure out the problem I am using access 2007, and when I open my database immediately I get the error message: An error occurred while loading 'Form_MAIN SCREEN'. Do you want to continue loading the project? I...

I am trying to get the variable "MyList" to only have unique values. It works fine when I just load all of the values, but I can't prevent duplicates. The values are sorted alphabetically, so it shouldn't be that difficult, but I am at a loss. Any help would be greatly appreciated. Thanks...

I have a bunch of weekly jobs, running to a partition that contains three tapes. We have two drives, and the jobs all run smoothly until a tape fills up. Once the first tape fills, it goes to the third tape. If the second tape fills while the third tape is in use, the job won't recognize that...

We have 70 store locations with vpn connections through cisco 871 routers. Every time there is some disruption, the tunnel drops, which I understand. The only problem is that it does not re-establish the connection. The only way to bring back the tunnel is to telnet into the router and reload...

I have the code below, which in xp is creating a new menu bar with items to click which will run the macros assinged. When this is opened in excel 2007, the addins tab has the "Order Entry Program" dropdown menu with all of the items in it, and also all of the items on the addin tab. Is there...

Is there any way to draw a line on a form? I can't figure it out to save my life! the form name is MainMenu. Any help would be greatly appreciated.

I have an excel file with some macros and forms in it that I have emailed to some external users and are getting the above message. I have searched the error and have found the solution, but I don't want to have to walk 100 users who don't have a strong grasp of computers through the steps of...

I have an excel workbook, that uses a ton of vlookups. In each row, there are 7 vlookups. They pull product information (description, price, size, etc) from a worksheet (PRICE BOOK) based on a sku number (Column A) on the main worksheet (TEMPLATE). Is there a way I can find the row number of...

I am in Excel, and would like to record the active file size into a a variable. I can't seem to find the code to do this. Any suggestions?

I have a user using the web access version and whenver she tries to reply to a message, or click "view print", it takes her to a "login not current, log in again" screen. Is there a way to fix this?

I have a program that cycles through each worksheet tab and asks the user if he/she wants to delete the worksheet, and they answer yes or no and the program acts accordingly. What I would like to do is load all of the worksheet names into a form and have the user go through and check/highlight...

I am having a problem that shouldn't be that hard to fix, but I can't seem to figure it out. I have a file in the xlstart folder, called "personal.xls" with macros in it. The security level is at low, it isn't on the disabled list, and it won't automatically open when excel opens. If I double...

I have a "template" excel file, and I would like to create a number of copies of this file. The names are loaded into an array. Is there a way I can create the files without opening the "template" file, doing a save as, then repeating? It takes too long to run that way. Thanks in advance!

I would like to load a folder's file names into an array. The number of files in the folder are variable. The folder pathname is S:\L01. The arrayname is "fileloader". Thanks in advance!

I am running a simple find macro. I can't seem to figure out how to program around the error that comes up if the value that is searched for is not found. Here is the chunk of code. Thanks in advance! Selection.Find(What:="MY SEARCH VALUE", After:=ActiveCell, LookIn:= _ xlFormulas...

I am having a nightmare of a time with this one. I am trying to load an array based on a variable number of ranges with variable sizes. For some reason, I am only getting values in the array for the last time through the loop. Any help would be greatly appreciated. Thanks in advance...

My computer lost one day's worth of history from Internet explorer, version 6.0, and nobody deleted it. I have all of the previous days' history. Does anyone know how this could have happened?

I need some code to change my header's font size. I have roughly 250 files all with different headers and need to change the font size in each of them. I can't seem to get the code to change the font size without changing the header itself. I want to set up a loop to update each of them, but...

I would like to create a macro that runs each time I open Excel. I have a file called "order entry setup" in the XLStart folder. I want it to look at the date it was created, and if the current date is more than one month later, I want it to delete itself. Is this possible and if...