Search results

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...

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

can i make multiple entries in sub form which is unbound...how?

can i have a report in access based on sql server view that is being open/retrieved bis connection string

Hi I m using the following VBA to add/update/delete records in the table on my SQL server but getting errors on Records. update....Record update run time error3146 ODBC Call Failed Private Sub Command43_Click() Dim Records As DAO.Recordset Dim Records1 As DAO.Recordset Dim...

Hello All

please help me locate issue in following code..... Dim Records As DAO.Recordset Dim Records1 As DAO.Recordset Set Records1 = CurrentDb.OpenRecordset("Select ID, Paid From RentInvoice where ID = " & Me.Text6, dbOpenDynaset, dbAppendOnly) Debug.Print ID, paid With Records1 Records1.Edit...