Search results

Hi All. I have a checkbox at the bottom of the form. What I want is when the checkbox is clicked, all of the received textboxes to equal the units ordered textboxes. I have tried a few different methods but none seem to be working. You are able to enter data into the textboxes. However I...

I understand that but we are constantly adding new products. We currently have 800 products and it will be ever increasing. How are we meant to keep them in order.

Nothing appears in the combobox if I change it to Val(Detail)

SELECT DISTINCT TblDetail.Detail, TblDetail.DetailID FROM TblDetail; There is no sort on them as it is in the Code. Me.Cbodetail.RowSource = "SELECT DISTINCT Detail, DetailID " & _ "FROM TblDetail " & _ "WHERE ProductID = '" & Me.Cboproduct.Column(1) & "' " & _ "ORDER BY...

I tried that but I still have text values in the field. We have a mixture of the two. I just need it to sort the numerical values by value and ignore the text values.

I have tried the suggestions but nothing is working. I have separated the UOM but it still wont sort numerically. I have tried doing the sort order but hasnt worked either. I have added a space between number and UOM as well. Any other suggestions?

They are all sorted in the row source which is why I am confused. All the other combo boxes are sorted but any with numbers arent sorting like they should.

Hi. I have a combobox with different sizes of products like metal sheets and bars with sizes like 1mm up to 1500mm. The combobox is organising them like the photo below. The comboboxes are cascading and work fine but wont organise into numerical value. Is there a way that you can organise it...

I have tried that. The master is quotenumber and the child is fkquotenumber. This also does nothing.

Hi Arnel. This is my code to filter the subform. Dim searchfor As String Dim searchdate As String Dim startDate As String Dim endDate As String If IsNull(SDTxt) = False Then startDate = Me.SDTxt.Value endDate = Me.EDTxt.Value...

Thanks arnelgp. Does this go on the click event or another event.

The code in post 3 works. It filters the subform to show the correct information based on the dates. What i need to do is turn that filter off and show all the records that are associated with the quotenumber.

This code works fine. It filters the subform. What I am trying to do is turn this filter off.

This is my code for the search button. Private Sub SearchBtn_Click() Dim searchfor As String Dim searchdate As String Dim startDate As String Dim endDate As String If IsNull(SDTxt) = False Then startDate = Me.SDTxt.Value endDate =...

It is a Master and Child link on the Quotenumber. When you open the form it is all ready filtered from the previous form. Then I filter it based on the dates in the text boxes and use the search button to search. This filters the subform. I want to turn this filter off.

Hi. I have a subform that is filtered on load. It shows purchase orders related to a certain quote. I have two text boxes to filter the subform based on a date range. How do I filter the subform back to the original filter? I have tried me.subform.filter = "" me.suform.form.filteron = false...

It is happening with old and new records. The units received is only one text box. I don't have a goods in form it is just on one form. I have tried it with an unbound text box and a bound text box and I still get the same error message. The error message is the message box.

It is the message box.

There is no validation on any of the text boxes.

Units ordered is 10 and i tried to enter 9 and got the error message. In the code editor these are the values. Rcvd:9 Order:10 Rcvd:9 Order:10 Rcvd:9 Order:10