Hi,
I am familiar with only the basics in Access and feel some sage advice before diving in would be welcome.
I aim to set up a database with the final result being the ability to produce a staffing rota on a week by week basis.
There are three main elements:
1) List of which team covers...
Here is a curious one.
I have an ASP page which uses a search string to pull records from a database.
For a variety of reasons I then use a GetFileName function to cull the filename and extension, this is then used to populate a Javascript window.open routine to provide a link to the...
Thanks Tarwn,
Tried to get it to work with no succes - and no explanation other than a possible time issue - I wonder if the open code is processed as the filemove is still in progress so access is denied?
Anway, found a workround whereby the original file is opened, then copied by the submits...
Tarwn,
Thanks, but erm...
The window open code is as follows:
Response.Write "<script langauge='javascript'>filewin=window.open ('" & (filetoopen) & "','mywindow');</script>"
I then tried to close this window from the submnit button on the form - which passess the form data to another ASP...
Tarwn,
Fantastic, thanks for your help.
A bit of modification and it works fine. File moves a dream.
But, it does need closure of the PDF file (open in a browser) or else 'permission is denied'.
Can I force this window closed just before I call the function??
Cheers again.
Tarwn,
I really like the idea of moving the relevant file automatically once the entry is completed.
At present once the form is completed the data is passed to another ASP (add.asp) page to transfer to the database before then returning to the form with the next PDF opened - that works a...
Anyone have a smilie for the 'smaking the palm of you hand against your forehead' manoevure?
If I had perhaps been clearer to start with...
Anyway, a simple JS window.open function called from the add new reference page does just the job.
Why oh why did I not think of that?
Cheers all.
Sorry for the confusion and thanks for your help so far.
In answer to these questions:
It is essentially a catalogue. I have over 4000 pdfs which are medical literature I have collected relevant to my research and job.
The database is a catalogue of these - it contains the reference details...
Sorry, perhaps should have explained better.
The current routine is as follows:
I open my reference database ASP front end web page and then choose to add a new reference (which is a link to another ASP file, a form to enter data to the database).
I then have to open Adobe reader, and locate...
Hi all,
I have an ASP front end database program running from my hard drive in XP Pro which I use to catalogue references.
Due to the tedious process of entering new data, I wonder if it is possible to automate some of the processes.
1) Can I fire up adobe reader automatically when I open my...
bcastner.
The nail has well and truly been hit clear on the head..
All works now - diasbling zone elvation has cured the problem, curious to know at what potential expense though..
Many thanks.
Thanks all.
Have added web site to trusted as well as the file location with no effect.
Given the links open fine as plain html I guess this is an issue restricted to active server pages and permissions.
Other time constraints mean I am limited to e-mail support at present but if I can clear...
Thanks Linney.
I have worked through all the above - it still does not work.
The SP2 e-mail feedback form is also not working at the moment.
Given a plain html version works I assume this is some issue relating to running ASP files on a local server and linking to files - albeit ones on the...
I know, complex title.
Basically I have an ASP based database running on XP Pro via Inetpub as a web server. Produces a table of links to PDF files on my hard drive.
All works fine, except now I have installed SP2 the links fail - when I click a link to a PDF nothing happens. No ActiveX...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.