Search results

Hello everyone, I am facing this error when i use a command button on my form to import the excel file into my access database. How can i solve this?? I realize that i can import the file to my access perfectly fine with file Book113 and i cannot import the file with file Book112. This two file...

Hi all, I would like to ask how to let my access system know that year 2017 has end, and it is 2018 so that the year will automatically change from 2017 to 2018. For example Today is 31dec2017 and the PO Number show 17/1000. Then for tmr the PO number should display 18/000 on my system. Is...

does that mean i will need to change the data type?

As this is one of the requirement given by the user. Hence, i have to try to get it done. Well, you said this can be done in either code or query, with that can the user still key in the the value they want in the textbox on the form?

The problem now is that i am not able to key in "+" sign in my textbox

Nope, txtGrossweight is not bound as i will need to use button to display the value

Hi all, I tried the method you guys said, but i am still getting error. Below is my code: If Me.txtLbs <= 130 Then Me.txtGrossweight = (Me.txtNettweight + 20) + Eval(Me.txtBuyerRequirement) I have also attached a image of my form and the error

Yes, i do have a button to click and calculate textbox B

Okay, I will try! Thank you. Does this means that i should remove my dcount statement?

I want it to be like user can either search the PO by mxdPo or mr name

I think is the second dcount which is the MR Name. When i search the MR name in the textbox of my form, it shows the error message " No record found, Please check your mxdPO again"

Hi all, I would like to ask if it is possible to calculate this type of value : 20+ 2+ 2 in textbox? Like for now, I have two textbox . Textbox A has value : 20 + 2 +2 Then textbox box b has value of 20 , then i want to add textbox A value to textbox b. This means that textbox b = 44, [20...

Hi all, how can i include two dcount criteria in my search button on my form? Currently i am able to search the PO number, buy i would like to be able to search by the MR Name as well. How can i do that? Below is my VBA code: Private Sub txtSearch_Click() Dim sql As String If...

what I mean is that when I key in the PO number in the textbox and click search on my form, my subform will return the result. There will be multiple records under one PO, hence I will select one of the records and click on " edit" so that it will populate the record in the textbox fields...

Hi all, I am using an unbound form to select the data in my subform and save it in my table, I have a textbox and search button on my form, so i will have to key in the PO number then click on search so that the subform will display all the record set that is under that PO number. Next the...

I see~ so it is impossible to perform grouping if there is a column that make them different. But what if the column is related to the field and cannot be remove? Like for the image below; The GLA fields is tied to the colour thus cannot be remove. Does this means that i cannot perform group by...

Hi all, I would like to ask if it is possible to perform group by and sum based on the image i have attach below? As you can see from the image, I have boxed up the PO,Colour to show you all that in the same PO, there will be duplicate colour. However, the colour has difference pounds and...

The purpose of me doing this query is to build an unmatched query based on multiple fields. After researching, i found out that i can actually use the unmatched wizard in Access to help me do that. If i want to have other join criteria i can simply type in my own criteria in the unmatched query SQL.

Hi all, I have issue when i try to click on the "edit" button on my unbound form the second time to retrieve the data on my subform to the textbox on my form. Private Sub cmdEdit_Click() 'check whether there is exists data in list If Not (Me.UnmatchFabricPOqrySubform.Form.Recordset.EOF And...

Thank you! I have solved it!