Search results

ASSUMING the price is ALWAYS + 30%. That isn't normally the case (at least in the several order entry applications that I have built) and I pointed out that if it is ALWAYS + 30% then it should not be stored. It should be calculated as needed. Order details contains the ACTUAL selling price...

Not if they are going to pay the surgeon $8,000 instead of the $38,000 he asked for. How long will doctors work for slave wages (in their minds)? Anyone who bothers to read their EOB's sees this problem every month. I have spoken about this multiple times with hard, personal, examples. This...

You have a dog in this fight and you are letting it cloud your judgement. You are believing the totally biased left-wing media. The article I read about the issue told quite a different story about why the young man was apprehended. Why he was held for 10 days, I can't answer? Why was he not...

They did pick the safe cases. This guy had two deportation orders and admitted he was a member of MS 13 also. He is currently HOME in El Salvador where he was born. Why they put him in prison, I don't know. Probably because he is an acknowledged member of MS 13 and El Salvador is doing its...

Moke was being pedantic so I responded in kind. It really doesn't matter whether the man was arrested and prosecuted. His wife felt sufficiently threatened to call the police for protection from him TWICE. Don't we believe ALL women? Given the liberal mindset, the accusations should have...

The actual selling price of an item would be stored on the order details record, not in the product table. Maybe calling it the SuggestedSellingPrice would make you feel better. Then on the order details, it could be called ActualSellingPrice to avoid all confusion.

He didn't say selling price was NEVER entered and people get sloppy with their descriptions and it is quite possible, he didn't examine every record. So, as a "safety play", I would not simply update ALL records. I would add the selling price for only records with an empty value. The point is...

So it's OK that he beat his wife as long as he wasn't arrested? She probably deserved it anyway.

The selling price may be +30% or it may be some other value which is why it is being stored. This update query is to correct an omission in the original data entry. Therefore, If you want to assume that any record which has a non-zero, non-null value in selling price has the correct value...

I think he's use a control's AfterUpdate event also but when you manipulate a control using VBA, that control's events don't fire so that may be what is causing the disconnect. In that case, the code needs to move to the form's BeforeUpdate event or you need to do something like separate the...

How about abusing his wife. He was arrested twice for that? And she is now afraid to talk about her complaints so she evades the questions.

If you notice, each question can have a different list of responses and the answer allows for both a selection and a text answer. I can't post my medical example which is a questionnaire used to help the visiting nurses decide on what types of home health aid a new client will need. In the...

That is insufficient. I'm surprised you think this is working. Just passing in the FK to the modal form is not enough, You need code to copy the FK from Me.OpenArgs to the FK field on your record. Please reread my instructions in #9 carefully as to where this code goes and why it goes there...

Now is as good a time as any to start applying best practices. Compile before you test - always. Fix compile errors immediately. Save your code frequently. During development, make many backups. I easily end up with a dozen or more for any given day. I don't keep all those backups for...

Have you looked? QuickBooks isn't that expensive. How many employees are you talking about? Why not use a standard schema to start with? If you use a standard schema, the process becomes at least comprehensible to the rest of the world. You seem to be using your spreadsheets to guide you...

None of the other religious groups march in mobs through the streets shooting weapons into the air while shouting "death to the jews! death to America!" The radical Muslims are intent on first destroying Israel and second destroying America, and then they're coming for the rest of you. One of...

To YOU so screw he rest of the world. It's an opinion:(:poop::poop::poop:

I really hate to argue with you about this but I really think that there are simple methods to solve the problem without actually renaming permanent objects temporarily. You never know who is going to modify the code in the future. Will they notice that a permanent object was changed? Will...

Thanks for testing that. Is the subform actually a subform or is the query just pasted in as the subform name?

Now that you've shown us your code and we can see the context, all I can say is why? When I read the question, I assumed you had copied the form in design view and were modifying it for use a a popup. I never envisioned doing this on the fly. What are you hoping to accomplish? AND, you will...