Search results

Thank you to all who have replied. Lots a stuff to further investigate and experiment with.

I've been learnig about dates and Access and was surprised to learn that there's no native function determine the number of weekdays between 2 dates as there is in Excel. I googled around and found a couple of functions that do that job, and have been noodling around with using one of the...

In our case, its less about keeping unauthorized people out, and more about preventing unauthorized people from adding new, and more importantly, altering existing data accidentally or on purpose.

I had that thought, so I went through all of the other user forms, and the particular combination that allowed this to happen doesn't exist anywhere else.

Good points I hadn't considered. Thank you for taking the time to reply. And we've already violated one of the usability rules, as we currently have 12 active users.

I've done some Googling, but I haven't been able to find an explanation of why using a combo box is a greater security risk versus using a textbox for the user name on a login form. Can anyone educate me, or point me to a resource that explains this concept?

So, I think I may have figured it out. The Login form Data Properties had "Allow Deletions" set to Yes. By setting it to No, it appears to prevent this from happening.

The plot thickens. A supervisor just came up to me and said, one of my people said something weird happened Monday morning (Oh boy here we go). He was logging in, and while he was typing his password in the password field in the login form, he realized he'd made a mistake, so he pressed Ctrl A...

The only user that has the nav pane, full ribbon, right click or other menus is me. The BE itself is not secured via password, and its the only thing I can think of. Though to say most of our workforce isn't the most tech savvy is being kind, so someone would have first, been able to locate the...

There is no way to delete a user in the front end. If a user has sufficient privileges, ( via a hidden test at login) they have the ability to mark a user as inactive, and an inactive user can no longer login. This user does not have that privilege.

I have a split database with about 15 users, each with their own front end. The back end is housed on a NAS on our company LAN. There is also a Datto backup device that backs up the NAS regularly throughout the day. The front end has a login form that pulls from a user table. The login form...

https://www.makeuseof.com/tag/email-to-sms/

I was able to find something. If you use the "From Other Sources" option in Excel's "Get External Data" tool, you can choose "From Microsoft Query". Once you've connected to the desired tables, you basically roll your own query from inside Excel, including pulling from multiple related tables...

Yes the second thing.

I have a split database, and each user has their own FE. A couple of folks in the office would like to pull data from it. Both setups call for pulling from a query I made for them that reside in the BE. I setup their Excel workbook connections for them, and everything works until someone is...

Mark, Yes, we do have to maintain information on all batches manufactured, but that is beyond the scope of this project. As I mentioned before, I built an Access application that manages QA and Technical Services documents, that is a small part of that, and why some batch information is pulled...

Pat, Yes, with a few exceptions, we are on demand. We have a few part numbers that aren't that we manufacture a batch of, and essentially manage the shipping and inventory for our customer. These part numbers are manufactured in large batches like all of our products, but are shipped/sold in...

Plog, Thank you for taking the time to do that. There are a bunch of redundant tables/relationships in there as I was trying different things. I apologize. I should have cleaned it up first, and it's still a mess even after cleanup. The whole thing is going on the scrap heap. Mark, That's a...

How about the whole thing? This is the latest iteration. I think Im getting close, but...

Short description, the thing will hinge on two things, Batches (that we manufacture) and Purchase Orders (that we receive from customers). The fields that really matter are these Batch Table ProductID Quantity Manufactured Ready Status Date of Manufacture Purchase Request Table...