Search results

Hi all, I have a form which allows me to select as many records as I want. However, i got an issue here. For example; I selected 4 records, but i will only want to key in the value on the textbox in the 1st record out of the four record, that i have made marking on the image i have attached...

Thank you so much!

Hi all, I have 5 textbox that link to a search button on my form, and the code works fine when i fill up all 5 textbox with PO number and click search it will show data that belong to the 5 PO number that i keyed in. However, i do face issue when i did not fill up all the 5 textbox. For...

Okay, it works! Thank you

I have managed to sum the number up, however i am only able to sum up the textbox that display number and once i use expression builder to sum up textbox that display number and textbox that does not display number, it will return a blank textbox. How can i sum up the textbox without number as well?

Hi all, I would like to sum up multiple fields in a textbox in my report. I tried summing up by using expression builder, however the result display on my report seems to concatenate the number together instead of summing it.

"Solid" Report will display data that are listed under "Colour" fields. "Printing" Report will display data that are listed under "Ground Colour" and "Combo Name" However, these two report have the same report design layout.

I encounter error "Too many close parenthesis"

I am asking if it is possible to constantly show 1) Please State: 2) Shrinkage: Maximum W: L : Twist: 3) PP sample - in the textbox on access form?

i tried using label with that as a caption but it does not allow any editing to be done to it, as i will need to edit some of the text

Hello everyone, How can i show this on the textbox on my form? so that user will not need to keep typing or copy to the textbox and make the adjustment? 1) Please State: 2) Shrinkage: Maximum W: L : Twist: 3) PP sample -

My specification is to combine a solid report and printing report as one. Solid report contain data that only include colour Printing report contain data that only include ground colour and combo name. One report might consist solid and printing data

Hello everyone, I would like to ask how can i combine two report as on report?

Hi all, I have a search button on my form and when I click on search it is unable to show only the data that I search. Below is my coding: Private Sub txtSearch_Click() 'declare variable Dim sql As String 'Determine and return the number of records in UnmatchFabricPOqry If...

Hi all, I am facing issue with this error "91" object variable or with block variable not set at this line of code. Can you help me? I have declare and set the variable at the start of my coding. ' loop on each item in maximrecords collection For i = 1 To modifyRecords.Count This line of...

Me.txtLoss = (CInt(Arr(7)) - CInt(Arr(6))) / CInt(Arr(6)) * 100 'me.txtlLoss contain 5 CInt(Arr(7)) contain "Gwe0 CInt(Arr(6))) contian "Net0"

I still encounter the same error even if the CInt() has value

Hi all, I encounter this error "TYPE MISMATCH" when i click on my "save" button on my form. Private Sub Write2DB(ByRef Arr As Variant) 'arr(0) PO# 'arr(1) GL# 'arr(2) Fabric Del Date 'arr(3) Fabrication 'arr(4) Fabric Width 'arr(5) Fabric Color 'arr(6) Net Weight 'arr(7) Gross Weight 'arr(8)...

Hi, it did join all my fields together but it show duplicate column. How can i get rid of it?

Hi all, may i know how to perform join on two table? I tried using join but it is not the result that i want. Below is my SQL Code: SELECT * FROM Table1 INNER JOIN Table2 ON Table1.PO = Table2.PO; I want the table to show all the fields in both table 1 and table 2