I have designed a database in access for my office, which is being used by 20-25 people using our LAN. Now my boss wants me to give this database online so that our branch office in other locations can use data. I have heard asp is only way to use this. First I want is a login form then second forms as we use in access.
View RepliesI need to access a VB variable value
<%
Dim MLNumber
MLNumber=Request.Form("MLS")
%>
to use in an html tag - <img src="HouseImages/MLS.jpg" />
i.e. The images are identified by the same VB var number I'm using in a query, but I can't figure how to access that number with HTML. Got any experienced wisdom to pass on?
Does Anyone Know How To Add HTML into An Access Database? I Am Building A Blog And Have A WYSIWYG Editor. I Get An Illeagle Character Error When I Try To Put HTML Into The Database.
View Replies View RelatedI have a problem with filling up an MS Access Database by using a HTML form. I created 3 files: a HTML form file, an ASP file that executes the command and a MS Access DB containing a table with the fields that I want to fill up. Code:
View Replies View RelatedI just recently created a html form and one of the fields required a date. I want to make it so it will insert the date when the form is being filled out. For example, if I fill out the form today I want today's date on it.
I am going to connect this form to a MS access database, the database also has a field "date". How would I like all these together? Also, I want to send a notice to a specific email whenever someone submits the form.
My client has various Access databases that they want to be able to access (using MS Access, not through ASP pages). I thought I'd be able to create the link from an HTML page but when I do that and click the link, the file is downloaded to the local temp folder. I want the database to open directly from the web server, and then changes must be saved.
View Replies View RelatedI have a table having 3 columns. There is a checkbox for each line. I
need to get those lines whose checkboxes are checked, and show those
lines to another webpage. Is there any way to do that? My concern is
that all information in the table are in <tb></tb> pairs without any
name tag. Any idea?
I'm doing a content management system, whereby the user can enter the HTML code for a currency symbol, eg £ for £.y . when I bring this data backup, say they want to edit the settings, then my ASP/HTML page is rendering the HTML code, eg £, rather than showing the original value, eg £.
If for example I put a space between the '&' and the 'pound;', eg & pound; then this will cause me problems because the user will think that they have to a put a space in or they file it with the space, which means the HTML code won't work any more. Is there a way round this?
i need to include the html inside another html, though it might appear simple, the catch is this, my one html is in one server and my another html is in another server.I cannot read the html and stream it as it has images and their path gets changed when i do that.
More over i donot have any control over the html which i am going to include all i have is a url http:abcxx.htm whose content i want to show in another asp page. The technology is ASP (vbscript and javascript).
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies View RelatedI want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
I generate my codes using a generator. My problem is that I can not write into my Access database. I had gone to tools to allow access permission . still nothing.
View Replies View RelatedI've created a form, using ASP to pull through first and last names from a database into another database. I cannot get it to put a space between the names it pulls through!!! Can anyone suggest what a put between the two to get a space!!
<%= rsGetStaff.Fields("FirstName").Value %><%= rsGetStaff.Fields("LastName").Value %>
I have an asp file that I made and I want to have it when you come to my site, the index.html redirects you to the .asp file, what is the code to do this?
View Replies View RelatedASP is server-side technology.All it does is process data sent from a
client in a Request and generate html to be sent to the client via Response.
You'll probably get a quicker response by posting to a relevant newsgroup.
http://groups.google.com/groups/dir?sel=33584039
What is the difference between HTML and ASP?
Apart from this,i know that ASP can display data from the text file of the server.Can HTML do such thing too?
I need to make a javascript include file using asp. I know how to make the include file with a .asp extention, but I am haveing other truobles
How can I make the < in html code be displayed as < not hidden and executed as normal code? Ex. <body><font color="red">this is text</font></body> would be displayed as that not this is text (but colored red). There's some function... ...can't think of it... ...I kind of does replace(pghtml,">",">"), etc...
since I am getting the data from a database, I need it ALL to go on one line when I response.write it, how would I do this?
I have an index.asp which consists of frameset and frames. The sub-frames
also consists of frameset and frames. This way, I can set the layout of my
webpages.
In one of the frames, I load Login.asp. When it is submitted to
doLogin.asp, I validate the login information. When I validate the password
successfully, I want the whole webpage (the index.asp and down) to reload
because it has to re-draw the menus on top. When the login is failed, it
redirects to Login.asp.
I am having a hard time doing this from my ASP page right after I validate
the login information.
I'am new to the ASP and I have a question about how do I get the name of the form?
<form name="zoekbedrijven" id="zoekbedrijven" method="post" action="form_lijst_bedrijfseenheden_bdrf.asp">
How do I get the form name with ASP like in javascript:
document.forms[0].name
But this doesn't work but how should I do this?
I have a PSD layout and I would like it coded in HTML (well ASP - ie basic, header/footer/middle - ASP not totally necessary) and table-less CSS.
PSD contains a few links up top which would require use of some image rollover technique.
Payment would be via PayPal. Please PM if interested and include experience you have with CSS.
If this is the wrong group, please post a more relevant group. My problem is that I have a .hex file (basically a text file) shown on a web page for download. If one left clicks on the link for this file, the text content is displayed. Someone in my organization wants to prevent this display. Any ideas on how to do this? I hope this is not an ignorant question but I am not a web developer, ... yet.
View Replies View RelatedI have to pass the valut of an HTML text box through POST method but for some reason i m unable to get that value through Response.Form of asp I have to get the value by response.querystring but for that i need to send that value through parameter in URL i dont know how to pass that value of textbox through parameter by post method.
View Replies View RelatedI'm trying to set default value for input type file.
<input type="File" name="tx_pdffile" accept="*.pdf"
class="boxText" value="abc.pdf">
but this value (abc.pdf) doesnt appear in the text box.Whats the solution?
I'm proficient with HTML. Been using it for many years now. I haven't had time to learn any of the newer languages but for what I need, I don't think I have to. I'm hoping someone can point me in the right direction of a tutorial or chunk of code I can simply paste into my existing page.
I've got a website I'm working on which requires *many* new pages within the same site. What I need to know is how to keep my navigational menu, header, logos, etc. in place while only refreshing the body of the text when links are clicked.
I got an ASP application and we need to figure out how to deal with this problem. Users sees text and images via his/her browser and he/she should have a possibility to create a .doc or .rtf file out of what he/she sees. So practically .html page should be converted to .doc or .rtf.
a) converting to .pdf is easier I know, but that's another story
b) opening .html -file inside word is not what I want
For example: user could view certain changing data, and then convert it to .doc/.rtf and save to his/her computer and view/change it offline. ASP component would be nice, but practically anything goes that can be attached to a www-application. It doesn't need to be free.
In html web pages I've used this:
<a href="faq.html">
Now in an asp page (which includes html) I see this:
<a href="?action=forgotpass" >Forgot Password,
Is the "?action=" asp language or html?
I have create search field in that user can enter student number in that field and if database could find that number , it will display that student record in html designed form. What I am doing is that I have create student form also in below of search field so if user find record in database , it will immediately appear in that given form.
But what actually happening is that when my form is loading it will directly check search box and that time nothing appear in that list and it will disply an error msg :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
Someone can suggest me that which event should I trigger.