Search results for query: *

Is there any way I can have my asp code send an automatic email to me when user submits a form? Immediate replies appreciated. Thanks!

I'm running a module, without a form from Excel. Once I finish the program I need to terminate the program. If I type end it works but I get an error, as follows: application-defined or object-defined error I'm assuming because there is no form and it is trying to end the form. If I take out...

I have a name and password textbox in my form. It is a hardcoded password, and anyone can see it in the code by going to view source. How can I hide this information?

Is there anyway I can program a menu to be attached to an excel toolbar every time my program runs. Right now I created a menu bar in excel (tools, customize) and I attached a macro to it. The macro calls my form and the program runs. But when I give this program over to the user, they won't...

How do you program a cancel button of an input box? -sf

I assigned a macro to a menu in my toolbar. The macro calls my program and displays a predefined chart in my excel spreadsheet. The program ends without any runtime errors. After displaying the chart,however, I get the following error in excel: application-defined or object-defined error What...

I filled up possible selections in a combo box by looping through contents of an array. I want the value of what they selected by the index of the array. Eg: if user selects red, I want to always refer to that as 1. if user selects orange, I want to always refer to that as 2 etc. How do you...

I am validating user input in my form. I am coding msgbox if any text box is blank. I am also checking for integers etc. Every time the msgbox line executes and user clicks ok, I want them to view the form and be able to enter a new input. My problem is that my program continues running. My...

I am writing a program where the user enters two dates and two times. e.g. 10/23/02 5:00 AM and 11/24/02 3:00 PM. I want to take the two dates and times enterd, figure out the time interval and divide the time into 4 segments. I need to then run a query on each time segment. I am having a lot...

I'm trying to loop through a recordset to display the data. Everytime there are no matches I get an error because the recordset is empty. How can I check if the recordset is empty? I tried rs.recordcount and it seems to always equal -1 before rs.movefirst but it can't do rs.movefirst if there...

I'm trying to loop through a recordset to display the data. Everytime there are no matches I get an error because the recordset is empty. How can I check if the recordset is empty? I tried rs.recordcount and it seems to always equal -1 before rs.movefirst but it can't do rs.movefirst if there...

I am trying to do a query in a loop because the variable in my query keeps changing. I do the query record the information returned fromt the recordset, increment the variable and start the loop over. For some reason when the query isn't in the loop it works fine and does the logic once but when...

I have a syntax error that I am sure is a simple error but I can't seem to figure it out: If (x >= infoFrom And x<= infoTo) Then counter=counter+1 End If Any ideas? Thanks!

I created a macro and assigned it to to a menu item that I created. The problem I am having is that as soon as you go to that menu item and scroll mouse over it the macro gets called. Is there any way that I can only have the macro done if the user clicks on the menu item?

I am working on an excel/vba project. I have data taken from sql displayed in a worksheet in excel. I created an addition menu to my excel toolbar and want to add code to the menu items in that menu that will pull up a form that was written in vb. In that form I want the user to be able to...

I am working on an excel/vb project. I have data taken from sql displayed in a worksheet in excel. I created an addition menu to my excel toolbar and want to add code to the menu items in that menu that will pull up a form that was written in vb. In that form I want the user to be able to...