Search results

HI i am getting below error after i have substituted the details. Pls help what i am doing wrong. Run-time error 3075; Syntax error (missing operator) in query expression "ABC_cbAC"

Thank you Minty, will try this code

Thanks Minty, let me try creating the table Meanwhile, how would the Dlookup code look like,

Thanks Minty, i will give it a try, but my actual BankId has around 100+ bank names. If i have to replicate with two ORG, it will be exactly double the rows and in future there may be additional ORG in future, then i need to replicate another 100+ records. Is there a different way or can there...

Thanks Uncle Gizmo, i feel too this will be more convenient. But i am not sure how do i put i create this table To brief on the process. User will 1st select the ORG, it may be ABC or PQR, then he selects the required BankId, if the ORG and BankId is same (ABC) then case "001" applies and if it...

Hi! Minty, i have applied the same code. it works fine, however, i want to add one more criteria based on the ORG. So if the ORG is PQR, the account nos should be different. Private Sub BankId_AfterUpdate() Me!BankName = Me.BankId.Column(2) '---------------------------------------------- '...

thanks Uncle Gizmo for the response. ORG has just two Bank at the moment, but may increase in future Thanks Minty for your response too, i will try the select code example and update you thanks once again

HI All I have 4 combo box as shown in image Org : BankId : CBKACName : CBKACName_cbk : Based on 1st and 2nd combo box inputs the 3rd and 4th combo box gets updated. i have put the below Afterupdate code Private Sub BankId_AfterUpdate() Me!BankName = Me.BankId.Column(2)...

Thank bastanu, absolutely amazing, This is what i wanted. Thank you once again Want to thank all those who reviewed this post and helped me to understand this thread. I will close this thread as Solved. God bless

Yes, bastanu, i do have field name MICR in both tables. i have got this working with the below code. Private Sub MICR_BeforeUpdate(Cancel As Integer) Dim strMICR As String strMICR = Me.MICR If DCount("*", "tbl_Incident", "[MICR]='" & strMICR & "'") > 0 Then 'Undo duplicate entry...

Thanks bastanu, i replaced your code, however i am getting complie error on the seconf dCount. thanks for the reply The Doc Man in post #4. Yes MICR name is same in both tables. I want to avoid duplicate from table tbl_Incident for table tbl_Master. It means if the record is already in...

HI! all I am trying to avoid duplicate data entry in two tables. I have tables called tbl_Incident and tbl_Master Below is the before update code on field MICR in tbl_Incident Private Sub MICR_BeforeUpdate(Cancel As Integer) Dim strMICR As String strMICR = Me.MICR If...

Sir, one more request, if click Private Sub Command95_Click() instead of msgbox can it copy the current record on the form (IIncidentd)

Thanks arnelgp, IncidentId is long but i am still getting previous similar msgbox. and sorry as mentioned in my post#7 i need to include the line but i corrected the parameter. You provided the code correctly.

Thanks arnelgp, i am getting an error on below line, so i excluded and it works fine. "qdef.Parameters("Entry Id").Value = IncidentId" just wondering, if there is way to change the msg box

Thank you all for the response and applogies for the delay due to the time difference. Below is my SQL Statement. The query is saved by query_Voucher and there is parameter called Entry Id also. SELECT tbl_Voucher.IncidentId, tbl_Voucher.ORG, tbl_Voucher.VoucherDate, tbl_Voucher.DR2...

HI! all, I have form with button on click event with below code Private Sub Command95_Click() On Err GoTo Park Dim rec As Recordset Dim qdef As DAO.QueryDef Dim IncidentId As Integer Set qdef = CurrentDb.QueryDefs("qry_Voucher") qdef.Parameters("Entry Id").Value...

Thanks Pat Hartman, i have made it clear it don't have any idea in coding. From last 2-3 post i have been trying to say the same thing and you are trying to say the same thing again. Anyway thanks for your time. I will check here if anyone else can give me the clue to give me a start of what...

Thanks Pat Hartman, i have no clue on coding. Well i got the required support from this forum so came this far. If you can give me the start code, probably that could help me to move forward.

Thanks dear Pat Hartman for your response, yes i did mention another query of copying the data on another form. Coming to the earlier question on my db. How can i do it differently, if you can give me a clue i can work towards it. It will better to delay the project than to take the wrong...