Data Access Pages

[Studders1]

Im playing about with Data Access Pages for the first time because i need to learn them soon and i want to try and put together an order system for a webpage, the webpage isnt going to be online yet as i have no idea about SQL or php but heres my situation.

I have created 2 tables one called Stock and one called Orders.

I have made a DAP with 2 list boxes on it, one side i have the stock file and in the other i have the order list. I want a button the lets me add items from the stock file into the orders list, and the total price box to update with each item that is added. If someone could help me with this that would be ace.

Cheers

 

[boblarson]

My recommendation is to avoid DAP's because they are no longer supported, or included, in Access (2007). They are a failed experiment and you would be much better off using other technologies to do it. You might even explore using Visual Web Developer Express from Microsoft. It might be able to do what you need.

 

[boblarson]

See here for the free development tools:
http://www.microsoft.com/express/

 

[Studders1]

Thanx for the quick reply but we have been specifically asked about DAP's and i would just like a little knowledge on them so could someone please try and answer my question, many thanx

 

[Studders1]

See here for the free development tools:
http://www.microsoft.com/express/

Would SQL express be easier to use to make a simple order page for a website then?

 

[boblarson]

If you insist on using DAP's, you must read these first as it may affect your decision to go forward:

http://office.microsoft.com/en-us/ork2000/HA011381111033.aspx

http://support.microsoft.com/kb/264080

http://msdn.microsoft.com/en-us/library/aa140081(office.10).aspx

Would SQL express be easier to use to make a simple order page for a website then?

I don't know that it would necessarily be easier but it would have the ability to be more secure and be able to ensure ongoing support for it as Microsoft continues to build on their .NET technologies.

 

[Studders1]

If you insist on using DAP's, you must read these first as it may affect your decision to go forward:

http://office.microsoft.com/en-us/ork2000/HA011381111033.aspx

http://support.microsoft.com/kb/264080

http://msdn.microsoft.com/en-us/library/aa140081(office.10).aspx



I don't know that it would necessarily be easier but it would have the ability to be more secure and be able to ensure ongoing support for it as Microsoft continues to build on their .NET technologies.

Thanx for the advice and i will have a read, but i would also like my original question answered if thats ok. Cheers anyways

 

[Rabbie]

Thanx for the advice and i will have a read, but i would also like my original question answered if thats ok. Cheers anyways

There didn't seem to be a specific question in your original post - just a general request for help. My advice to you is to read the articles Bob posted and then ask specific questions about things you don't understand. That way I am sure you will get a better answer.

 

[Studders1]

There didn't seem to be a specific question in your original post - just a general request for help. My advice to you is to read the articles Bob posted and then ask specific questions about things you don't understand. That way I am sure you will get a better answer.

This question:

Im playing about with Data Access Pages for the first time because i need to learn them soon and i want to try and put together an order system for a webpage, the webpage isnt going to be online yet as i have no idea about SQL or php but heres my situation.

I have created 2 tables one called Stock and one called Orders.

I have made a DAP with 2 list boxes on it, one side i have the stock file and in the other i have the order list. I want a button the lets me add items from the stock file into the orders list, and the total price box to update with each item that is added. If someone could help me with this that would be ace.

Cheers

 

[Rabbie]

Studders1, You still don't seem to get my point. Your question, now repeated twice, is still a general request for help. This forum tends not to indulge in spoonfeeding the answers but will be very helpful if you ask a specific question. Use the Access wizards for creating buttons. if that doesn't work then tell us what you have done and what doesn't work and we will be able to help you.

You will find people helpful but they won't do your work for you which seems fair enough since everyone here is doing it voluntarily

BTW is this a class assignment?