Recent content by Devon

Thanks for your quick replies. I decided to rebuild the query and bind the list form to that query. That worked. Strange thing is that even if I use the SQL string that I mentioned in my first post, the refresh works as well. So either Access is behaving inconsistently, or I might have...

My problem takes quite long to explain properly, so let me start with a general explanation. If more information is needed to help clarify where things go wrong, I'm happy to oblige. There are three tables that play a part in the issue: tblAssignment - Holds assignments for all the employees...

With Access 2007 I am using images with .picturetype 1 to make things look a little fancier. I also change the visibility of squares, images and labels when a user clicks an element, as some sort of status indicator. Unfortunately, the code runs without actually making the elements visible so...

Sounds simple enough, thanks!

On a form that displays, let's say, "customer" details a combobox is used to let the user choose gender. Once a gender is chosen, an image shows either a male icon or a female icon. The form has a table as a record source. If a user changes the gender but doesn't leave the combobox but presses...

It took some time to get things right due to problems with indexes, but I found a way around that. The code could be cleaner here and there, but I'm glad I finally got things to work and have the desired outcome. Public Function Appraisal(ApprSource As String, ApprDate As String) As Boolean On...

Thank you for your input, that did the trick. All that's left now is converting "BU" to .Fields(XX).Name so I can start using a matrix and loop through all the fields that need to be deleted. Will post the final result later on.

I'm importing an Excel workbook into a table. Some records are removed, which works fine. But I stumble upon error number 3273 when I try to delete a field. Giving the name of the field leads to the same error as letting Access grab the name via .Fields(XX).Name. What am I overlooking? Public...

Hailing from the Netherlands, I would like to take the opportunity to thank everyone who helped me unknowingly! After having studied programming over a decade ago, mostly with VB(A), I ended up in human resource information management. Even though I sometimes still need to code here and there...