Recent content by deletedT

@theDBguy I'm sorry for not being able to test your solution. I have to leave AWF. I think I will post the same question on utterAccess and I hope to find you there to continue on this. Million thanks.

Listen my friend. I think you can't be a successful businessman here. No matter if you are the owner of a 5 stars restaurant, or you own the most popular fashion chain shops, or you own the most successful forum, the moment you say something like this, it means that you have forgotten that these...

@theDBguy thanks. I'm away from my PC. I'll check it as soon as I'm back to my desk and let you know the results. Thanks again for sharing your power.:D (In Japanese we have a saying knowledge is power)

All non-technical sections. Watercooler and politic for sure.

It would be the best gift you may give me.

@theDBguy While filtering works fine and I receive what I expect to, it seems that filtering a crosstab query with more than a million records is a little slow. I will wait to see if anyone can help to rebuild the sql (instead of filtering it) to see if there's any improvement in performance...

Yes it works. I wonder why. I had used this but received a parameter error. I mark this thread as solved because according to my sample file uploaded above your code works perfectly. I will replicate it in my main database. If I face any problem I will open this thread and will ask again. Just...

Just let me know where I can find you.

I actually thought about it. The actual form has a lot of options to filter or change the record source. But since the source is a cross tab query, in some cases the filter throws up some errors. Maybe I'm doing something wrong. Tried this, but access asks me for ProcessFK parameter. Me.Filter...

This is the structure of three tables: This is a form based on a cross tab query. Users open this form. Type a drawing number and click the filter button. A function creates a sql and use it as the record source of the table. The results are shown. If I type AL18888BC601, and select ALL in...

You're exaggerating. Nobody says use a 40 years old OS. If you read about the updates, you see most of them come out as a solution to a bug in a prior update. I can give you a thousand example. But updating as soon as a version is out, is not what I choose. As I said, new version=new bug. And...

@Jon, I know about your concern and how you're thinking about the convenience of the members. But that shouldn't get in your way to focus on what this forum is meant to be. How many members are posting in Politic? 5 or 6? and all of them are vips. I suggest you take Politic to vip section. It's...

Why in an Access forum, Politic should be in top? If it was me I would take Watercoolder down.

@The_Doc_Man I’m not sure about the answer to your questions. Maybe sports broadcasts or TV programs have their own laws. We have special CMs in TV for social educations and instructions.These CMs are broadcasted daily to teach us how to behave in public, how to be better, or what is the new...