I have developed an access database with VBA. Right now its on a network drive and is shared by 75 users. Works fine.
Now I would like to have this in the company intranet. Is it advisable to go with ASP? I recently installed IIS in my system. After that I have no idea how to convert my application to ? Is there a website or any walk through how to get my stuff's solved.
My application has 20 input screens, data add, save, update and also sends email based on certain rules. Is it possible to do all these stuffs?
I am using two fields on a form to capture time someboby is working. The fields are hours and minutes. How can I when submitting to the db take both fields and convert them to a single field in the db as minutes?
I'm looking for a control to us on our web site that will take our reports that are generated in PDF and convert them to DOC format all on the server. We are using win2k3 web servers if that helps.
I want to convert CSV file to XLS. Is there anyway this can be done in ASP without renaming the file to XLS.Also can there Macros to Sort data in it while generating XLS?
I have some PHP scripts that need to be converted to ASP3 so that they can run on a Micrsoft NT server using ADO. My knowledge of ASP is limitied so i was hoping you could answer a few questions..
1. Is ADO part of ASP.net or is this completely different? 2. Is ASP3 the same as ASP.net? 3. Is there any advice you can give me regarding converting from PHP to ASP3?
I've stored a set of months in an access database as numbers but when it display on the front end I need it to display as the name of the month.
How would you convert the numbers in the database to their word equivalent? Or is it possible to arrange the months in their correct order in the database?
My data input page uses a id generator which includes dashes, and the corresponding column in the db is set up as varchar to handle that. There is a problem, however, when the value in the varchar column is compared to the string from the URL, and the following error message occurs:
"Syntax error converting the varchar value '071-213' to a column of data type int."
<%strSQL = "SELECT * FROM AMS where MinutesID = " & Request ("id")%>
Would it be possible to CAST the request string to varchar?
I am passing a string into a page and them looking up info to display from a database based on whats passed in. The link is www.domain.com/page.asp?variable='12345678' Once inside the page the following code is executed Code:
i want to convert asp file to excel sheet through asp application. iam having report.asp file as a view form i need that form to convert in excel sheet can you help me.
I have a project to do that requires that I use mysql as the database. I have only used MS Access. The sql will be simple searches. Is there a drastic difference, or just different punctuation? Can I find a copy of mysql on the web? If so, is there any advice on installing?
While I've used Access's export function in the past to generate ASP from the tables, I wonder whether there's anything around to do a more comprehensive automatic conversion. I've noted a few ads for such products, and I wonder/hope there's some experience around here that might be shared - with recommendations.
rtf files cause so many troubles,i.e.,allow the users to download the files, slow loading,incompatible with other browser, and so on. Do you think I should convert them to JPEG files to embeb them into HTML?
Once converting JPEG,it is easier to programming in HTML(i.e.,just add the image tag),load faster,and prevent the user from download the files?
how to convert a date in (tuesday,may 17,2005) to a date in(17/05/2005) format. is it possibleto dowith the helpof formatdatetime() function. if possible how ?
I have a form with multiple text fields, when i submit the form i want it to edit a table in my database using UPDATE. I know i have the syntax correct. The problem I have is 2 fields are Currency and 2 are Date. The request.form command always returns a string and i keep getting the 'Data type mismatch in criteria expression' error. How do i convert the strings to dates, and strings to Currencies.
How do I convert this into something that I could read into an HTML email? I can string regular text but have NO IDEA how to convert syntax for a checkbox into HTML.
Can anyone give me some direction? My code for my checkbox is below. The msgBody is the string I'm building to send in my email. Code:
I have an account opening form of a bank..its in HTML format which needs to be converted into PDF. Also,some dynamic content neess to be added to the PDF depending on the user logged in.
I need help with converting the following function in ASP.Net (VB.Net) to Classic ASP:
Function EncryptIt(_strClearText as String, _strEncryptionType as String) as String dim strEncryptedText as String 'Encrypt the text strEncryptedText = FormsAuthentication.HashPasswordForStoringInConfig File(_strClearText, _strEncryptionType) return strEncryptedText End Function
Code for Const under Button Click Event in ASP.Net:
i am doing this asp programming with vbscript and came across to this problem. i need this answer asap coz i have to submit my assignment tomorrow. the thing is in the code below all the condition under the if statement works EXCEPT where i want to say that 'OrderValue' has to be between 100000 and 999999 inclusive.
it doesnt work i hv used to 'CInt' function to change 'OrderValue' Integer 'OrderValue' contains the text/string entered from the previous page that was entered in a text box called 'txtSearch'
ive got a piece of software (perl) that i use to track visitors on my site. this software displays both ip addresses and domains of visitors
e.g.
A visitor from 81-178-202-110.dsl.pipex.com (81.178.202.110) arrived without a referring URL, and visited www.newmediadesigns.co.uk/index.shtml at 03:01:28 PM on Friday, March 26, 2004. This visitor used Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1).
what code do i need to display this domain information in asp?
I've got a situation where I need to be able to replace "smart quotes" and similar characters that are created (presumably) by Microsoft Word. If you don't already know, smart quotes are those "curly quotes" that curl or angle in toward the text on each side. Here is an example, though I'm not sure how it will display in a browser: “
I thought I had just used a standard replace function in the past for these things, and that seemed to work when the text was coming from a form. However, now I am receiving them from a scraped web page, which I have retrieved using ServerXMLHTTP. In this case, a standard replace is not working.
I've noticed that when I use Server.HTMLEncode on the text, both left and right smart quotes, angled apostrophes, em dashes, etc. all get encoded as  which tells me something goofy is going on. I don't know if this is a character encoding issue or what. I could just HTMLEncode the string and do a replace on  but that also encodes other things that I don't want encoded, and there appears to be no such thing as Server.HTMLDecode in classic ASP.
1. I need to convert the local-time of the server on which I run my website to UTC and I don't want to rely on the server local time and timezone (i.e. I don't want to hardcode the timezone information), is there a generic way to do this?
2. Is there a general for converting time between timezones in ASP?
is any way possible to convert a string, which is a string of a number, to an integer (using VBScript). If not, are there any other solutions to have a number that is a string, and add one to increase that number?
I am have written some code that does some division. The results I receive are in this format 0.15. I would liked to display this as 15%. Is there a way to set the variable so it converts it from a decimal to a whole number.
