Search results

it works, iam actually just trying how to delete a record.

The Following is my Sql, iam able find the record to delete but iam unable to delete as its Says "Specify the table Containing the records you want to delete" DELETE tblBciCMiA.ContNo, tblBciCMiA.InvNo, tblBciCMiA.Seller, tblBciCMiA.Buyer, tblBciCMiA.Qty, tblBciCMiA.Cert, tblBciCMiA.RQty...

Yeah put some efforts and got is solved by just the following: WHERE (CASE WHEN ([tblcontract].[ShipCont] = 4 OR [tblcontract].[ShipCont] = 7) AND [tblcontract].[DtShip04] IS NOT NULL THEN [tblcontract].[DtShip04] ELSE NULL END IS NOT NULL)

Many Thanks for the earlier post, iam just doing one more step at a time. Iam having issues with below with the WHERE Clause, WITHOUT WHERE its working, Can someone tell me why. SELECT CASE WHEN ([tblcontract].[ShipCont] = 4 OR [tblcontract].[ShipCont] = 7) AND...

Iam having trouble here now, can some one help SELECT CASE WHEN ([tblcontract].[ShipCont] = 4 OR [tblcontract].[ShipCont] = 7) AND [tblcontract].[DtShip01] IS NOT NULL THEN [tblcontract].[DtShip01] ELSE NULL END AS LSDDate, ContNo CASE WHEN...

iam getting the Incorrect Near the Keyword 'AS', Can anyone help me. The following is the code. SELECT CASE WHEN [tblcontract].[ShipCont]=2 OR [tblcontract].[ShipCont]=3 THEN CASE WHEN [tblcontract].[DtShip02] IS NOT NULL AND [tblcontract].[DtShip03] IS NOT NULL AND...

Looks like there are some null values in the SQL it returns nothing. is there any other way to solve this

I want to Show 02-Order-19.

i have attached the screenshot of the Table

I Have a tbl for courier having Order Number and Reference. I have "Tea" and "Coffee" in references. I want to Show Records for "Tea" Only but Not for Order Numbers with Both "Tea" and "Coffee". Can Someone Help.

Hi, I have a table as below: ID City1 City2 City3 City4 City5 City6 Michigan aa bb cc dd ee ff i have a combox cboState to select the State Michigan In combobox cbocity i need itemdata as aa;bb;cc;dd;ee;ff Iam sure there should be way other than an union query. Request anyone to Help.

The Issue is Solved, thanks for the help.

yes it runs but returns only the first record in the database

i dont exactly know what to write, can u write me the code.

I have the following Code: Dim filterStr As String filterStr = "" If Len(txtBuyerName) > 0 Then If filterStr = "" Then filterStr = filterStr & " ([BuyerName] Like '*" & txtBuyerName & "*')" Else filterStr = filterStr & " And ([BuyerName] Like '*" &...

Can u Help me with the Codes

No, They are more like excel sheet reports with Color and Grids as borders

Dear All, The Following is the Code iam using to send the File as attachment thru outlook, i require some reports to be sent thru body of the email in outlook. Can anyone help Dim sFile As String Dim sFolder As String Dim sSubject As String Dim sMessage As String sFolder =...

Yes it Worked Just Finished the Work Thanks Everyone

I Have written the Following Code: Private Sub Form_Activate() Dim x As Integer Dim m As Integer m = Month(Date) With Me.cmbShip01 Me.cmbShip01.Value = Null For x = m To 12 .AddItem MonthName(x) Next End With End Sub This Populates Month Names from the...