Recent content by diberlee

I've tested that and it's working just fine, I thought you could only use DLookup on tables, good to know for future reference. I'll never know why the other approaches didn't work consistently but I'll worry about that another day. Really baffling how I can get 2 different outcomes without...

I've managed to get around this, in a less than ideal way but it's working... Rather than creating a recordset from the saved query I've put the actual SQL for the query into the code as the source for the recordset. I've yet to come across a 3307 error with this method, so it would appear that...

No joy with removing the subform. I also tried making it an unbound form to eliminate any weirdness re partial records but I'm still seeing this fail roughly 10% of the time. I haven't seen it fail as a recordsource on a form recently, it's just this function now. I don't know if it helps...

I should add to this, the same form where I'm seeing this behaviour also contains a subform where the same union query is the recordsource. This never fails to display the records, even when the code in the form that references it simultaneously states that there is an issue with it. Could the...

I'll see if converting values to a specific datatype helps. I'll prepare an "un-unioned" version of the 2 query parts too and see if I can catch a discrepancy. One of the places I get the error is on a form where the user enters a Customer ID. The union query is loaded into a recordset with...

Hi isladogs, There should be no time that this could happen. It's joining data from 2 sources that only get added to. It will generate the error one second, and then be fine the next without any data being changed.

Hi all, I've used a Union query in Access for the first time recently and I'm encountering some strange behaviour. The query is set up correctly, same number of columns, same data types etc and runs fine when I click it in the navigation panel. However, this query is the record source for a...

That's what I went with, but I've been caught out by that before. Is this just another of those little irritating things that are so common in Access? :)

Hi, Hoping this is a simple one, my Google-Fu is letting me down today. I'm trying to debug an issue with a form that's misbehaving. One of my VBA functions isn't working quite right, so I'm adding breakpoints to figure out what's going wrong. The problem I'm having is that each time I enter...

Not quite what I was looking for, but this looks like it will be just as useful as the imaginary function i wanted to use :) I'll give it a go when I'm in work tomorrow, thanks very much

Thought that would be the best way to go, was just hoping there'd be some sort of row/column object that might streamline some parts of the code. Thanks for your replies.

Hi, No, it's just a single form that displays a load of details relating to a single employee. Cheers

Hi, I'm designing a form which will display a lot of employee information in a tabular layout. Users need the option to update a lot of these controls, but I want them to do that on a separate form. I'm wondering if VBA can determine the position of a clicked button within the tabular layout...

Can't argue with that. I'm a sucker for an imaginary problem! Thanks for your help on this

Now that you've said that I'm kicking myself... I'll look at switching things round to all be in the same table. I originally set it up with the 3 tables thinking that it would ease the load on the database as the work involved in following up each category is split between a team. I thought...