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

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

yes u r correct...!! just want to know if there is some function to convert format of numbers/int from sql into standard/currency

yes now working date display as 03-Feb-24 thanks!!! same issue is with numbers...i want them to be displayed in standard format but no luck

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

sorry but this function isnt working

yes it does...i m extracting data from sql server via connection string

it displays as mm/dd/yyyy i want a display of dd-mmm-yy and i m trying this using format function on datetime filed queried from sql server

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

what is the best way to get multiple entries in a form and save all to sql sever table. Its a sub form of a main form and both are unbound

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

yes the BE is on LAN SQL server ...please guide me to correct what you feel i m doing incorrectly

well i m using a connection string to connect whenever need be and close DB connection as soon as i m done. Previously i used linked tables but users have to wait long for queries and forms and report to open or load. But your point looks valid and i m now considering to use linked tables for...

ADP not available...temp table work around looks good...can u please elaborate ....thanks

i m using following code but is didnt work... Private Sub Report_Load() Dim rs As Object Dim strSQL As String ' Connect to the database ConnectDB ' Create a recordset object Set rs = CreateObject("ADODB.Recordset") ' Set the SQL query strSQL =...

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