Calling all Data Access Page Gurus

[PBXJay]

Ok, I've got my form to work the way I want it with combo box dependent on another combobox....

I went to translate it into a DAP and lo an behold I can't figure it out. HELP. Spent over 3days on this part before running for help. Looked on the web/faq.

This is the query that runs in my second cbo. How does it fit into my DAP?

SELECT EmployeeName.Name1, EmployeeName.Dept
FROM EmployeeName
WHERE (((EmployeeName.Dept)=[forms]![Trouble].[cboDept]));

I am able to make a drop down box on my DAP but it doesn't seem to let me store the value.

 

[PBXJay]

do I need ElementExtension Object somehow?

 

[fneily]

First, concepts. DAP's are NOT forms. They are web pages. They do not dwell in Access. They have an extension of .htm, a web page file. You do not code them like forms, using VBA. They must be coded using web languages such as JScript or VBScript.
It's better to create a DAP from scratch in the Page objects department then try to translate a form into a page.
So, here's some reading:

How to Find a Record from a Drop-down List in a Data Access Page

http://support.microsoft.com/?kbid=247823

Look Up Values in a Data Access Page in Access 2000

http://support.microsoft.com/?kbid=234301

 

[PBXJay]

Maybe I was not fully understanding DAP uses. I was told they were the easiest way to access your database from the web and look up as well as add records to your database.

I have a simple database I need people to add to.

I have a department dropdown they Must choose

I wanted to have the list of people in the next dropdown dependent on that department choice above.

I want them to be able to choose a start date

And add a simple description of the issue.

Can I do all that through the DAP or should I just learn ASP to do what I want?

Thanks again for the advice.
J

 

[fneily]

department dropdown - did you read the reference?
start date - do you want a web page calendar?
add a description - when you create your DAP, you must have the primary key there for adding/editing.
Here's more reading:
Fill Record with Data from Selected Record on a Data Access Page

http://support.microsoft.com/?kbid=234217

Programming Data Access Pages

http://msdn2.microsoft.com/en-us/library/aa140042(office.10).aspx#programdap_tipstricks

You think ASP is easy?

Sounds like you haven't tried anything yet. Read the references, try the coding, then you can ask specific questions on the code.

 

[PBXJay]

Yeah... I did read it. Just wanted to make sure DAP was the right vehicle.


No I don't think ASP is easy but if I am going to invest time in something I'd like it to be something that is going to do what I want and that microsoft isn't phasing out like the DAP. If DAP can do it, I'd rather use it because I'm 50% there or so....

Thanks for the reference links will check it out.

 

[JoeAtWork]

Actually, ASP is already "phased out", the current MS web technology is ASP.NET 2.0 (but soon the standard will be 3.0/3.5).

 

[PBXJay]

oh, ok. Thanks. <pulling hairs out of head by handful>