Search results

Case 1: Receiving of goods Case 2: Transferring of goods The warehouse officer is making entry as per the goods receipt note and goods delivery note. Now, the situation is as under; The main subform has fields: items, PackingSize, Quantity, expirydate Note: Items field is a combobox...

I have data entry form with main and subform i.e, subform is continuous form. I have made a button on main form i.e, add multiple items, when the user will click on it, it will pop up another continuous form with the following fields, 1. Check field 2. Items Name 3. Packing Size I want to add...

I want like this or some kind of other way https://docs.telerik.com/devtools/winforms/controls/gridview/columns/resizing-columns-programatically

Is it possible like this https://docs.telerik.com/devtools/winforms/controls/gridview/columns/resizing-columns-programatically

If someone has an idea, share code or sample database, thanks

Is it possible to adjust columns size in reports view?

I have revised the code as per the suggestions Public Sub Buildsql() Dim sqlqry As String Dim sqlInvoice As String Dim sqlTranType As String Dim sqlVendor As String Dim sqlEntity As String Dim sqlDate As String Dim strCondition As String Dim strWHERE As String...

Thanks a lot Maj for giving me your precious time.

Thanks Pat, Thanks Maj, The information and guidelines, you both have provided me much more useful and the code would be changed as per the suggestions, Thanks

Thanks Pat, 1. I will implement case statement, 2. About combo, the idea behind is that as the user selects an option from option group, the combo box will get data from the related table and will show in the combo box as per the selection and after that the user could select from the combo...

Multiple criteria in Search Form: My search form is working normal but now I want to implement multiple criteria. The code which I am using in each field is as under and the screenshot is also attached herewith. The detail of requirement is as under criteria 1 : Invoice Number criteria 2...

thanks Maj.

Thanks Pat, got your idea, It's mean that we have to assign exact match condition criteria, Or suggest the alternative way please.

Thanks Vlad

Search Form Date Criteria: how to give date criteria, I have added the following code Private Sub btnSearch_Click() Dim strDate As String strDate = "SELECT DocumentNumber, TranDate, TranType, EntityName FROM tblEntities RIGHT JOIN (tblTranTypes INNER JOIN tblTransactions ON...

thanks Maj

Is it possible if I try into case statements?

Kindly suggest alternate solution

the combo box values are coming through option group selection Private Sub SearchFrame_AfterUpdate() If Me.SearchFrame.Value = 1 Then cboSearch.RowSource = "SELECT TranType from tblTranTypes;" ElseIf Me.SearchFrame.Value = 2 Then cboSearch.RowSource = "SELECT CompanyName from...

I have added the following in my search form 1. added text box named @ txtSearch 2. added find button named @ btnSearch 3. added combobox named @ cboSearch 4. added list box named @ Searchlistbox1 Private Sub btnSearch_Click() Dim sql As String Dim str As String Dim str1 As...