Recent content by skdn71

"Why do I need to press the reset button after I press page 2, 3, 4 to see the data? Can't I see the data directly when I press page 2? Please take a look."

Hi, I hope this message finds you well. I am currently working on a project that involves Data CRUD (Create, Read, Update, Delete) operations in Excel. I am reaching out to see if you have any experience or expertise in this area. Your insights and knowledge would be incredibly valuable to me...

I hope you can help me. Thank you for your time

Explain: the 3 button not working after the search found ( see ficture)

Hello, Could you please help with click event on datalist: If I don't do a data search, the button works fine, but if I do a data search the button doesn't work. Please help me Thank you very much for your time

see photo

SendKeys "{BACKSPACE}" on txtSearch When Listproduct form open frm frmNav

Please help me if I run the VBA below with form_load on the Listproduct form it works fine but if I run it from frmNav on Load_form Listproduct form it doesn't work Private Sub Form_Load() ' Select the text in the textbox Me.txtSearch.SetFocus Me.txtSearch.SelStart = 0...

I try to use the below VBA but not working : Private Sub txtCity_KeyDown(KeyCode As Integer, Shift As Integer) Me.frmlistprod.Form.Filter = "[ItemCode]Like '*" & Me.txtCity.Text & "*' or" _ & "[ItemDescription]Like '*" & txtCity.Text & "*' or" _ & "[PPU]Like '*" & txtCity.Text &...

Like this ?

Please help how

what I want : 1. If I type in searcht1 the word AXE in [ItemDescription] all data containing AXE will appear and in search2 if I type 24 in [PPU] all data containing 24 will appear after completion all data will appear in [ItemDescription] all data with AXE and [PPU] 24 2. If I type in...

Hello With the VBA below I can only search for data in Search1 [ItemDescription] and Search2 [PPU]. What I want is that I can search for data in Search1 [ItemCode] , [ItemDescription] , [PPU], [City] in search2 also what I want is to be able to search for data [ItemCode] , [ItemDescription] ...

Hello Could you please help how to make Navgationform moveable I Try below VBA : is not working Thank Option Compare Database Option Explicit #If Win64 Then Private Declare PtrSafe Function ReleaseCapture Lib "user32" () As Long #Else Private Declare Function ReleaseCapture Lib "user32" () As...

Dear arnelgp, Thank you is working ! Well Done