Search results

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...

Just want to help simplify where possible based on your specific needs. If you have one field in there for MemberType, that will classify each of your members appropriately. The actual addresses of members can be in a separate table if you find too much duplication (members all live at same...

You can name it whatever you like, the point is how you are supposed to use it. The FK PartnerID should be in the main DataTableMembers table. The ID in the copy of your main table links back to that PartnerID in the main table. This is only one aspect of your table structure that I'm pointing...

That takes too much time. So in the mean time, we'll just slash everything down to it's core necessity just like he did with Twiter, then go back and show everyone in detail why this was necessary. It's the most efficient way to get results that matter.

The biggest glaring error I see in the tables is DataTableMembers is missing the ParentID field that should be linking to DataTableMembers_1. The only purpose of that copied table is for establishing the ParentMemberID or simply the ParentID. There should be no other links to that copied table...

@jdraw I just saw that video recently and it seems like appropriate overview. Especially the part on determining the tables involved. Interesting title. It does appear that ChatGPT gave a lot of insight into the proper table structure, but what it doesn't do is teach you access. There is just a...

So this is all about handling returned shipment of goods?

No problem at all. So glad to see you were able to provide such a solution for you client.

OK, so your not touching the screen unless the NFC card reader fails to login, but the logon form is now visible to touch if desired. That would have been nice to know in your very first post. This is from your very first post and where all of the confusion started. We now know that the...