I know vb quite well now, but asp have only started in the last couple of days.
I realise that it is not possible to create a report in Access through asp (nor in vb) but i know it is possible to run the report. Therefore, has anybody know how to run reports through ASP?
I have found one web site that is seems useful, but i want to compare that code to anybody elses. If you have some code that does this then please post, as i need to get a better understanding.
I have microsoft access 2007 installed and want to make the following:
The user can go to a website and there are a number of drop down lists which are from different tables in a database for example he might select P7-34043 as the project name in one drop down list then select his job in another drop down list
the user would then after filling out all the boxes press submit and the server would generate a report automatically in microsoft access with the values he selected
How would i go about doing this.
I hav created a report in access, when I click submit from fromnt page(HTML, ASP),
It hav to generate a report for the vales entered in the form to the report which I created in access. Is there is anyone to help me.
Can MS-Access Report be used with ASP
I Have posted this before but no answer.
I'm trying to recreate a report using ASP that was originally created in MS Access. I have no problems selecting all the records in the table but I need some formatting help. Here's an example of the report:
hospitalname doctorname phone
doctorname phone
doctorname phone
and here's what my output looks like:
hospitalname doctorname phone
hospitalname doctorname phone
hospitalname doctorname phone
Question #1
Can MS-Access Report be used with ASP?
Question #2
Do the client needs to have MS-Office Installed in order to see MS-Report?
Question #3
Do I need to Install MS_Office In ASP Hosting in order to View/Print My MS_Access Report?
I am currently working on a project that will migrate MS Access DB and Front End to web-base solution to reduce MS Access installation. Previously, users are using MS Access as frontend to produce customized report.
I am not sure if in a web based solution, using ASP, I can display the access report as-is or by converting to pdf (server side) and display on a webpage. I'm not sure if there are builtin solution on this or I need to have 3rd party to do so.
I have wriiten some code that allows me to pass a value to a query in an Access database. This works fine. My question is how can I pass a value to a report in Access and display within my browser? .....
View Replies View RelatedI want to do a running total query , here is what i want :
I want the running total like this:
I have an access DB that has some queries built in to it.
Rather than putting the SQL in to my ASP Code (which I normally do) I was hoping there is some way to run the queries which already exist in the queries portion of the access DB. The queries do require me to input a variable though.
For example, there is one query called qry_FillForm which required me to pass a value called FormID (number)
If I have the value for FormID in my asp code, is there a way I can simply get this query to run? I can always create a
strSQL string and do it that way, I was just wanting to learn if it is even possible simply call the query that is alreay in the DB without having to manually put the SQL into my asp code.
Having a permission problem I'm guessing but I have a ASPX page with a link to a Crystal Reports created PDF. On the local machine it access the pdf file without any problem. All other machines come up with the 'The page cannot be displayed' error.
I'm using form authentication and for testing purposes only the IIS6 application pool is using the identity 'Local System'. I've checked permission on all files and all are set correctly. Any other ideas anyone?
How do I retrieve a report from Access 2k from ASP?
View Replies View RelatedI'd like to transfer al my hard coded sql queries to access stored queries and use them with parameters. Actually, I did not find any strong information how to do that. Please, provide me official information, or give me at least one example of using it(with
Select statement or other).
I've installed iis6.0 on win2003. All static content with
ssi etc rendered fine on the browser, but gives a 500
internal server error if i try access any asp page. The
log file says:
ASP_0134|Invalid_ProgID_attribute 80 - 127.0.0.1
Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.2;+.NET+CLR+1. 1.4322)
500 0 0
All the dll files are in place and I have enabled asp
scripting. Can anybody give me a clue as to where am I
going wrong?
I'm cobbling together an e-commerce site with thousands of items (spares, accessories etc) and want to distribute it as a catalog on CD. I don't fancy rewriting it to HTML. Is there any way to run the ASP and database on a CD-ROM. I've tried Dynamic-CD but it won't do the job and there is little or no help on their web site.
View Replies View RelatedI am trying to run a simple VB exe from the asp. I am using the following code
Set oWSH= Server.CreateObject("WScript.Shell")
oWSH.run "%COMSPEC% /C est est.exe",3, False
The exe is seen in the task manager. But it is not running. When I use this same command in the command window, it works fine. Can some please help me. It is for Intranet development. I am trying to run the exe in the server only.
I have a new W2K3 box running IIS.Is there anything I have to install in order to use ADO?when I perform the following
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "mydsn"
I get the error
Provider error '80004005'
Unspecified error
I had a windows xp professional and I install the windows component so that I can use the IIS 5.1 to test an ASP file. I went to start and click the run button and then type mmc. As soon as the mmc window opens I click the console but there is an error saying that there is nothing into it.
View Replies View RelatedI need to open asp.net solution files whose source location files have moved. I am creating new virtual directories on the fly (using vbscript) as part of a automated build process that are configured to point to my new source directory. The build is following because I get the following error
<b>Unable to open Web project 'Abc'. The file path 'c:dev...' does not correspond to the URL 'http://localhost/Abc'. The two need to map to the same server location. HTTP Error 404: Object Not Found.</b
I am getting around this in the build process by removing the <b>GlobalSection(ProjectConfiguration)</b> section from the *.sln file
Is there a proper way to avoid this error occuring
Can anyone tell me how to link from ASP to Crystal Report like to create a report in CR when a user key in some requirement to pull out data from database(SQL Server)
I dont ASP, but I need to get the report.asp in this code top open in new window with the results desired. It works fine the way it is, but I just want the report to open in a new window. I would appreciate any help possible.
case "five"
OD=Request("OD")
pwt=request("pwt")
pg=request("pg")
cwt=request("cwt")
cpg=request("cboCPG")
strSQL="Select * from Query1 where PipeOD="& OD &" and tblpipe.wall_thickness = "& pwt &" and tblpipe.pipe_grade = '"& pg &"' and tblconnectors.wall_thickness = "& cwt &" and tblconnectors.pipe_grade = '"& cpg &"'"
response.redirect("report.asp?myquery="& strSQL &"")
I'm new to ASP & wish to use it to create SQL report based on the following query:
SELECT DISTINCTROW Users.LastName, Users.FirstName, Users.JobTitle, Courses.CourseName, Status.Status, Status.Date FROM Users INNER JOIN (Courses INNER JOIN Status ON Courses.CourseID = Status.CourseID) ON Users.LoginName = Status.LoginName WHERE (((Status.Option)="Required")) ORDER BY Users.LastName;
Do I need to break up the SQL query per row and write out the report? I was thinking I could create this query, retrieve the information & create an SQL report.
However, my SQL is very rusty so I don't remember how to make the command (the only nice thing about GUI interfaces, the client thinks I know how to make the report as I can print it from the db.).
I have made some reports with asp codes. the reports are working correctly. but I want to set the margins, header & footer dynamically using asp codes. is there anyway to do it?
when I print the report, I don't want the header & footer to be printed out. I know that we can set this by going to the printer settings...but then this application will be installed in our server and we can't expect every staff to change them when they want to print.
is thier any way to run ASP files in apache just like php????? if yes how?
View Replies View RelatedIs there a way to open FrontPage automatically on a user's computer using a
web page?I wan't the user to be able to click a link or a button and have FrontPage
open to a specific URL. The FP permissions should take over from there.
I'm looking for the same kind of execution that you get when you type
I am very new to asp programing, so this may seem a silly question but here goes.
I am creating a page that will generate random lotter numbers. I have created the actual code to generate the numbers and have added the code to the top of the page. the problem is the code runs when the page loads and I want it to run only on the click of a button.
I read various starter tutorials and none seem to mention how to asign code to the click of a button.
I know there have been posts about this issue before, but I can't seem to find what I'm looking for. I'm not well versed in ASP, but in PHP there is a function called exec. This launches a process. I can call a PHP script from the command line and have it run in the background i.e.
<?php
exec(php myscript.php &);
?>
is there a way to do the same thing with ASP? I want to run an ASP script in the background
I am trying to run an ASP page in IIS 6.0 and I keep getting one of
two errors:
-2147467259 (0x80004005)
The remote procedure call failed and did not execute.
I have Win XP. It's been running fine for a long time and then
yesterday, for no apparent reason, I get this. I've tried the links
to asp.faq that I've seen others post and nothing works.
As a test, I created a simple ASP page with just '<%
Response.Write("Hello") %>' in it and still the error occurs so it's
not a scripting or database problem. DotNet seems to run fine and I
can run HTML pages, I also have Apache and can run PHP scripts with no
problem ... everything except classic ASP.
Any ideas? This is driving me crazy and I need IIS running because I
am falling behind in my work. As I mentioned, I've been running ASP
scripts on this machine for years and have never seen this problem.
I have Xp prof, IIs 5.1, .NET2003 on my machine.
I had the error "Visual studio.net has detected that the
specified web server is not runnning ASP.Net version 1.1.
Yow will be unable to run ASP.Net web applications or
services." in .NET 2003.
I fixed it by running the IIS mappings for ASP.NET,
aspnet_regiis -r. But I figured that my IIS had some issue
and I had to register the dll for IIS.
After doing that my .net is throwing the same
error, "Visual studio.net has detected that the specified
web server is not runnning ASP.Net version 1.1. Yow will
be unable to run ASP.Net web applications or services."
I ran the aspnet_regiis -r again it is overwriting the
1.1 .net framework scripts but the error in .Net is not
fixed.
I know my webserver is running Ok because I can develop
ASP pages using Visual Interdev and my default website is
running fine.
Recently, I made a few ASP files connecting to MS Access file with security, I used IIS to test ASP files.
After it is done, I want the ASP files are accessed for each person via network in the company computer with security.
How can I setup a network which allow the person to run the ASP files?
Do I need to create a partition for network drive to run the ASP file/a server for running it?
Here is a simple test class Ive built to try and find out, why another class I built (that works fine on my testing server running iis on xp) throws up an error on the live server running red hat 8.3 on linux, Im new to asp and only just now found out the live server is a linux box. Code:
View Replies View RelatedI want to make a simple simple asp page. All I want is when the page loads
it does "net stop <service>". The code is below, it is not running as
IUSR_<machine>, I am authenticating as Administrator yet the service does
not stop.
The blank page just loads with no errors and the service remains
running, what am I missing? I am completely new to ASP, I just want one
simple page for this purpose. Code:
I have been trawling the net to find a decent example of a way to connect to an sql 2000 server using asp.net and run a few commands.
One of the commands i need to run is: "EXEC sp_addlogin 'Albert', 'B1r12-36', 'forum2'"
how to do this, and display a 'successful' message on the page if the command completed successfully.