Search results

I have been reading about the performance between subqueries and domain functions when applied in a query although both are slow, I've always found that in the discussion it is the subquery that has an extra edge in terms of performance aspect. However, recently I've created a running sum on a...

This would be awesome feature; and I think it's long overdue, I've seen 2 or 3 access forums with indicators already. Now c'mon, the best access forum is still old school!:p

@sparks80 Thank you for the explanation and very informative link you pasted. I think that I haven't personally noticed the bloating because we perform compact and repair on a daily basis. But looking at it; I think that ideally, it is better to avoid bloating than getting it and then fixing...

@froggiebeckie Hi! I think your problem is related to using If Me.Dirty Then Me.Dirty = False in an Unbound form. Please try and close the form without testing for me.dirty and see if error goes away when you close the form or you can use a bound form and your me.dirty test will work.

You got my vote too. I wish you and your wife good luck. I will try and vote everyday i can.

Thank you for looking into it jon.

Hello! Thank you for your input, and with that, I now realize that there is also a place great for using a loop through recordset method though it is not as efficient as the other method. And so I think the rule of thumb is, use action queries as much as possible; as long as it can, and loop...

Thank YOu and well done! Wow I did not know I still have a method c until you came.:p You know what? I will try this for sure if it's as good as action query or better, then who knows i might stick to it. What I don't understand is the bloating part. You said that doing the other methods...

Hi! To test it as you suggested, I took out the criteria and tried to update a table with about 40k records. Viola! You were right looping through recordset took about 3-4seconds while doing it in action query gave the result almost instantly. This was a terrific finding as I am now thinking...

I have solved the problem by hiding my ip; and now i can get in and out smoothly again. What exactly happened, I'm not sure, I'm not totally blocked it's just that when i used my true ip; I automatically revert back to intermittent sort of connection to this site.

@jon You did really great work on this one. I still consider myself an access newbie and I like your presentation. It's very clear and you have a great voice. @boblarson I hate to say this but I'm afraid that you have stolen the thunder! Well, In a good way!:D That link you gave above is a...

I have these two sample snippets that practically accomplishes the same thing; I haven't noticed any difference in speed whatsoever. Both are fast enough and does the job really well. What does it do: Both snippets will perform a reset values to fields: TotalDays, Debit and PayDate on an...

Hi gemma, thanks for the tip. I have already changed my data type. But before that, I have read somewhere that memo data type field is prone or can cause database corruption. So with that reason along with we won't really benefit for the increased storage capacity. I decided to convert all of it...

It's been awfully hard to get in this website lately. It started a week ago, I had to try and attempt multiple times just to get in. And then if I try to post, i had to do it multiple times as well. This is not normal as I can surf and get in to every website so far. So maybe there's a...

I think that the automatic saving feature in access when using bound forms is still a great feature. It certainly saves time and helps beginner-intermediate programmer develop and see results fast which will inspire to do more and more until we get to the next level. Or at least, that's what I'm...

I'm still somewhat on a limbo with this. Although, I think I get the overall picture of what you are suggesting. "A centralized validation rule container that I can reuse in every part of the form by just calling it whenever it's needed." Which frankly sounds very nice and handy and powerful as...

I am interested in your suggestion regarding form level variable but i don't quite grasp how to implement it, so I'm kind of wondering where to start experimenting on it. What I have right now is a very simple kind of validation checking. I have all the rules set to both Before update event of...

Thank you! Very clear and sound advice. During development I have always been thinking of a way to validate my data on a form which will prevent the form from closing if it did not pass the rule. So I decided to put all my validation rules on the On click event of a command button which is...

Hi! I have bound forms all over my database and it's causing some significant unwanted updates every now and then; even when users does not intend to. I have discovered that the two main culprits so far are the: 1. Escape key (when it can't detect dirty event.) 2. Refresh key (when user...

@Rainlover Thanks for the input. I decided that i would give it a go and stop chickening already.:D @Rabbie Thank you for the detailed spec of memo data type, it appears i should really avoid it due to tons of wasted space. :)