I have an ASP page that calls an Access macro. My macro name is just Import. Actually, this macro is being imported to another DB, which is Information.mdb. When I view the ASP page in my browser, there was an error. Something about database cannot be opened because it is being opened exclusively by another user.
When I go & check in my Access DB Information.mdb, I double-clicked on the Import macro, an error pops up saying "'Itxnrpt Import Specification' does not exist. You cannot import, export, or link using the specification." Code:
I have an asp module connecting to a MS-access database.
I have a vb function MKDate(date, time) in a vba module of this database.
I would like to query : SELECT MKDATE(col1, col2) FROM TABLE1
(real query is complex, using unions, etc, but I need one column in resultset)
But I get an error opening the recordset "Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Undefined function 'MKDATE' in expression. /selfmail/dossier.asp, line 729"
I also tried to copy the code of the function MKDate(date, time) inside ..asp module, no change.
Is it possible to call a vba function inside an asp sql statement?
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.
I want access to excel macros from aspnet proyect. But it not run because in Excel Security options don't have checked "Trust access to visual basic project" for aspnet user.
Can I login in my PC with aspnet user for open excel and active this options? Do you know another way for get it? I need test if existe a macro with a specific name.
We face problems uploading excel (with macros) documents using HTML File Upload.
The file contents are corrupted while viewing the same. However, we are able to upload excel (w/o. macros) documents successfully. Is there anything we have to take care of, while handling uploads of excel documents with macros?
I am running a project in which i use a web application writen in ASP to create some quizes, then i would like to call a compilor (dll) to compile the data i created and change it to .mms file in order to be able to send it to mobile device.
Can you please guide me on how to call the dll file from my ASP application?
I have created an Active Server Component (ASC) as a bridge between ASP and my existing C++ DLLs that we use in our PC-based program. Our intent is to re-use as much code as possible.
when I call the ASC from ASP, and then call the DLL, the security profile that is specified in IIS is no longer associated with the process, and therefore, any "network-related" calls fail due to insufficient privileges.
I don't know if there is "another" way to call the DLL from the ASC or not, or any way tospecifically load a DLL with a certain security profile.
i am calling an exe from asp program. Its not working fine. When i execute the exe through the dos program directly i get the desired result. My exe will convert files in the folder to encrypted files.
But when i call it thru asp program its not working fine. I have tried the following method.
a) Calling the exe through shell program. b) Calling the exe through ASPEXEC. c) Calling the exe through the Batch Files.
i've got two pages. they have the same name for two sub procedures that do pretty much the same thing and have the same number and types of arguments. i either run one page, the other page or both. when i run page1 it somehow is accessing page2 even if it isn't called with an include statement.
page 1 is using the sub with the same name from another page even if it isn't included. so what's going on? is that normal? should i just make one page instead of 2? didn't think that sub's could jump accross pages that weren't included, but i could be wrong.
Where's the best place for me to include all my functions that I want to call throughout different pages? Should I just put them all in one ASP file and include that page on every page? Or use global.asa somehow (how??)?
Anyways, I was just wondering because I didn't want to slow things down if I could help it (I didn't know if having another big file attached to every page when I'm just using a small portion of it was very effective or not)
I want to create tables in my database programatically. I know i can do it using adodb connection object. I have too many tables, views and stored procedures. If I have to write a code, I will have to write 1000 lines of code. I dont think, thats the best way to do it.
I already have a sql script for these tables, views and stored procedures. I want to know if i can execute that sql script directly from ASP.
I will explain the background, to give a better understanding of my situation. We have a website, which uses the existing database to generate reports. If we want to host that website (as a service) to third parties, we create a new database for every customer, create all the necessary tables, views and stored procedures in the new database. I want to make all the table creation programmatic. Is it possible?
I'm working on a project and the designer guy uses templates for everything. THis is fine except I have to call a JScript function when the page loads and I have no access to the body tag. Is there a way to call the function as the page loads from a VBScript command?
I have the following problem. I want to call a JavaScript Function from ASP I am reading back values from a db and based on those values I want to check a checkbox. If the value in the db field in yes then I want to check the checkbox but if it's no I want to leave the checkbox unchecked. My alert box is displaying but Im getting an error at the line document.getElementById("chkStatus").checked = "true";
the DoConnection sub is in another page called MyDBConnection in a folder call Common.
I know that I can use serverside includes and embed my con in the page using <%%> but I want the use runat server How can I make call to a function in an external page?
I have a database and I use asp to load it into a html table. The first cell of each row contains a button. What I want is that when a user clicks the button it calls a serverside sub that inserts additional rows from an other table of my database. Problem is that I don't now how to call a sub from the onclick event of the button. And I don't know if it's possible to insert rows in a html table. Does anybody know how I should do this?
I have an Empty Function on one of my pages, so when the user clicks(submits) on the empty button in the form, the shopping cart empties. This is on basket.asp. Code:
If (CStr(Request.Form("Submit")) = "Empty") Then emptybasket end if
Above is the code that empties the basket on basket.asp. Below is the Submit button code.
We have an asp page on a webserver supporting asp pages. How can we run/call a function on this page using an onclick or other event from a control. For example, when an image is clicked or a combobox is changed. We know how to run a javascript, but would be nice to run an asp function.
I have an application using asp and javascript. The javascript collects data and then needs to pass it to asp to store in the database. The way the original application was developed, all the data gets captured into a javascript array of records (similar to a recordset) and then each record in the array needs to go to the database. Currently I loop through the js array and open an asp window that writes to the DB then closes. This works but I get a flicker affect as this happens for each record. I'm looking for a better way to handle this - either to be able to send my entire js array of objects to ASP (don't know how to do this) or a way to invoke the asp code without opening then closing a new window everytime.YI - I recently posted a thread called "asp & javascript" that had some code snippets of what I'm currently doing.
On the last line here i'm trying to some how get it to call the last ID keyfield entry...
ImageID = Request("ID") If (Len(ImageID) = 0) then ImageID = "1" If Not IsNumeric(ImageID) Then ImageID = "1" If ImageID = "0" then ImageID = "1" If ImageID>3 then ImageID = max(Len(ImageID))
This is basically for some max min links for a online comic here's what it links to
I have ASP pages that calls some ISAPI dll that created using Delphi for generating reports. The report page opens fine for 1st time when invoked but next time i get error like "Name not unique in this context."
My quesry string pass to dll like: .../ReportsDLL/NameOfDLL.dll?PatID=100578&ThpID=12&State=FL
I think after the DLL is loaded it is not freeing the memory and not unloading the dll from memory. SO How can i free memory used by the DLL or unload the DLL from within the ASP page that load the url to window.location?
How can I free the objects / DLL that I loaded from the ASP page using the above querystring?
Note: I think the delphi code that is written for DLL is working fine as It works fine for 1st time.
I have one VB exe file. Can it be called and opened in ASP page like as html form is shown. I want to execute the exe file from any machine. Should that machine have vb and sql.
I have an ASP application that calls a COM function to create a custom report as an Excel file. This works in a synchronous fashion, as long as the report does not take too long to create. If that happens, the session times out and we run into other kinds of problems.I have, in other cases, executed a stored procedure asynchronously thru ADO. I'm wondering if ASP provides some way of executing a function (an ASP function, not ADO) asynchronously? I could then make the call to the COM function from within this async thread, and implement the same refresh logic on the client that we used in the ADO solution.
I have a vb program which initiates a powerpoint when run (with a click of a button). i made a dll for that program by opening the .vbproj in a textdoc and changing some values. I was wondering can we call this dll from an asp program so that the power point gets initiated from asp.
