Interface In Access For Data Entry Using Grid View
i often to make a user interface in access for data entry using Grid view. is there a possibility to make Data Entry user interface using Grid in ASP?
View Repliesi often to make a user interface in access for data entry using Grid view. is there a possibility to make Data Entry user interface using Grid in ASP?
View RepliesI have a datbase (db2.mdb) on the server
Here is the information:
DB name-Addresses
Input - user
Input - password
Here is the script that I'm using to try to view, unsuccessfully, the user in this database. Does anyone see the error? Code:
i have a website and i use do import data , but with diffrent types(*.xls,*.xml...)
how can i concept a inteface to read all this files
i now my question is not clear but iit's freindly to answer me
need to enter many entries at a time related to my production. Like
operatorID,operationNO,qty,nohours bla bla
I already designed page. But its used to enter one record at a time. I want
to allow user to enter all operators details for a specific date at a time. I
tried using ADO Connection and ADO recordset. When set the properties, its
displaying error. Its not connecting to database.
How can i use this? or is there any tool having this feature for free? I am
using access database. I want to use this in my LAN only.
I need to display data from a sql server 2000 db on an asp web page and I need a vertical split. Does anyone have any solutions? I really can't afford to spend much/any money so freeware/shareware or coding suggestions is what I am interested in.
View Replies View RelatedI have spent the past several weeks building an ASP.NET 2.0 Application that has a Users.xml file where all user information is stored. I am now designing the administrator tools and want to be able to sort through the records in the XML file. Essentially, I want to be able to build this:
http://beta.asp.net/QuickStartv20/aspnet/samples/data/GridViewSorting_vb.aspx
It seems that every example i hit is a sqlserver example and there doesn't seem to be very good sorting capabilities for XML. is this true? how do i acheive the above link? I would really appreciate any code examples or code links if you know/have them.
This seems a very complicated task, so I welcome any
input. My boss wants a data grid or matrix of the top 6
orders with ordered items, and products, for a particular
customer and he wants to see it like this:
products down the left side
orders across the top
number of items under the respective order number column
across from the corresponding product.
I hope that makes sense.
I have three tables. Products, Orders, Orderitems. I
don't even know where to start. Many thanks in advance
for any input offered.
i m making a page on login basis, i hve an access datbse, after login user will enter a code which is already store in datbase, then form checks if this code is in databse if found then it will show some other records in databse, otherwse disply msg, user enter data in fields, after completing data cursor must go to code agian for another record, this data entry is in bulk, mean 200 recrds or more in one session, so may be i use batch procdure, then form save the records, same time a link on pge to edit this record, or if no code availble , operator can add new records
View Replies View RelatedI'm building a data entry and search tool. I've created a basic search facility and it seems to work ok but I don't know the code to create 'data entry' buttons. I want something that looks the same as the search facility but the submit button creates an entry in the databaseCan anyone give my the relevant commandscode?
View Replies View RelatedDoes anyone know how I can use asp to access a specific entry in a microsoft access database table without having to run a search of the entire database? I figure this can be done with the primary key, but I'm not sure how to do it. I've looked for tutorials, but none seem to deal with this.
View Replies View RelatedI need to write an ASP page that will allow a user to paste in data from an Excel spreadsheet. The data will only be in one column. I'm not a web programmer and would like some advice on the best way to do this.
I have a page working using a text area and some JavaScript to parse the data entries using the split function. This seems to work ok but I wondered if anyone could suggest a better way?
I have a form to enter details about companies into a access DB, it all works fine the way it is set up except this one small problem.
The same company details can be entered again by mistake and take a new record set. Now what I need to know is how to stop this from happening, do I use ASP code to check the DB (if so could someone tell me how it is done) or do I set this up in the Access DB itself.
What I want to happen is if the same company details are entered then the user gets a warning telling them that that company has already been entered.
We are creating a multi-region ASP application which will be using SQL Server 2000. As our users exist in multiple location i.e. UK, US, Australia how can we distinguish that the date the user is entering is captured correctly i.e. no confusion with DD/MM/YYYY format.
I guess to remove database ambiguity I am going to use the format YYYYMMDD format but how do I know in the first place when the user entered 01/06/2006 that the user meant 1st June 2006 or 6th Jan 2006.
I have a table layed out in SQL 2000 like the following:
Username Date Hours Period
john 1/1 10 1
john 1/2 20 1
How simple is it for me to build a data entry form in ASP that would display this with input boxs for the hours field. The problem is I need it to span left to right on th eweb page.
Period 1
1/1 1/2 etc------------>
box box
SUBMIT BUTTON.
The key to the look would be the current period.
I have asp project where large volume of data entry would be done. I am
trying to find out if there is any tool that can allow me to build asp
application where the forms would be like excel spreadsheet.
I have a created a cost reporting system which shows a level-breakdown
report. There are three levels in the report the lowest level holds the cost
items that are entered by the user these records also have an Entry Date.
The level above that is a Sum of the lowest level and the top level is the
Sum of the second level. I created the solution using three queries in
Access. I then use the queries in ASP to generate the report. But now I need
to use the Entry Date at the lowest level to re-generate the report with
values from the StartDate to the EntryDate (which is entered by the user).
Question is, can I do this using the construction I use, or do I have to
pull my queries to the ASP code and include the dynamic EntryDate? How do I
solve this?
As part of a data input script, I ask for a user name to be input into an Access DB field called surprisingly, "UserName". I would like to ensure that username is not duplicated. How do I do that before inserting the data. My example show in the incomplete script below doesn't work? Code:
View Replies View Relatedi have a checkbox Code:
<input class="txtbox" type="checkbox" name="C1" value="ON">
it will correspond to a field in my ms access database that has a Yes/No data type. when the box is ticked, i would simply like the value Yes to be entered into the database..
i enter other elements of my form (a input text box for example) using Code:
rsAddComments.Fields("area") = Request.Form("area")
so what would the entry code look like similar to this.. and what would the for checkbox code look like?
I have a asp code that shows the values from a database. But here it shows all the values in one page. I want to make each record appear in a new page. How can i do it. Code:
View Replies View RelatedI have a large classic ASP web application which needs to now support chinese
character entry (I don't have to worry about the UI yet - the data entry
people can read english). Other than changing the database fields over to
"N" data types, do I need to do anything to the actual entry fields (input,
textbox) on the various forms to be able to capture the information. Some
users will be entering the information in english, while others will be
translating the same info into chinese as they enter it.
I know this is probably much easier in .net, but we have yet made that
transition. Now that 2.0 is available, it should be much more viable.
I'm looking for some advice in creating a page to allow me to view the data stored in am access database. I want to be able to see all of the saved records. Is there a simple way to do this?
I did recently create a page to put the data in this database. I'm proud of this. I still haven't grasped with all my reading, etc. the function of all the code.
i am working with asp 3.0.whenever i enter new data and want to view the data. i can,t view latest data(it shoows the page last visited), i have to refresh the page , then i can view the latest updated records from database.
View Replies View RelatedA client has an OLE field called Signature in an Access database. The field contains a GIF image of a scanned signature (that a product has been received).
How can I show this image on an ASP page?
I keep getting an error that says:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'c:inetpubwwwrootannoneil\_databaseannoneil_AN D.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/annoneil/artist.asp, line 96
The code was working fine a few days ago but now I cannot figure this out.
We are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.
THE RESULTS:
(returns a blank page with only HTML Titles)
THE SCRIPT:
(you may notice this is a modified sample script): Code:
i would like some assistance in creating a user interface that reads from a database.
View Replies View RelatedIs asp/asp.net able to interface with the PC's I/O ports? I'm currently doing a program on VB using the SDK from the vendor to interface my biometric scanner to my PC using usb port. Can this same thing be done using asp?
View Replies View RelatedI made this little application-variable interface to help me see what application variables/values I currently have on the server and it lets me easily add or remove single variables, remove all the variables, or re-create the variables I declare in an ASP file called "CreateVariables.asp". Code:
View Replies View Relatedi'm getting a bit cought up with the ASP for a poll creation page i am trying to do.
i am trying to get it so that it will display a varying number of boxes depending on how many options there will be - have it so that it displays the first 2 (the minimum options) and then the other input form elements will be added as needed i'm also having a bit of trouble trying to get the numbers to update with the onchange but that part doesnt feel like its the most challenging - heres what i have so far: Code:
how to access Outlook methods to generate an "add contact" event on the local user's machine. Most of the info I'm finding relates to Exchange server, not the local instance of OUtlook.
This event will be spawned from an intranet-based ASP page. The online contacts list will have a button to add the contact. On click, the default contact form will be displayed, with the primary fields pre-populated from the recordset selected. I'm sure this is a no-brainer, but haven't done this before.
Is it possible that my asp web application can interface with the hardware? like the PIC or the microcontroller? and if it is possible, what im gonna do?
View Replies View RelatedI'm moving away from Access db's to MS SQL Server databases for storing form records.
While the MS SQL Server provides all the tools I need to edit/delete/add records, I need to provide an interface for non-technical people for obvious reasons.
I have a halfway decent one for manipulating Access databases but it doesn't seem to translate over to SQL Server too well. Obviously I'm fairly new to ASP and SQL but I've tried everything to make this editor work for SQL server.
So, I would like to just start from scratch and ask if anyone has an asp script that acts as a front-end to edit/delete/add records - nothing too fancy.
We got two interface. Staff and member. When member login, they are brought to member's page. However, when staff login, they are also brought to member's page. This is because at Dreamweaver 8, we have specified that if login succeeds, go to member.asp.
So how do I make sure that when staff login, they go to their staff.asp.? Is it by command procedures or SQL or some kind of other function? Much help needed! Project deadline is just around the corner!!!