hi i m just wondering if i can put all deleted records from table in a on table that has a column and insert deleted row into it by concatenating..i created a trigger but its giving error on column name!!!...below is the trigger.....
USE database;
GO
CREATE TRIGGER TenantDeleted ON RT_Tenant...
Hi guy just trying to fetch invoice data from sql server table that has multiple rows in it so that i van edit the prices and other fields and then update the rows back to sql server table. but no luck...i tried main form and sub form with combo that is built on same table invoice number but its...
now i m facing problem is insert statement. when i use the date inserted on access form in my tsql insert via vba its giving error. the issue is of date format. access form has date in dd-mm-yy
Sorry for the late response...yes well i use your above code in access.....make a public function and try using it on form/report that drives data from sql server....
i m using MSSQLDateTime2ToDate([MySQL_DateField],"dd-mmm-yy") function in access forms, but it displaying same format yyyy-mm-dd...
Sorry for the late response...yes i m using Format([MySQL_DateField],"dd-mmm-yy") function in access forms, but it displaying same format yyyy-mm-dd. I want to get date in this format...dd-mmm-yy like 03-Mar-24
i have a report in access that drive data from sql server query. the date format my report displays is mm/dd/yyyy. i want to display it dd-mmm-yy. i tried format function but its giving error. Any idea what i m doing wrong
Actually i have a master and detail table of receipts from customers. i m trying to capture receipts master data on form and add a sub form to capture detail records of receipts. both my form are un bound and i m using sql server db as backend and use connection and insert/update etc queries in...