Recent content by overlordqd

  1. O

    Form's unique table property and stored procedure parameters

    Wow, great workaround. It saved me a lot of time. Thank you.
  2. O

    "#Error" on some fields

    Hi all, I have a problem with two fileds which are bound to an SQL procedure, as shown in the image below. I use Access ADP as frontend, and SQL Server 2008 as backend. This T-SQL procedure works perfectly on SSMS and vb.net. When i click the fields showing #Error, a message shows up...
  3. O

    Question Default time filters on right click ?

    sorry, i renewed the link. by the way my question is not " how can i create right click menus at acc07 ". it is "how can i add default filtering commands to my menu" thanks again.
  4. O

    Question Default time filters on right click ?

    hello all, i am trying to integrate the default time filters (available in access 2007 when right clicked into a date field, as shown below) to a shortcut (right click) menu. is there any way to integrate default filter options to a shortcut menu ? thank you.
  5. O

    database wide trigger, firing with update event

    i got a table for logging. for example the name of the table is log1. i want to log the changes that people make on different tables into the log table. i want to log these(if its possible). table name*, field name*, user name, computer name, date, old data, new data. * which user has...
  6. O

    database wide trigger, firing with update event

    i all, i want to do something like that; if someone tries to update a table, the trigger will fire and add a new record that contains the field name, old value and new value. i have already done a small part of it. the code is below. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER...
Back
Top Bottom