09-Nov-2005, 17:50 PM
| ![Arvin Meyer [MVP]'s Avatar](http://www.sikhphilosophy.net/images/avatars/noavatar.gif) | Guest | | | | | | | | | | Re: Run query based on data change in table
There is not such thing as a Trigger on an Access/Jet table. You must either
change your data engine to SQL-Server, or use Access forms which have proper
events for doing this.
--
Arvin Meyer, MCP, MVP
Microsoft Access Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6913
Free Access downloads http://www.datastrat.com http://www.mvps.org/access
"Stu Morris" wrote in message
news:93997195-A510-4BDA-A395-2AE1A333DCF3@microsoft.com...
> I have an InfoPath form which submits and recieves data from an access
table.
> I want to do the calculations in Access, i am using a datediff function to
> calculate the number of days between two dates. I want to have the query
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6913
run
> whenever data is written to the table?
>
> Any suggestions greatly recieved
> Stu
|
09-Nov-2005, 17:50 PM
| | Guest | | | | | | | | | | Re: Run query based on data change in table
Thats a shame
I have attempted to use the defult value in the table but without success
i dont have sql server and if i am not sure how this will impact on my
infopath form.
Is there no other way??
Stu
"Arvin Meyer [MVP]" wrote:
> There is not such thing as a Trigger on an Access/Jet table. You must either
> change your data engine to SQL-Server, or use Access forms which have proper
> events for doing this.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "Stu Morris" wrote in message
> news:93997195-A510-4BDA-A395-2AE1A333DCF3@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6913
> > I have an InfoPath form which submits and recieves data from an access
> table.
> > I want to do the calculations in Access, i am using a datediff function to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6913
> > calculate the number of days between two dates. I want to have the query
> run
> > whenever data is written to the table?
> >
> > Any suggestions greatly recieved
> > Stu
>
>
>  | 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Gurbani Jukebox |  Listen to Gurbani while surfing SPN! | | » Active Discussions | | | | | | |  ਨਾਮਾ Today 06:37 AM 2 Replies, 53 Views | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
