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