Recent content by bob3940

I haven't developed in VBA for some time now and this is starting to drive me crazy. There used to be a slider control for choosing a value. (The most common use would be like the volume slider in the speaker settings.) I've used that several times in the past. I am now back on a programming...

I am new to Java but have extensive programming experience. I am creating a class that will contain information on an event. I want to be able to store a simple date. I will NOT be performing any calculations or processing the date in any way other than verifying that a valid date is entered...

I am new to SQL databases and having some trouble locating information on designing tables. I am trying to find something that falls between "So this is your first SQL database" and "How to configure your SQL server farm for optimal throughput". All of the material I find appears too be to...

I an new to SQL and I have what I think should be a simple question but I am having no luck in figuring it out. I have a customer table customer_id customer_name etc. and an orders table order_id order_number order_id order_customer_id etc. I created a view that lists all of my...

I am new to PHP and for some reason I am having an extremely hard time with arrays. I need to convert a string into a two dimensional array. My program is being passed a string that looks like this: field1:value1%field2:value2%field3:value3%... There will always be a field and a value...

Unfortunately this does not appear to do what I requested. I need to have a picture pop up at the mouse cursor when it is hovering over a user's name. I tried the example you gave me but the picture does not display. Please look at any of the posts in Tek-Tips that have one of the advertising...

My web page contains a list of employees. The list contains standard information first/last name, department, etc. I want to make it so that when you hover the mouse over the employee's name it displays their picture. If you need an example of what I mean then just look at posts here on...

There are many times when I need to email someone and then copy and paste the email that I just sent into another system for tracking purposes. Can this be done with VBA? My current process is as follows: 1) Create the email 2) send the email 3) Go to my sent items folder and open the email 4)...

I user MS Outlook 2003 and many of the messages that I send have to be documented in another system. My normal process is as follows: 1) send the email 2) go into the sent items folder and open the email that I just sent 3) hit the forward button 4) copy the text (which now includes the From...

I have used vlookup before but I don't see how this would help mein my situation. 1)In my example I am using data validation to limit their choice to a select list of items. How does vlookup limit them to a specific list of valid entries. 2)I want to change the cell comment, I don't see how...

I am using data validation to create a drop down list so that I can limit the entries that a user can make in a cell(b5). I have created a named range (valid_data) that contains all of the valid entries and have entered that as the SOURCE for the data validation. This is working out as expected...

I have about 300 items in several columns, I want to choose all of the items in the list that meet a criteria and display those in a listbox. for example my spreadsheet has the following info. A b 1 Carrot Vegetable 2 Orange Fruit 3 Spinach Vegetable 4 Apple Fruit 5...

I have about 300 items in several columns, I want to choose all of the items in the list that meet a criteria and display those in a listbox. for example my spreadsheet has the following info. A b 1 Carrot Vegetable 2 Orange Fruit 3 Spinach Vegetable 4 Apple Fruit 5...