Search results

If you stop telling people it's all sorted out after they're dead, they might try sorting it out while they're alive.

It's not looking promising so far.

When is Jesus supposed to start flipping tables, again? Seems overdue, no?

Makes sense. My DB exists in a production environment where data is entered and reports are printed out. Therefore all functionality needs to be baked into the forms and I try to make it as bulletproof as I can...it's a lot of work, but it's rewarding when it all works. I admit I have pulled a...

Can you tell me what this would net me? Maybe I wasn't clear, but I already hide everything and lock down the DB. At first glance it looks like you let users access the navigation pane. Mine is completely unavailable and I intend to keep it that way...

Ok, I shift bypass my .accdb to do development work. When I do, it also bypasses startup restrictions on hiding the ribbon, nav pane, and shortcut menus. So, the nav pane is already showing when I bypass. Still, my users aren't doing that on their .accde as I disabled the bypass. :)

I just opened my database and hit F11, nothing happens. Nav pane still hidden. What am I missing? Tried all the other F keys - just realized F12 will perform the Office "Save As" for the form. None of the others do anything, but I should probably see about disabling that. It might not matter as...

Definitely get your forms developed so you can get a good workflow going with them. Design and use the forms from the perspective of someone else using them. Access isn't much better than Excel if just using tables. Good luck!

I didn't, but I usually just hide the navigation pane, ribbon, and everything so nothing is visible at all. No need to hide objects individually in my case :). I don't have users making queries though, at this point.

You would use a query to reopen a case for someone on request? Seems a bit cumbersome...that is one use-case.

In most/all cases, yes. Users would use forms. But I'm talking from an admin's perspective. Users won't encounter any issues while using the DB if you designed it properly (as you would, anyway). They won't have access to the tables. But it sure makes it easier for an admin to troubleshoot...

Regarding the first article, maybe pointing out what should be obvious needs to be done in order to highlight how dangerous some of these ideas are - and why his supporters should be against them. That's the point. It's not that people actively wish for people to die. Except for Maher, which...

As long as you know what is going on, I do not think it's a big deal. All it is is a table-level lookup. So as an admin, I can change a value if needed and choose from real names instead of having to refer to a lookup table to find the right ID.

Actually, many of us would prefer to just have the health experts give the update themselves. Would save us from having to do all that fact-checking ;)

I think this is a large part of the problem. Watching an opinion personality and assuming that "that's what this whole swath of people (the opposing political faction) think". This us vs them mentality, this political tribalism, is killing us.

Not any political faction.

We have to make an exception for harmful misinformation. For example, people sharing miracle cures that are unproven and potentially dangerous. I'm a firm believer in free speech, but sorry - our species has proven that we need some guardrails.

I use that as the control source for a text box on my report and for a field in datasheet view on a form. What I posted is actually a copy and paste from my DB, with changes to your specific names.

Just wanted to say that 8:00 AM - 9:15 PM is a long day in Access!

Ok, progress! That is because I didn't include a condition if False. A small modification: IIf([place_detail]="Home",Replace([place_detail],[place_detail],"Not Applicable"),[place_detail]) Also are you sure this doesn't work? Try again in query design: IIf([place_detail]="Home","Not...