Search results

here is the sample data in the attachement

Hi, I have problem convert the following excel formula in to sql code can someone help me? EXCEL (formula for column called MONTH) =IF(OR(G5="LIBOR",G5="FRCOM"),IF(IF(J5="null",I5,J5)<$A$1,1,ROUNDDOWN((IF(J5="null",I5,J5)-$A$1+1)/365*12,0)),-1) please copy the following sample data into...

not all strings contain '|'

SELECT [TDPosting Table_CPG].[Trade Ref], MID([TDPosting Table_CPG].[Trade Ref], 1,INSTR([TDPosting Table_CPG].[Trade Ref], '|')-1)& LEFT([Book Name],7) & [Posting Currency] AS Product, Right([Trade Ref],Len([Trade Ref])-InStrRev([TDPosting Table_CPG].[Trade Ref],'|')) AS [Trade ID], [TDPosting...

sorry, I have no problem with TD_PLDecompLeg_AFS_HEL_ALL_2-27-2009.csv

Hi, I failed importing filename of TD_PLDecompLeg.AFS_HEL_ALL.2-27-2009.csv in both macro and manually but no problem with TD_PLDecompLeg.AFS_HEL_ALL.2-27-2009.csv any idea? thanks alice

Hi, I would like to extract 13743 from a string CNG_AWE SR TRS PAY Bond 7.875 01Mar11 USD - 13Oct05 to 13Oct09|||13-Oct-09|CNG_AWE|13743 a column in a table has a lot of strings like the one above, but they have different length, such as the one below NAB SUB TRS PAY Bond 8.60 19May10...

Hi, I failed to export a text column (such as 00123) from access tabl to excel. In Excel the column turns to 123 please help thanks

Hi, I built a database which consists of many queries. I notice some query object come empty after I executing some queries. anyone know to how prevent this happen? thanks

could you please provide me detail steps to build the forms called Substrates Demand_Supply and tmp_Substrates? I couldn't upload the file because it is over 399KB if you are interested in taking a look of the database, please email me at alice.t.lee@tdsecurities.com thanks

it works.. thanks

Hi, In the Query11, i am comparing two tables' Prod_Str columns and return the Prod_Str record which doesn't exist in tbl_Reconcile_Loans_Breakage_Loans the query11 doesn't do the job as i expect. could you tell me what the problem is.. thanks

Ken, it doesn't work thanks little Al

Hi , I keep getting runtime error 2488 when executing the following code highlighted in Red: Private Sub cmd_Total_Cairo_Per_Month_Click() Dim tostring As Date Dim fromstring As Date fromstring = CDate(Format(InputBox("Please enter from month and year (mmm yyyy)"), "mmm yyyy")) tostring =...

I removed the following Close form event. and it works fine without delete the data. DoCmd.Close acForm, "frm_Create", acSavePrompt any idea? my application allows users to select a record from a list (let's call it RECORD LIST FORM) and then display the selected data in a form (UPDATE...

Public Sub Set_value_Sec(DN As String, DT As String, DD As String, Ref As String, CN As String) Itm_Deal_Name = DN Itm_Document_Type = DT Itm_Document_Date = DD Itm_reference = Ref Itm_customer_name = CN End Sub Public Sub Set_value_Admin(DN As String, DT As...

Hi, the following code is to call a function to display data in a form and then print it. I don't understand why the following code would delete data after printing. please advise Private Sub Cmd_Print_Click() Dim db As Database Dim lrs As DAO.Recordset Dim LSQL As String...

I should clarify more... I would like the forms to remain full screen size after closing some other forms.. please advise.. thanks

Hi, My switchboard , other stuffs are built in form. the switchboard would open the first form and then the first form would open the second form. Please note, they are open in full screen size when I close the second form, or some other forms. the switchboard and the first form would be...

HI, TrackingID is a column which has integer type. I should give you some background about my tool. I am creating an application which let users to select a record and view/open the selected record in another form. the following is how I called the second and display on the second form...