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

Mark A Matte markamatte at hotmail.com
Thu Dec 6 10:28:56 CST 2007


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_sharelif
>>>>> 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_TA
>>>> 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_newways_
>>> 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_TAGLM_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 Vista® + Windows Live™.
http://www.microsoft.com/windows/shop/specialoffers.mspx?ocid=TXT_TAGLM_CPC_MediaCtr_bigscreen_102007



More information about the AccessD mailing list