Form Automation
I am getting ready to build another ASP page with a form on it. This form is part of a very complex application I am in the middle of building. It is an event management and scheduling application. The whole idea of this page is to register an individual for the event and to schedule their activities they want to participate in.
Here is were it gets complicated... We have over 30 events and they are all happening at different times. Some are overnight and others are half day and other are full day. We even have some that are two days long.
Some of the events can hold 80 people but their are 40 instructors for that time period. I solved this problem by creating section numbers kind of like in a college. Here is my actual question:
How can I build drop down boxes that change according to what is selected in a previous one. I am using the DB to populate the drop down boxes. Here is an example of what should happen: Code:
View Replies
ADVERTISEMENT
I have a very small ASP function that basically allows me to add items to a list and it all gets stored in an Access DB. The output is a loop that displays all of the items.
I wanted to know if anyone knows how or if with ASP I can update an RSS file so that when it saves the new list item it also updates the RSS feed with the new items as well. Sort of like updating a Text file just not sure how or even if it can be done.
View Replies
View Related
I have an ASP page using Jet 4.0 oldeb provider for mdb. (ADO 2.8). I use
the _same_ code in ASP from my well working VB application.
The problem is:
when I do the same "SELECT * FROM table WHERE field1 LIKE '%asdf%' " query,
it works in Access (SQL query) or in my VB .exe code, but generates OLE
automation error in ASP. The same code!!!
If I use "=" instead of LIKE, it works. (field1 is string type). But I need
LIKE
View Replies
View Related
I have a recordset containing some data.
Using that recordset I want to populate them in a work book in differrent
sheets, using client side VBScript.
Previously, I used server side automation for this. But it gives error
"ActiveX Component can't create object" then and there. Some times the
automation works fine.
View Replies
View Related
I need to generate one document on the server and then send it to de client. I having problems of security when i try to open word by code. How can i do that?
View Replies
View Related
i have a software application and i have to import around 250 users data into the app.
I want to automate this step,it the most common info
like FN,LN,e-mail etc.
The app runs on IIS and uses ASP. I am looking for a GUI input Automation tool which will have scripting capability to take input from a text file and fill the user input fields "automagically".can testing tools like winrunner do this for me?
View Replies
View Related
I have a script that populates my access database upon form submision.I was asked to find a way to automatically Populates 10 records, that do not change, to the database
once a month.I thought of using WHS to to call IExplorer to execute and launch the URL. and set the windows scheduler to execute it once a month.
But my 10 records that I need to add have different names. How do I set the loop to call the record set
for each field name.Another approche is to set those uncahgeable data in a flat file and use my asp script to call the file and append the records in the table.
What is the best approch
View Replies
View Related
I developed an application using VB6 as FE and Access as BE ( Lan based solution). This application involves picking up preformatted excel workbook with multiple worksheets as template . This excel workbook is more like a form ( containing checkboxes and option radio buttons etc). This also contains clients logo, Header, footer. In this application, on a button click event, the Excel file is picked up from a fixed location, opened, and some data like name of the user, address etc which are available in Access are filled into predefined cells of the excel.
In case any of the fields is already filled, the application reads that fileld and performs validation. After this the workbook is saved at the original location. Most of the fields are not stored in database and data is not in a tabular form.
Now I need to make this application web enabled instead of being on LAN.
Can the above excel automation be acheived in conventional ASP or ASP.net.
I can force the excel path to be fixed path on server ( IIS). I would be too happy if the said excel workbook can be picked up from client machine, modified and stored back at same location.
View Replies
View Related
i have a problem in email using ASP.i have created 3 fields named EMP MAIL,TRAINING START DATE,TRAINING END DATE.now the user enters these 3 details and on clicking the SENDMAIL button the mail should be reached to that particular employee 1 week before the date entered in the TRAINING END DATE field.after testing the application this all is working fine(i used CDONTS in ASP).
The problem is that every day user has to run my application atleast once only then all the mails that are to be sent on that particular day will be sent.
i think this is no good as user will enter the details once for any day and he or she may not run my application every day..in order to send mails automatically what should i do..pls any body can give me any suggestion?
View Replies
View Related
I'm about to create an ASP script which will essentially parse SQL
tuples (rows) into a Word file, creating labels, although would need
to use the pre-defined label templates within word.
Can anyone direct me in the right direction?
View Replies
View Related
I want to do some time based house cleaning chores on a server based on server time/date. I know how to do it based on a call from the client using asp, but is it
possible to have a program residing on the server that comes alive based on server time (not a client call) and does it's tasks such as delete an inactive page, or more importantly, send out a cdonts e-mail to a client list? I should also mention that this is a shared Windows 2003 Server (Interland Blue Halo).
View Replies
View Related
I've develop a simply exe app that merge two or more document in one using MsWord automation.
I call this exe from an asp page (giving authorization to IAWM IUSR...). This run ok on a web server with Xp and IIS 5.1 but don't work on W2K3 and IIS 6.0.
View Replies
View Related
We have a excel document, which is been updated regularly. After everyday
updating, we export as HTML file and upload it.
As a ASP programmer, I want to write a script, which can parse this excel
file and make it as a web ready file.
Is there any simple way to do this?
Our data entry operator, is very new to computers and all he know is a
little in Excel.
View Replies
View Related
I am facing some problems with generating the word documents usin ASP pages. This is the automated process and it is breaking often Since Microsoft is not providing any support for this issue, I though using WordPerfect 12 for the automated document generation would hel me a lot. Is there any possibility of facing the same problem with wor
perfect too?
View Replies
View Related
I have problem in word automation. I have a code in VB that opens word document and performs some Find & Replace operations in it and then shows to the user the document. The script runs perfectly on local machine which has Word2000 and OS-win 2000 professional. But When I test the same script on Server which has Os-2000 server Edition and word2000 then it does not opens the word doc eventhough script has line "WApp.visible = true".
I am using Word.Application and Word.Document object in my script. When I create a word document with same script but close it in end of script and then open it with shell script command it works perfectly. But my requirement is not to save the doc but only show it to user and leave it for users choice to save it or not.
View Replies
View Related
Could someone point me in the right direction? I've
migrated three FrontPage 2002 websites to a new web
server. Each web site has a Access 2000 database on the
data server.
I have the global.asa on each site pointing
to a .udl file which is pointing to the appropriate access
DB on the data server. We're not allowed to use DSN's.
Front Page 2002 will not allow me to create a network
connection to an Access (only SQL). Only one of the three
web sites work. On the other two I keep getting the
following message when I open an ASP page: Code:
View Replies
View Related
I have a page in my website which display the weekly timeslots. The code that generates these slots is giving me the following error:
Microsoft VBScript runtime error '800a01b0'
File name or class name not found during Automation operation: 'regExp'
It used to work fine, I have no clue what has gone wrong.
View Replies
View Related
I´m having a problem using ASP Upload with an insert form..
If I use ENCTYPE="multipart/form-data" the all the parametres i might get with request.form don´t appear.. but i can upload the files.. Besides if I take away the ENCTYPE tag, i can´t upload but the INSERT INTO form works propertly
View Replies
View Related
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
View Replies
View Related
I have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems.
Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....".
I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code:
View Replies
View Related
I have a form as follows:
<form action="dropboxsubmit.asp" method="post" enctype="multipart/form-data">
<input type="file" name="FILE1" size="30">
<input type="text" name="def" value="0" size="10">
etc.....
and can't get my asp to recognize data in other form input boxes using Request.Form
Any thoughts?
View Replies
View Related
In my prototype asp page (with no javascript and no password validation, I have a registration form with the following action:
<form name="form" method="post" action="RegDetails.asp">
This works fine, the form details are collected by RegDetails.asp
I am attempting to include javascript server side validation for the pasword, which obviously requires password and password2 fields (to be verified). I have used the script available at:
http://javascript.internet.com/forms/val-pass.html
It works fine in a new blank page with the form action:
<form name=myForm onSubmit="return validatePwd()">
The final stage in this javascript demo form displays an alert box:
else {
alert('Nice job.');
return true;
When I change the first line of my original form to:
<form name=myForm onSubmit="return validatePwd()">
how do I get my original action of - action="RegDetails.asp" instead of this alert box?
View Replies
View Related
I have a form on an ASP page that has 5 text boxes, for data entry. I am trying to get data from the text box, and pass it to a hidden text box on the form.
The hidden text box is called "MyDateTime" (a SQL date and time value). I am attempting to concatenate data from two other textboxes (one for date and one for time) to give a string like : "8/8/2004 8:00 AM" I am trying to use the following: Code:
View Replies
View Related
I have some ASP server-side code that works perfectly when the client is running on Windows (IE, Netscape, Firefox, etc.) but doesn't work at all when the client is running on Macintosh (IE, Omniweb, Safari, etc.) This is the client-side Javascript code:
View Replies
View Related
Im having problems with my form, separately both forms work perfectly, but having problem sending the email once submitted, however the upload fuction is working fine. The message im getting is,
Request object error 'ASP 0207 : 80004005'
Cannot use Request.Form
/forminfo.asp, line 42
Cannot use Request.Form collection after calling BinaryRead.
Heres the script Code:
View Replies
View Related
Would anyone be able to give some guideance in ASP code as to how I would repeat a section of input fields in a form based upon the number of guests that are attending an event?
Basically, what needs to happen is if 3 guests are attending, I need the Name, address, city, state fields to repeat so they can be filled in with information.
Then all of the information from the whole form is submitted which returns an email to the administrator of the event.
View Replies
View Related
<%@Language=VBScript %>
<%option explicit%>
<%
MESSAGE = (Request.Form("type"))
MESSAGE=MESSAGE & vbcrlf & "Name" & (Request.Form("name"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("address"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("handphone"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("phonenumber"))
MESSAGE=MESSAGE & vbcrlf & vbcrlf & (Request.Form("comments"))
MESSAGE=MESSAGE & vbcrlf & vbcrlf
MESSAGE=MESSAGE & "____________________________________________"
Set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.From =Request.Form(email)
objMail.To = "icepricessa@hotmail.com"
objMail.Subject = "Business/Career Enquiries"
objMail.Body = ""&MESSAGE&""
objMail.Send
Set objMail = Nothing
%>
but somehow i'm not able to send the mail....
View Replies
View Related
I have a series a forms that submit data to different tables in a database. As it stands, when a user completes FORM 1 and clicks the SUBMIT button, the FORM 1 data is submitted (action = form2.asp, method = post) to ASP code at the top of FORM 2 (request.form("form1 field name") etc...), and submitted to the database with SQL code, also at the top of FORM 2(INSERT into...). Hence the submit button on FORM 1 directs the user to FORM 2, and submits the data which is exaclty what I wanted. However, I now need the users to submit multiple sets of data with FORM 1, and direct them to FORM 2 once they have finished using FORM 1. Most importantly, I need to pass a few parameters from FORM 1 to FORM 2, and have these parameters submitted to the database.
My main problem is getting a fresh form1 after submiting the same form1, in preparation for anoter set of data using the same form. Basically, the database has 'one to many' relationship tables. Form1 and form2 are both populating the 'many' tables, so that each form needs to be filled-in several times while retaining the key field of the 'one' table. At the moment submiting form1 takes me to form2. Is is possible to submit the data to the database, get form1 back again to submit more data, as many times as required, then click another button to load form2 when the user is finished with form1?
Can anyone please give me some pointers? or at least explain the concept of what I need to do. I am a novice and it's taking me a while to get to this stage. Any help will be greatly appreciated.
Is it possible to post FORM1 to itself and insert the data (i.e. place the request.form at the top of FORM 1) If so, how do I direct users to FORM 2 while retaining my parameters?
View Replies
View Related
While I can extract the option value from the following:
<Select name='Keystring' MULTIPLE>
<option value='1' name='status'>Pending</option>
.....
</select>
I cannot seem to extract the corresponding 'display' value when I do a
For...Next Loop:
for each keystring in Request.Form("Keystring")
keystring=request("keystring")
Next
How do I aslo get hold of that 'display' value eg 'Pending'...is it
possible?
View Replies
View Related
I have a simple form to accept two form fields and display the values
entered on pressing the submit button. The following is the form I have
created to accept the two entries and display the form fields on
pressing the submit form. It does not work can somebody please correct
the code or provide a simple equivalent code where I can have the form
and the validation and usage of the form values in the same ASP page.
Code:
View Replies
View Related
I am a new programmer seeking a right way for transferring data between forum to forum, as i am creating a site wich have a page keeping 20's of server controls like drop down list and text boxes the value of ddl2 changging on change of ddl1 and displaying its corresponding value in text box and i have 10 rows in this way and i wanna display all selected values of server controls in next page as report.
View Replies
View Related
I have a form that has approximately 7 text fields and 1 checkbox.
Generally when this form is submitted(to itself BTW) it works fine,
however, when the checkbox is only field that has been
modified/clicked the form doesn't always submit. When it does work, a
Stored procedure is passed form variables and updates to the db are
made. When it doesn't, its as if the form wasn't submitted, it
reloads and resets the page, but the stored procedure isn't triggered.
View Replies
View Related
I have an html form where a serial # is entered and goes to an asp page to determine wether it is a res or comm number, then directs to another form where they can finish entering info to register the serial number. I want the second form to display the serial # entered in the first form. How do I do that??
View Replies
View Related
