Access 2000 access data pages

[JDionne]

Im in an access db using there data pages for a client. I need to know if there is a way to get Javascript to call a quiery.
Any thoughts and or examples would be great.
Jim

[khalidali63]

No, unfortunately JavaScript can not use the resources on a system.
Ofcourse unless you want to use NS LiveConnect technology in NS6+ browsers which can use Java but that will limit the solution only to NS browsers.

Khalid

[JDionne]

Originally posted by JDionne
Im in an access db using there data pages for a client. I need to know if there is a way to get Javascript to call a quiery.
Any thoughts and or examples would be great.
Jim

I may be at the wrong place to ask this question, but does anyone know how to make an access data page interact with the database?
Jim

[khalidali63]

interesting...
In
access data pages when created (using wizard) give you the ability to link to a table--columns,and then put a control on the access page where you can browse throgh the records in the database?

If this is what you wanted to know then in access 2000 click on an item in the top manu bar "new object:page" for this to be visible you must have macro design toolbar set to be viewable.

cheers

Khalid

[JDionne]

Originally posted by khalidali63
interesting...
In
access data pages when created (using wizard) give you the ability to link to a table--columns,and then put a control on the access page where you can browse throgh the records in the database?

If this is what you wanted to know then in access 2000 click on an item in the top manu bar "new object:page" for this to be visible you must have macro design toolbar set to be viewable.

cheers

Khalid

I already have the data page created...I have a new requirment, I have to give the ability to fill in one filed and then run a query to populate the rest of the information on the page. I was going to do something like on change run query....but Im not sure how to do that. Any thoughts on that?
Jim

[khalidali63]

I have not worked way too much with Access DB so my knowledge stops here..not sure if you can runa query,But I can tell one thing..( If I remember correctly) when you are in design view you can access to the VBA part of the access page and given some time to this issue I am sure one can figure out a way to run query using VBA,I have done this on reports quite a few times in past.

look into that.

Khalid

[JDionne]

Originally posted by khalidali63
I have not worked way too much with Access DB so my knowledge stops here..not sure if you can runa query,But I can tell one thing..( If I remember correctly) when you are in design view you can access to the VBA part of the access page and given some time to this issue I am sure one can figure out a way to run query using VBA,I have done this on reports quite a few times in past.

look into that.

Khalid
I am well versed in vba, i know how to run quries in vba...but i have neaver seen vba in a web page...the web section is where im new. can you imbed vba in a web page?
Jim

[khalidali63]

as I said not sure,But its microsoft product..lol..I am sure you can do that.

cheers

Khalid