Recent content by meilkew

You should have one.. I will definitely enroll myself, if you can share any reading materials for me to begin with, much appreciated. Also, I did add the code below in the reason form to avoid user from closing the form using the X button. As it continue to delete the records if X button is...

Holy Macro.... :eek: :eek: :eek: Thank you sooooo much Sir. I will try to learn Access in the future... Kudos.. Keep Safe Sir and God bless you. :love::love::love: Do you have a website or video tutorial Sir? would like to enroll if you have one?

I have this code which open the PDF files if the filepath is available in the listbox index and msg box if "NO PDF FILE" text is found instead. I would like to clear the selection made as soon as the PDF or MsgBox fires. But somehow declaring this at the end of the code doesn't do the work...

Update: Closed, Thanks to all of your help guys. I got someone from other forum, helped me fixed the code. I'm posting it here the finished code. In hope that someone might benefit. Sub Update_DB() Dim cnx As New ADODB.Connection Dim rst As New ADODB.Recordset Dim qry As String, id...

:cry::cry::cry: Hi @CJ_London , I'm getting nowhere looping the primary key ID? Any advice what I'm missing here? Option Explicit Sub Update_DB_1() Dim cnx As New ADODB.Connection Dim rst As New ADODB.Recordset Dim qry As String Dim id Dim sFilePath As String Dim...

E1 Yes, this is what I'm trying to do now, going through line by line of the code. Yes you are correct I'm trying to adapt it to suits my needs. Maybe the code sequence is not correct. I just modify the Export Sub, which is working fine and doing exactly what is supposed to do. But for the...

I know, I have asked to much, but if you can help me out how I can loop this to read the next ID? Thank you so much!

Hi @CJ_London , this code is not looping to the entire row but only to the last row. ID = Range("A" & lastRow).Value qry = "SELECT * FROM f_SD WHERE ID = '" & ID & "'"

Imagine that, this is the code that driving me crazy.. :eek::eek::eek::eek: It works perfect. Thanks @CJ_London.

Hi @moke123, hehehe.. I wish you could help me out cleanup the mess. hehehe

Sorry @CJ_London I'm not a programmer, I want to remember what are those code of lines are for.

I wish I could do the same, I don't know much about access and I am not a programmer either. I found codes then modify it to best I could.

If I don't find any solution to move the records to a new table, I will try this approach. I use these string as it more convenient to have the exact reference number and revision to be my primary key.

I actually thought about this, but I read something that it is much better to move it to new table instead of excluding it with filter as it needs to run every time causing for time to return the value back to excel. I have nearly 100K records in the database.

I posted this question, this is different, I'm still working on this to find ways to save a copy of deleted records in a new table before completely deleting the records in the original table. So far, I no luck. hehehe