Search results

Thanks for the added explanation.

This thread is very disturbing if true. Especially the part about unbound control on a form cannot be referenced. I just tested this and didn't have a problem. What are the test conditions to confirm this?

Please see june's post #29 for example of what i meant. Im not saying references outside the query.

Turn them into an amusement park full of pickpockets.

It's just getting started. Come back after a year and a half and see what the total savings is.

Try this.

Good luck with getting everyone to agree to that.

What was confusing about it. You CAN reference the value of an alias in a query as was just demonstrated in the last few posts. Wait, I may have updated my post after you read the initial one. Maybe that's where the confusion came in.

When biden administration is in control of putting out false manipulated numbers like they did with jobs reports, the numbers become meaningless. At no time during the Biden years did people feel the effects of a real 3% inflation rate. They most certainly did in the Trump 45 years and they want...

I didn't word that correctly, was focused on the use of Quer1 in the Quer1 itself which is not possible. Referencing aliases in the same query is possible. My mistake.

Here is what you were trying to do, but as MajP pointed out, there is no way to differentiate the normal order items from the rollback items unless you change the structure of the table as he already laid out for you. INSERT INTO tblLineDetails ( InvoiceID, Quantities, SellingPrice, ProductName...

This is your only option to get the effect you were going for. Get used to it.

Here is what Philipp recommends over at codekabinett for books on Access. Even though these books appear to be outdated, the information at a basic level will apply to any of the modern versions. Of course the interface looks different between the 2010 version and todays modern ribbon interface...

I want the one that Iron Man has in his chest.

I have a Toyota Avalon Hybrid currently, and it gets great gas milage in town and when I need to take a longer road trip I don't have to search for a charging station. I think if charging stations were everywhere and you could plug in for five minutes to get a 90% charge, there would be a lot...

I'll tell that to all the golf courses that I frequent. They will have to get rid of those woke carts. I would love to have one for all the in town round trip driving and going back and forth to work. The only reason I held off on the idea was the price tag was too high and also the horror...

I haven't bought my new Tesla yet. Trump did though. :)

I'd say it is worth 10 times what it cost considering how it prevented the 2024 censoring of freedom of speech pre-election. Maybe even priceless.

I'll just wait for @Redstick tell us what the parameters of fully functional actually means before going any further.

I put the MembershipType in the mix assuming there were different types of members. If all members are on the same exact level, then no, you wouldn't need that. It looks like it's free to become a member as I do not see any dues or fees of any kind in your original example. Mind telling us what...