Linking Ms Access Database Wif PS/2 Barcode Reader
anyone knows how to do this using ASP? any coding needed?
View Repliesanyone knows how to do this using ASP? any coding needed?
View RepliesI am trying to build a simple webpage for a college project I am required to use ASP in this project. I simply need to link my webpage to an access database to display the information on the page. I have managed to do this with all text information using the following code:
View Replies View RelatedI was just wondering if there is anyway to link tables from another Access database using ASP. Just like the function in Access where we can go File->Get External Data->Link Tables.
I have implemented some e-modules and they all have individual database as a backend. But, my boss would like to allow all these e-modules to share data. Therefore I am thinking of linking all the tables in those databases through a 'gateway' database (gateway.mdb). This 'gateway' database would have link tables from all other databases.
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'm working on getting a list of links to other forms on my database to show up in an order determined by an additional field in a database. This line right here works for this (note the bold part is what I'm editing):
Set rs = cnnSimple.Execute("SELECT * FROM [resource domain] where RESID= """ & rstSimple.Fields("RESID").value & """ ORDER BY [Links].Precedence ASC;")
But I actually don't want to sort by Precedence (that's being used for sorting another field). Instead I want to sort by another colum in the same form called BelongOrder. I try this simply by doing:
Set rs = cnnSimple.Execute("SELECT * FROM [resource domain] where RESID= """ & rstSimple.Fields("RESID").value & """ ORDER BY [Links].BelongOrder ASC;")
But I get the following error:
Microsoft JET Database Engineerror '80040e10' ....
I have created a form using HTML and Javascript. When I click on the submit button I need the Selected Answers to be sent to an Excel or MS-access or any database. I need to know whether this is possible using CGI/ASP. I guess ASP would be better. If not which one do you think is the best way to carry out.
View Replies View RelatedI'm just new for RSS Feed based on XML files so I'd like to know if somebody knows about a good ASP class or functions to read and display these files.
View Replies View RelatedCan anyone recommend a good,reliable server-side RSS reader that is VBScript based?
View Replies View RelatedI'm just new for RSS Feed based on XML files so I'd like to know if somebody knows about a good ASP class to read and display these files.
View Replies View RelatedI am working with a client who wants to integrate barcode scanning
technology into a website I'm building for him (ASP and ASP.NET site).
Specifically, he wants to use barcode scanning in his order
fulfillment process. He wants an employee to bring up an order, then
scan in the products being shipped with the order, then mark the order
as processed.
I've read posts that point to barcode scanners that will simulate
keystrokes and simply input the scanned information directly into a
web form. This sounds like the direction we need to head.
Does anyone recommend a particular company's scanner and / or
communication software between the scanners and the website? I've
heard about Symbol and L-Tron, any others? Can anyone give me any
pointers on how to establish communication between the scanners and
the website, as I'm still a little fuzzy on how to accomplish this?
Does anyone have any experience of using barcode reading software with ASP applications?
I have an ASP-based application where Serial No's are entered manually. The users want to move across to a barcoding system so Serial No's can be picked-up automatically.
I have no experience in this area... Are there appropriate tools out there?Can anyone give me a few pointers?
How can I get my reader (outlook express) to purge out the threads that are "Message is no longer available on the server" Is there a way?
View Replies View RelatedI'm coding my graduation project for Information Systems at the University Of Cape Town, and have come into a little problem. My system is an inventory and point of sale system, which is running on asp, using vbscript. I need to scan in barcodes using the ps2 port, thus overriding the keyboard when scanning.
How do i accept the barcode scanner input and assign it to a variable, and validate it according to barcode standards?
I have tickets printed with barcode. When i scan that code is placed in a text box of my form. How can i read from the scanner and put it in a specific text box? Or i directly want to insert into database. This is my actual requirement.
View Replies View RelatedDoes anyone know of any ASP-based newsgroup reader (probably based upon
ASPNNTP)? I'm looking for a full-featured reader that I can host, similar to
Google Groups.
I have a client that has asked if I can provide his users with a downloadable rss reader that is hard-coded to his XML feed only.I'm thinking the download should be a java applet.
View Replies View RelatedI'm having some problems with the Reponse.BinaryWrite, IE 6.0 and Adobe Reader 6.0. When I try to write a pdf-file to an IE browser with a Adobe Reader 6.0 installed then it just displays a blank page and the earth on the top rigth corner keeps turning like it haven't read the pdf-file (for 10+ minutes on a lan).
If I change the settings on the Adobe Reader 6.0 to not open in a browser, then it works fine. If I use Mozilla 1.4 then it opens fine as well.It works fine as well with Adobe Reader 5.1. The code looks like this:
[Some code that places the pdf-file in a byte array called vntStream]
Response.Clear
Response.ContentType = "Application/pdf"
Response.BinaryWrite = vntStream
Response.end
I have tried to place a Response.Flush after the BinaryWrite, but it just makes the Adobe plug-in say something like "document corupted".
I would like to get more info regarding how to print barcode from ASP page to the default printer on the network(based on IP)? Been trying to google for related info but couldn't find any that helps as most of them are .NET related.
Maybe someone here can tell me where can I find more info regarding the question above?
I realized an application, made in visual studio 2005 where I designed a report in crystal reports. I have to include in this report a bar code(code 128) and after to save/print in pdf format.
If I save it in word, it's o.k ...but in this format the user can modify the fields and this not help me.
I have a product that when scanned into the web site will scan as a single piece of string but it is really made out of start code - A0, componeneet code - 00150, stop code 3B, how could I drop prefix and sufix when the product is scanned so it only scans the actual product code.
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 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?
I have a project where all the links go to an intermediary page
before being redirected to the destination page. For example,
there is a link, say to final.asp. But final.asp only redirects the user
to final_last.asp which is the actual destination.
Is there any reason for this indirection? It would seem one could save
space and make things more efficient by going directly to the actual
destination page. Did the author have a reason for doing things this
way?
I want to display the results from 2 seprate mdb's in this manner on an asp page.
If fieldName from dbtable in A.mdb is the same as fieldName in dbtable B.mdb then display all fields. I assum this is sql, so any help woud be great..
i made a little page called billing.asp. I seen on some websites where they can do somin like ie: billing.asp?id=34 and it brings up a record. How can I do that id=34 part?
View Replies View Relatedis there any way i can get a link to access a database cause am trying to make a profile page but with just 1 page for the profile to be on.
< a href="link-to-page=id-of-member"></a>
My background is Crystal Reporting. In one of my Reports i had to create a Hyperlink which opens up a .asp FORM in which the user types in data and clicks SUBMIT, as soon as he does that it should get updated in the Oracle 9 database, i have the code for the .asp form and also for the .asp page which inserts data into the Oracle Database, My question is how to link these two .asp pages.
View Replies View RelatedI am in the process of making an online examination system. The exam will have a total of 100 questions and each question has a time limit. I have done with coding of a question and setting time limit. Each question will get its question from a database table and also the 4 options.
Now my problem is that how i create 100 asp files for 100 questions??.. how can i link them so that when a user clicks submit button, he is taken to next asp file(question).. files are numbered as 1.asp,2.asp...etc. Is there any way i can create a template or something and files and links be automatically generated.
Now when somebody goes to the site www.mysite/allphotos.asp , it ask for the id/password and if the password is correct (as checked by another file ' password.asp' ) the user is redirected to a new page www.mysite/viewall.asp else it is redirected back to www.mysite/allphotos.asp with an error message. Now till this point all is working fine. But if somebody types in www.mysite/viewall.asp directly to their browser they would bypass the password page i have created and hence the security fails.
how can I redirect back to www.mysite/allphotos.asp if a user types in www.mysite/viewall.asp in the browser.I have tried assigning a variable (say goAhead = 0) in the password.asp file when the login is true. In the head of www.mysite/viewall.asp it checks if goAhead is not 0 it redirect back to www.mysite/viewall.asp . Now what is happening is that I can't open www.mysite/viewall.asp rightaway but even when password is correct it stll won't open and is redirecting back to allphotos.asp
Is there a way to make an image link to a field I already have in a database? Can I just simply put an html command to a link in a database in Access to an image? Or do I have to do an OLE object? I have no idea how to make an OLE object link to something.
View Replies View RelatedOur company has a website in place that allows users to get information. I've been asked to call a custom made dll that returns a registration number to the user. I don't know much about dlls or coding concepts for that matter (I've built pretty basic client/server asp websites only), but I would like to be able to at least ask the right questions so that I can understand just what I need to look into to do this.
Does it depend what "kind" of dll it is and what language it's written in? Do I then just need to know the arguments it takes? How do you register a dll?
I need to link to a javascript function from a REsponse.write line
I can do this but when I try to use a record (ie. rs("Product Name"))
it doesnt work. I tried something like this:
Response.Write "<a href="""" onClick=""rePopulate(''rs(""Product Name"")'');"">Product</a>"
It's this bit thats the problem I think .. I know its probably to do with quotes r smth but rePopulate(''rs(""Product Name"")'').