Recent content by DDJKSA

Thanks Pat, really appreciate it. Once I've finished up with my current project I'll have a play with it and will no doubt come back with a ton of questions to bug you with :) I'll obviously have to get much more confident with the design and use of sub-forms. Thanks again DDJ

Thanks @Gasman..that looks like a nice neat solution and I'll try that. Appreciate your help and input. Regards DDJ

Thanks @cheekybuddha Everytime I try and reply to your post I get the following message....hence this reply route! Only the last digit in the variable Text6 is used to determine the month number, hence the extraction but I do get your point about the whle string needing to be a date format...

Thanks @Minty Yes, I totally see why it doesn't work with your simple explanation - just me being daft and thinking it through as usual! Appreciate your help. Cheers DDJ

Hi Pat I appreciate your feedback but as the OP it is surely my decision whether or not my problem (and, yes, perhaps not initially phrased correctly) has been solved and yes, it has, so again, thanks to @arnelgp for his/her help. That said, I understand it didn't answer the original question...

Thanks @MajP I got my Dlookup working but wanted to try your solution as it's much neater. Text41 = Format(Right([Text6], 1), "mmmm") Unfortunately it still returns January for each number (the numbers calculate correctly in a debug windows) Weird? DDJ

Cheers Gasman I did have the criteria in a string variable in the code to debug but it's all sorted now - just my misunderstanding. Thanks for your help. DDJ

Hi Pat Not sure why you're so angry, is it because you posted the wrong file, I only looked at it briefly deciding it was too difficult to see how it pertained to my situation, I adopted a different solution or you feel you answered my original post to the letter and others didn't? Do you...

Thanks Minty I mistakenly thought the criteria had to be within quotes too. Sorted (y):) DDJ

Hi Guys Been around around in circles with this one, and probably (hopefully) a trivial one to solve. I have a form which generates a single number (Text41 below) from 1 to 12 (depending on Text6 on the form). The numbers generated are all correct (see 'Immediate' window below). I'm then...

Hi Pat I DID look at the sample you posted but couldn't see how it applied to my post and, being a raw noob, assumed it would involve too much work to interpret and adapt, especially when @arnelgp solution works so well. Your very first comment was perhaps intended by you as helpful but was...

Thanks Pat. I did have a quick look at your original DL but couldn't really figure it out so makes sense it was the wrong file. I would appreciate the correct one if could could UL it. Even if I don't use it now it'll be handy for future projects. Cheers DDJ

Thanks again everyone, all great suggestions. Really appreciate all the time you guys are giving me. DDJ

Thanks Pat I understand your point and will try to be much more direct, much clearer in future when framing my problem. That said, I found the tone of your answers quite abrupt to the point of being rude. Perhaps with new members you could try and be a little more empathetic, less...

Hi Pat I wasn't really trying to hide the real world situation - just trying (unsuccessfully!) to simplify the example. ArnelGP's solution is very elegant, very flexible, very adaptable and so easy to understand. He (apologies, or she) helped me out before with a similarly elegant timetable...