Recent content by karatekid

Hi guys! I've looked everywhere in the last few days, but I couldn't find much that I could use :banghead:. I'm fairly new to Access VBA, and I don't know if this is even possible... I'm trying to put together a DB for creating notifications to customers. The source file is pulled out from...

Hi guys, Radu from Romania here! I'm new to Access (I've worked a lot with Excel until now) and I'm hoping to learn as much as I can from all of you, and maybe help in my turn when I'm experienced enough to do so. Have a great one! :p karatekid

Thanks a lot for all your answers, guys, you've really helped me save my behind today :) My little project has gone for testing to my colleagues that need it. Galaxiom, smig, I will try to implement your suggestions. Right now, I'm just basking in the glory of getting it done in time :D...

Hey guys, I've tested Chris' code and it works!:D Hats off to you, you're great! Now, I've only got to tweak a form to export the data and I'll be home free :) Big thanks to you, ladies and gentlemen! Have a great evening, and a successful week! karatekid

Wow, thank you so much, Chris. You're a lifesaver. I will try it as soon as I get to my computer, and get back to you. Cheers, karatekid

I haven't thought of the temporary table solution, Chris. Thank you for your suggestion :) But how to delete the records in the table before running the temporary query again? Can I do that via macro (I already have some macros set up which are updating the source reports)? Unfortunately...

Another idea, guys: suppose I would put the criteria in the table that contains the targets, is there a way that I could query against the table to find out the category codes (i.e., have separate columns for TargetGroup, GroupByType, Action, AdminAns and Complaint Type EN directly in the table...

Hi Chris, Thanks for your answer. I am not trying to update the union query, I am trying to create another query based on that union query, and then add a Category Code field that would show me the category in which my record falls. The union query will always have at least one record, as the...

Hey Galaxiom, Thanks for your answer. I've changed the name of the variable to myQuery, and I've used the While...Wend construct you've suggested, but I get the same situation. Could you elaborate a bit on that? Would I have to set up an ID system for the source tables, and then go from...

Hi guys, I'm new on this forum and with Access VBA, and I've been struggling with a VBA function for almost 2 days now. What I have is a query based on an union query, and I would like to categorize the records in the union query according to 24 criteria. What I have come up with is a VBA...