Search results

how to update?

The problem i am having now is that i do not have a primary key. Do you have any idea how can i do that without primary key?

Hi all, how can i prevent two users on editing the same recordset on the subform that i have placed in my form? I tried setting the record lock tO "EDITED RECORDS" under the property sheet in the form. But it still does not work on my side. Can somebody help? Thanks

Hello everyone, how to have VBA code to read the data in access table row by row and compare it to another table? After reading and comparing the rows among the two table , it will identify data that have been modify and delete the whole rows of data that have modify and add in the new modified...

nope is unbound

Yes! How do i do that?

In my case, I want the system to prompt user the change, so that if the user have create a PO based on that color will know that she have to make coinages to that PO.

Hello guys, is it possible to have some thing like a message box to notify user that the color for data have been change to red instead of blue? Like for example when data 1 was added into access yesterday, the color is blue. Then for today the color change to red. Thank you! Have a great day...

I think there is some error here. The PO that was being use should be 103 instead of 104 right? How do i do that?

Thank you! How can I automatically display concatenated PO in my textbox after clicking on SAVE PO? As of now, I have to click on the textbox to display the concatenated PO by using the following VBA Code: Dim CompanyCode As String CompanyCode = Me.txtCode Dim YearCode As String YearCode =...

the code works for finding out unmatching records, but it does not work when i save a record in the main table, the record is still in the subform

I mean this! [I hope you mean you added that to the code for your Save button] yes, i am using an unbound form

'Refresh data in list on form to show only data that are not save Unmatchedsubform.Form.Requery I put this requery statement under my "Save" button

SELECT FabricPO.[Style NO], FabricPO.[GL Lot], FabricPO.Date, FabricPO.Description2, FabricPO.[Fabric Cuttable Width], FabricPO.GSMBeforeWash, FabricPO.[GMS Per SqYD], FabricPO.Color, FabricPO.[Our Qty], FabricPO.[Supplier Qty] FROM FabricPO LEFT JOIN MainTable ON FabricPO.[GL Lot] =...

Yes, because 1 GLA number can consist of repeated for different fabrications/colours?

Oh, sorry. I think this images are better. In import, GL lot is the same as GLA in the main table

Hello all, is there other ways that i can compare data between two tables so that my subform will be able to show only data that are not added into the main table? I think i am not able to use the unmatched query in access as i do not have a primary key in both of my data. Below is my data...

I have attached the image of my running no table. I did so by applying this code: Private Sub cmdSavePo_Click() 'Insert PO number into MXDPORunningNo table If Me.txtCode.Tag & "" = "" Then CurrentDb.Execute "INSERT INTO MXDPORunningNo(CompanyCode,YearCode,PONumber,MRName)" & _...

PO number is numeric. MY PO number looks like this ABC17/100 but is separated into three text box

I got type mismatch error for this line of code Private Sub cmdSavePo_Click() ' Insert PO number into MXDPORunningNo table Dim thisPO As Long If Me.txtCode.Tag & "" = "" Then thisPO = Val(Me.txtRunNo) ' check again if somebody has just added ' this PO before us While Val("0" &...