Search results

Guys, thank you for helping me out in this. :fun:, I feel the sense of learning again :-D @Bob Larson: actually it is for reporting purposes, indeed. Monthly. For now I do not get the VB module to work, though. I get a syntax error, when I run it from a macro. What do I do wrong? Code I...

Hi BoB Larson, Ok, I follow. And I have to start somewhere, don't I? How do I set up a proper design? And is VBA needed for 'proper design'? Because then people like you will have to help me getting kickstarted, because I do not like theoretics. AT all... Thanks for a reply, Timoo

Hi Boblarson, Thank you for your reply. To be honest, it is not for reporting. It is part of a series of queries, applied to data. As soon as I've got a chance, I will apply this. See what happens.. How is your Halloween? & Thanx! Timoo

Hi I'm totally new to VBA. And I think I will be needing it a lot, the next upcoming half a year. I know that I'm the kind of person only learning from experience. Therefore I turn myself to you, experts. So, first problem I walked into and I would like to solve through VBA: A query I...

@The Doc Man: This sounds really easy indeed. For a programmer. Which I am not. And I am walking into the exact same problem. Who can give me an answer on how to start this up?

Hi, Could you help me out in this? I'm doing calculations; for every month I create a column (1 to 12) and this column is being populated with numbers, customer by customer. This is being done for YearFirst and YearLast. Next, I calculate the difference for every month and so I end up with 12...

*kick* Nobody any idea?

There is no limit to records indeed, only in size, as far as I understood. My experience: by 1.5Gb it starts to become very unstable to work with. Initially the number of records was limited to 8^8, I believe (16 mln records). By now this is 12^12, as far as I understood (8,196 bln records)...

HowTo Create a Sequential Query, in Loop? Hi, I've got a problem. I'm doing an update query on a table. 1 for every month. (...) Now I would like to use a counter, so I do not have to run 12 queries in a macro, but 1 query with dynamic field names. But I do not get the thing to work. Current...

Hi, New to the forum. Who am I? Timoo. I work for Doosan Infracore. Here I mainly do data analysis and some Access dbase building Where am I? Waterloo, Belgium Why am I? Because every day hanging out with the angels became boring after thousands of years in heaven