Recent content by sweeneytime

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...

haha "You are about to update 304 records"! At least I have that part of the code working. So obviously in this case the select record doesn't take affect. Is there sql code for that? Private Sub Command72_Click() Dim strStatusInActive As String Dim updateSQL As...

Thanks for that I will try your new solution, I had worked in your other suggestions, but got a syntax error on "DoCmd.RunSQL updateSQL Private Sub Command72_Click() Dim strStatusInActive As String Dim updateSQL As String strStatusInActive =...

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...

Sounds good, so I would then write a query, which returns the MAX date for each employee? Then one follow on question if I may, some employees have 2 "Active" salaries due to different cost centers. Would the query be, each employee by MAX date where cost centers are not equal?

Your not just a funny username! Thats great, I've quickly gone through it and got the jist of it, vba calls seem quite easy when. Thanks a million for that! I'll spend a bit of time understanding the whole lot.

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...

Haha that is my new phrase for describing that! Ditto on working smarter not harder.

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...