Search results

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

I'm not familiar with Access that's first. I use the excel form for data entry that stored data in access database, then pull back the records back to the form list box. So far the user form is working well. However, entering the data one by one takes a lot of time for the end user. I want to...

I can't because there are multiple end user of the excel file, I have userform for data entry where user can enter new data/delete data/edit data. the access database is in the shared network, I'm trying to add a command button for bulk import and update instead of using the form for entering...

I have Update sheet, this sheet contains unique ID that matched the access database ID, I'm trying to update the fields using excel values in "Update" sheet. The ID is in the Column A the rest of the fields are stored from Column B to R. I'm trying to achieve the below, As follows: 1. Update...

Hi @moke123 this is exactly what I need, but no idea how to write that code. I hope someone could help me out. I need to get all the data which matched the selected ID's in the listbox then loop if the selected row is more than 1. How I will do that, let's hope someone could help. I think this...

Can you help me with my question in the Forum? Appreciate any help. https://www.access-programmers.co.uk/forums/threads/vba-code-to-copy-to-new-access-table-before-deletion-in-access-database-using-excel-listbox.310813/