Search results

Does anyone know how to Contact the Administrator. I have Private Messaged Vassago and he has not gotten back to me. Does anyone know if there is anyone else besides Vassago who has Administrative Privileges. Someone with the authority who can 'Email' a Member and tell the Member that their...

Geotch, again, I am very appreciative for your efforts to solve my problem. For the many who looked at this post and had a similar situation that they wanted to resolve, here is another solution that someone else gave me. QuantityXUnitRate = CCur(Format(Quantity * (UnitRate * Pct) / 10...

Geotch, thank you very much for your time, effort and your clever solution. I see that it calculates the Currency correctly and has the desired result. It's much appreciated! Regards, Rhino999

Hey, if you don't want to really be helpful to those who have less experience that you have, then why are you on here in the first place. I'm not getting paid for this, I'm trying to helping a friend, for FREE..... And by the way spikepl, take a look at Geotch response where he demonstrates...

Geotch, thanks so much for replying. Those calculation look correct. Unfortunately, I'm not using it in a Query. It is being used in an AfterUpdate statement from Combox Dropdown. I'm not sure how I can convert it, but I'll study it in greater detail and see if I can incorporate what you did...

I have spent much time (over 40 hours) on this PROBLEM. I when on this site to get an answer that I can move forward with. I'm having trouble with you solution. Additionally, I have yet to find full Syntax on Ccur with all arguments and options. I haven't found anything using MS Access...

spikepl, thanks for your response. Before I posted I looked around for a week and had no success finding anything remotely close to the Rounding I need for this situation. I was not able to find anything at my skill level that I could convert or modify so that I could implement it into my code...

Thank you very much for responding! I am calculating QuantityXUnitRate = Quantity * (UnitRate*Pct). If I'm going to use your Function, I'll need you to be more specific, because I'm not very experienced with Access. This would be a Public Function, right! Is this the code that I should use...

Thank you VERY MUCH for responding! I did the best job I could do in trying to explain my situation. I’m glad to answer any questions that you may have to further shed some light on my delema. I’d like to Round to the nearest .x9 and have .x5 be the tie breaker. So .x4 or Less Rounds down to...

I need help creating a SIMPLE solution for Retail rounding. Below are is an Example of Detail lines in a DataSheet Form that represents the price for an Item. QuantityXUnitRate = Quantity * (UnitRate*Pct) $14.0049 = 1 * $10.53 * 1.33 $14.0049 = 1 * $10.53 * 1.33 I need the price to end with...

To RainLover: Thank you so much for supplying me with a solution. Unfortunately, I needed the fasted and simplest solution to implement ASAP. I’m sure that your solution would work fine, but I just do not have enough experience to modify it quickly and diagnose and issues that would arise...

This works! I have been trying to find a fix for this for 5 days. Thanks to everyone who helped me! This was simple solution, which was exactly what I wanted. I used a DoCmd.OpenForm with acDialog and a Requery of the ComboBox name. On the ComboBox double click Event, I did the following, See...

Thanks for responding. The name of the ComboBox is ItemID. The Control of the ComboBox is Item. I assume you mean Got Focus becaus e you wrote Get Focus. " On the Get Focus event of Item Combobox add the following code DoCmd.Requery "[Item Combobox] " " When I go to the comboBox and Code in...

I hope someone can help and has solved my exact problem with a simple solution and very little coding. You should know that I consider myself a beginner in VB and MS Access. I have 3 forms: Main form FrmCustMainAboveSubJob Caption Customer Record Source Customer Inside...

Brian, again thanks for trying to help. I'm glad the code I posted finally allowed you to understand what I was initially looking for, even though my description could not. I hope I did not waste too much of your time. Thanks, Rhino999

Hi everyone, I would like to thank everyone for trying to help me. I want to let everyone know that I am very new to Visual Basic coding, so when I look at something, it's very difficult to decipher what exactly is going on. Without step-by-step instructions of what each piece of code does, I...

Brian, sorry for the confusion, that's my fault. The one thing I don't want to do is waste your time. So thanks again for trying to help me. The criteria is as you stated, "Hide the row, if any one of the columns G to P doesn't have a Y". That is correct, if there are no "Y" 's on that...

Thank you for responding This needs to be run for multiple columns all at same time, can I just change the column 2 for B to a range of columns. ie column = G4:P987. Additionally, was planning on just running this from a keystroke, I think it's always easier for the user and quicker when...

Brian, it is a row without a "Y" in a given column. I would prefer if the macro would be able to look for the letter "Y", instead of just counting if something is present in that row/column, this way I could use the macro in other isyuations with other letters down the road, like a "D" for...

I did check out the advanced filter, it's not something that I would want to use.It takes too much effort and time for people who are not familiar with how to run it. Additionally, it takes screen space and there are other worksheets that are all coordinated together with other rows and columns...