Search results

You need to make the expression more complex or create a function. I would create a function. Then you could use the min and the max and compare them so you can decide what to return.

Not by a long shot;) Everything the others said you should take as gospel. In the cases where you want to display the string, use the Switch() in the form or report's ControlSource for the field you are displaying or create a conversion table and use dLookup() to return the value. The...

Use Me.Parent!cboCustomerName from a subform to its parent form. REMEMBER when you are using a Navigation form only a SINGLE "main" form is ever loaded at any time and that "main" form is a child of the navigation form so as the others suggested you need to include the name of the actual...

I really don't think the people of California are stupid enough to vote for Kamala. Of course, if she doesn't step in until a month before the election and enters the race with a billion dollar war chest as she did with the Presidential race, they may be able to keep her quiet enough to get the...

I worked with them for a couple of years but it was very frustrating lobbying stupid people who only believed the lies promulgated by the left about an "out of control convention" that could do away with the entire Constitution. So instead of being a rational discussion, it always devolved to...

It would be best if you posted your code. But, I think there are probably better methods for automating this. You should be using TransferSpreadsheet to create the exports rather than OLE automation. This also allows you to name the workbooks BEFORE you export them so they get saved with the...

Back in the early 70's while working with an insurance company, my boss and I were on our way to meet with a user. The layout of all the floors in the tower building was about 5 desks deep, back to the windows. Central core had conference rooms and all utilities. As we were walking down the...

Keep a list of VBA functions handy as you start to use Access as a RAD tool. I found it very helpful and I still use it to find functions I don't use frequently. https://learn.microsoft.com/en-us/office/vba/access/Concepts/Criteria-Expressions/functions-category-list And here's a link to a...

That's the whole point of insurance. You are buying something you don't actually want to use and they are selling something they don't actually want to provide. Strange relationship. Underwriters get paid the big bucks due to their ability to calculate risk. The price has to be high enough...

I tried to look to see what the plans were but you can't do that without providing personal details and contact information and getting a call back. Useless website.

I came across this pdf today and thought I would share it. There may be a newer version if you go to the COS official website. The group has been working diligently to get the states to agree to call a convention to propose some much needed amendments. The left is working more successfully to...

Two wackjobs. One hates America, the other loves America. I take door #2. Then your comment regarding my comment was simply noise and had no meaning. You claim to be in the business. I am not although I have interacted with my towns zoning and building departments and they are bureaucrats...

It was a reflection of your view that only Tariffs increase costs. Costs are never increased by other factors.

Your code is saving the popup, NOT the underlying record unless the popup is bound. In either case, the solution from the other post is to 1. make the popup model so the code will stop executing in the calling form when the popup opens 2. update the subform as you are currently doing in your...

Didn't I give you the answer in a different thread?

Here's a report form I frequently use in my apps. It allows you to define arguments for each report and this form changes the visible fields as you click on different reports. It also supports multiple output destinations. The PDF option prints to PDF but you can change it to open the PDF...

Oh, for the good ol' days when it wasn't a crime in California to be a Republican. Looks like Newsome is single handedly going to turn California red again.

That is not the correct method. Use a multi-field unique index. Open the indexes dialog to create it. On the first fully blank line, add a name, pick the first field, check the unique property. Go to the next fully blank line. Skip the name field, pick the second field Go to the next fully...

The list on techonthenet.com is incomplete. Please bookmark the MS page https://learn.microsoft.com/en-us/office/vba/access/Concepts/Criteria-Expressions/functions-category-list

The zoning and permits which restrict and increase the cost of building don't count.