[AccessD] Data Access Pages(was:HTML page updating Access db)

Mark A Matte markamatte at hotmail.com
Fri Dec 7 14:28:58 CST 2007


Hello All,

I have never used DAP(data access pages) before.  I am actually very impressed.  I am working with an example from MS that uses Northwind...I have the code in front of me...and still cannot figure out why I can't get it to work.  The example works...I just can't recreate it.

It is a search feature that causes 1 frame to update and filter and page in another frame.

here is a link to the EXE...

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

If anyone has time or knowledge about this...it is most appreciated.

Thanks,

Mark A. Matte


> From: max.wanadoo at gmail.com
> To: accessd at databaseadvisors.com
> Date: Thu, 6 Dec 2007 22:40:29 +0000
> Subject: Re: [AccessD] Data Access Pages(was:HTML page updating Access db)
>
> Yes, I guess so, but sometimes one has to compromise to get a *reasonable*
> result. Not everything can be all things to all men. At least they can do
> what you need them to do.
>
> Max
> * for reasonable, read 'Not perfect but the best in the circumstances'.
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
> Sent: Thursday, December 06, 2007 9:13 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Data Access Pages(was:HTML page updating Access db)
>
>
> Thanks Max...both of those would work instead of using ENTER...but the users
> would prefer the ENTER key.
>
> Thanks,
>
> Mark
>
>
>> From: max.wanadoo at gmail.com
>> To: accessd at databaseadvisors.com
>> Date: Thu, 6 Dec 2007 17:54:44 +0000
>> Subject: Re: [AccessD] Data Access Pages(was:HTML page updating Access
>> db)
>>
>> Also, would using the Tab key do the trick?
>> Max
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A
>> Matte
>> Sent: Thursday, December 06, 2007 4:29 PM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Data Access Pages(was:HTML page updating Access db)
>>
>>
>> Thanks to everyone for the help. This is the solution I needed...but
>> now I have new questions.
>>
>> Anyone know how to control the EnterKey Behavior on a Data Access
>> page? It wants to add a new line instead of going to the next field.
>>
>> Thanks,
>>
>> Mark
>>
>>
>>> From: max.wanadoo at gmail.com
>>> To: accessd at databaseadvisors.com
>>> Date: Thu, 6 Dec 2007 07:22:59 +0000
>>> Subject: Re: [AccessD] HTML page updating Access db
>>>
>>> Mark, this is really weird. With one of my tables I can create the
>>> DAPs and edit/write etc both using table and query. With another
>>> table I cannot edit/write. I can see no difference between them. I
>>> can do anything to either table. I can do anything to either query.
>>> But for some reason the DAPs will work with one table/query and not the
> other.
>>> Just don't know, sorry. I have never used these before.
>>>
>>> If you do figure it out, I would appreciate knowing what the answer was.
>>>
>>> Thanks
>>> Max
>>>
>>>
>>> -----Original Message-----
>>> From: accessd-bounces at databaseadvisors.com
>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A
>>> Matte
>>> Sent: Wednesday, December 05, 2007 10:07 PM
>>> To: Access Developers discussion and problem solving
>>> Subject: Re: [AccessD] HTML page updating Access db
>>>
>>>
>>> So far I have got the DAP to display the data I need...I now realize
>>> I cannot update this data??? If I build the page directly from the
>>> table...I can edit the data, but if I build it from a query I cannot?
>>>
>>> Any guidence...I've pulled most of the hair out!!!!
>>>
>>> Thanks Again,
>>>
>>> Mark A. Matte
>>>
>>>> From: max.wanadoo at gmail.com
>>>> To: accessd at databaseadvisors.com
>>>> Date: Wed, 5 Dec 2007 18:06:03 +0000
>>>> Subject: Re: [AccessD] HTML page updating Access db
>>>>
>>>> Or one query filter by username.
>>>> Max
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: accessd-bounces at databaseadvisors.com
>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A
>>>> Matte
>>>> Sent: Wednesday, December 05, 2007 5:59 PM
>>>> To: Access Developers discussion and problem solving
>>>> Subject: Re: [AccessD] HTML page updating Access db
>>>>
>>>>
>>>> I'm not sure I'm following... would I need a seperate query and page
>>>> for each user?
>>>>
>>>> Thanks,
>>>>
>>>> Mark
>>>>
>>>>
>>>>> From: max.wanadoo at gmail.com
>>>>> To: accessd at databaseadvisors.com
>>>>> Date: Wed, 5 Dec 2007 17:45:27 +0000
>>>>> Subject: Re: [AccessD] HTML page updating Access db
>>>>>
>>>>> Why not use a query?
>>>>> Max
>>>>>
>>>>>
>>>>> -----Original Message-----
>>>>> From: accessd-bounces at databaseadvisors.com
>>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A
>>>>> Matte
>>>>> Sent: Wednesday, December 05, 2007 5:30 PM
>>>>> To: Access Developers discussion and problem solving
>>>>> Subject: Re: [AccessD] HTML page updating Access db
>>>>>
>>>>>
>>>>> WOW>..I have never used data access pages...looks good so far. For
>>>>> WOW>this
>>>>> example...I need 3 different people to view only their data...how
>>>>> can I filter the DAP?...can I use API calls in them to get the user
>> name?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Mark
>>>>>
>>>>>
>>>>>
>>>>>> From: max.wanadoo at gmail.com
>>>>>> To: accessd at databaseadvisors.com
>>>>>> Date: Wed, 5 Dec 2007 16:38:23 +0000
>>>>>> Subject: Re: [AccessD] HTML page updating Access db
>>>>>>
>>>>>> Would Data Access Pages do the trick?
>>>>>> Max
>>>>>>
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: accessd-bounces at databaseadvisors.com
>>>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A
>>>>>> Matte
>>>>>> Sent: Wednesday, December 05, 2007 4:25 PM
>>>>>> To: Access Developers discussion and problem solving
>>>>>> Subject: Re: [AccessD] HTML page updating Access db
>>>>>>
>>>>>>
>>>>>> Thanks Everyone for the feedback. I was hoping to just have this
>>>>>> temporary fix on a shared drive. as mentioned below...ASP requires
>>>>>> IIS...is there a way to update data in a db without IIS? Client
>>>>>> side
>>>>> instead of server?
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Mark
>>>>>>
>>>>>>
>>>>>>> Date: Tue, 4 Dec 2007 17:16:39 -0800
>>>>>>> From: accessd at shaw.ca
>>>>>>> To: accessd at databaseadvisors.com
>>>>>>> Subject: Re: [AccessD] HTML page updating Access db
>>>>>>>
>>>>>>> Mark:
>>>>>>>
>>>>>>> To update it from a web site you will need to know something
>>>>>>> about a web language or two (like ASP/ASP.Net), Have access to an
>>>>>>> IIS web server so you can set everything but after the initial
>>>>>>> fan-fair it is fairly straight forward.
>>>>>>>
>>>>>>> Jim
>>>>>>>
>>>>>>> -----Original Message-----
>>>>>>> From: accessd-bounces at databaseadvisors.com
>>>>>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A
>>>>>>> Matte
>>>>>>> Sent: Tuesday, December 04, 2007 11:23 AM
>>>>>>> To: Access Developers discussion and problem solving
>>>>>>> Subject: [AccessD] HTML page updating Access db
>>>>>>>
>>>>>>>
>>>>>>> Hello All,
>>>>>>>
>>>>>>> I need a down and dirty...doesn't have to be
>>>>>>> pretty...solution...we need about 15 people to run through some
>>>>>>> records...and change about
>>>>>>> 4 fields in each record(the change depends on individual
>>>>>>> conversation...cannot automate).
>>>>>>>
>>>>>>> These users do NOT have MS Access(where data currently resides).
>>>>>>> I know
>>>>>>> (barely) how to link to this data and display it in HTML...but I
>>>>>>> don't know how to update it from HTML...any suggestions on crash
>>>>>>> course web sites...or anyone have an example?
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>> Mark A. Matte
>>>>>>> _________________________________________________________________
>>>>>>> Share life as it happens with the new Windows Live.Download today
>>>>>>> it's
>>>>>> FREE!
>>>>>>> http://www.windowslive.com/share.html?ocid=TXT_TAGLM_Wave2_sharel
>>>>>>> i
>>>>>>> f
>>>>>>> e
>>>>>>> _
>>>>>>> 1
>>>>>>> 12007
>>>>>>> --
>>>>>>> AccessD mailing list
>>>>>>> AccessD at databaseadvisors.com
>>>>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>>>>> Website: http://www.databaseadvisors.com
>>>>>>>
>>>>>>> --
>>>>>>> AccessD mailing list
>>>>>>> AccessD at databaseadvisors.com
>>>>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>>>>> Website: http://www.databaseadvisors.com
>>>>>>
>>>>>> _________________________________________________________________
>>>>>> Put your friends on the big screen with Windows VistaR + Windows
> LiveT.
>>>>>> http://www.microsoft.com/windows/shop/specialoffers.mspx?ocid=TXT_
>>>>>> T
>>>>>> A
>>>>>> G
>>>>>> L
>>>>>> M_CPC_
>>>>>> MediaCtr_bigscreen_102007
>>>>>> --
>>>>>> AccessD mailing list
>>>>>> AccessD at databaseadvisors.com
>>>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>>>> Website: http://www.databaseadvisors.com
>>>>>>
>>>>>> --
>>>>>> AccessD mailing list
>>>>>> AccessD at databaseadvisors.com
>>>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>>>> Website: http://www.databaseadvisors.com
>>>>>
>>>>> _________________________________________________________________
>>>>> Connect and share in new ways with Windows Live.
>>>>> http://www.windowslive.com/connect.html?ocid=TXT_TAGLM_Wave2_newway
>>>>> s
>>>>> _
>>>>> 1
>>>>> 12007
>>>>> --
>>>>> AccessD mailing list
>>>>> AccessD at databaseadvisors.com
>>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>>> Website: http://www.databaseadvisors.com
>>>>>
>>>>> --
>>>>> AccessD mailing list
>>>>> AccessD at databaseadvisors.com
>>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>>> Website: http://www.databaseadvisors.com
>>>>
>>>> _________________________________________________________________
>>>> Share life as it happens with the new Windows Live.Download today
>>>> it's
>>> FREE!
>>>> http://www.windowslive.com/share.html?ocid=TXT_TAGLM_Wave2_sharelife
>>>> _
>>>> 1
>>>> 12007
>>>> --
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>> Website: http://www.databaseadvisors.com
>>>>
>>>> --
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>> Website: http://www.databaseadvisors.com
>>>
>>> _________________________________________________________________
>>> Put your friends on the big screen with Windows VistaR + Windows LiveT.
>>> http://www.microsoft.com/windows/shop/specialoffers.mspx?ocid=TXT_TAG
>>> L
>>> M_CPC_
>>> MediaCtr_bigscreen_102007
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>>
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>
>> _________________________________________________________________
>> Put your friends on the big screen with Windows VistaR + Windows LiveT.
>> http://www.microsoft.com/windows/shop/specialoffers.mspx?ocid=TXT_TAGL
>> M_CPC_
>> MediaCtr_bigscreen_102007
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> You keep typing, we keep giving. Download Messenger and join the i'm
> Initiative now.
> http://im.live.com/messenger/im/home/?source=TAGLM
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Your smile counts. The more smiles you share, the more we donate.  Join in.
www.windowslive.com/smile?ocid=TXT_TAGLM_Wave2_oprsmilewlhmtagline



More information about the AccessD mailing list