Answered by:
Data entry site for MS Access database

Question
-
User-1147294540 posted
I am trying to make a web based data entry site for and MS Access database. I’ve been able to get it to view and navigate to several tables. As well as add and edit the tables separately. However when I link them and try to add or edit, it fails. The way I’m trying it is with simple access data objects, with where statements, and queries. When I add a query though, it fails. If I add “edit” and “add” commands to a linked table it also fails. This is my first time trying this in ASP. I am using visual web developer 2010, and my tables are as follows:
Customers
- MTID
- Last
- Middle
- First
- Street
- City
- State
- Zip
- Phone
Program Fees
- PFID
- Assessed Amount
- Payment Agreement
Payments
- PID
- Payment Date
- Payment Amount
What I’m trying to do exactly is look up customer by last name. (This works OK)
If customer doesn’t exist add him. (I haven’t been able to get this to work yet)
On selecting a customer from returned list, open all program fees for that customer. (This works OK)
If no program fees exist add it. (I haven’t been able to get this to work yet)
On selecting a program fee from returned list, add payment. (I haven’t been able to get this to work yet) (I will also need a link to view payment history)
This is easy for me in Access, but I’m having the worst luck with doing it in ASP. I have a feeling I may be approaching this all wrong. If anyone can help me, I will be eternally grateful. I have a feeling I may be approaching this all wrong.
Sunday, December 5, 2010 3:00 AM
Answers
-
User-1199946673 posted
this links may helps you
Hello! These forums are intended for ASP.NET related questions only. And the question is:
I am trying to make a web based data entry site for and MS Access database....
So no, these links are not helpfull at all!
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Wednesday, December 8, 2010 7:48 AM
All replies
-
User-1659704165 posted
hi,
What Error are you getting?
Monday, December 6, 2010 6:16 AM -
User-1675817941 posted
hi,
this links may helps you
http://www.functionx.com/access/Lesson18.htm
http://www.databasedev.co.uk/start_up_screen.html
thanks,
Wednesday, December 8, 2010 2:57 AM -
User-1199946673 posted
this links may helps you
Hello! These forums are intended for ASP.NET related questions only. And the question is:
I am trying to make a web based data entry site for and MS Access database....
So no, these links are not helpfull at all!
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Wednesday, December 8, 2010 7:48 AM