Search results

Hi Guys, I have a piece of code for a text filter on my form. I am now getting an error "2185, You can't reference a property or method for a control unless the control has focus." The strange thing is that it worked yesterday but not today! In googling people say to remove the .text in my...

Hi guys, On my form I have a button which I want to do the following: Status field: Change to "Inactive" Copy record Paste record Goto last record Status field: Change to "Active" I have the copy part done, it then moves to the last record which is the new one. But the code I have to insert...

Hi Guys, First time post, new to access, I do VBA for excel. I am looking for some help please, the logic seems easy, but I may even have the wrong approach with my excel eyes on it. My access VBA books are in the post :) I have a table of employees, I want to keep historic data along with...

Hi people, I am an accountant moving to process improvement. I have been doing VBA with excel for about 3 years now. In my latest process improvement task I am building a small access database. So I am no wanting to learn VBA for access. Hopefully you guys will be a fountain of knowledge...