Search results

Found a way to do it, it was counting fields with zero values still even when I had set it to zero so I changed it to Null, also yeah I think I'm going to work on my table structure. I started work on the DB when I didn't have a lot of knowledge of access, this is just a temporary fix as I am...

I would want it to say one.

One user can have multiple bans (as a result of how records are managed, I admit it is sloppy) and it is counted as a number. I basically just want to count every user with a number in the ban field if that makes sense.

Hi everyone! I am attempting to make a query that returns the amount of users banned from the system. The only problem is that user data is associated with a username and for every item a user signs out an item on my database a new record sprouts with their associated username and status...

I tried Select Case as well but as mentioned by pbaldy it wouldn't work due to the nature of the toggle button.

Interesting. It does work when I switch to the other button. Thanks for the information it helped a ton and made me learn a little more about the toggle button!

This seems like it should work but it just didn't. I even changed the name of the button to what you have but to no avail. I will post a copy of my database if you would like to take a look. The button is found on the Add or Remove Users form. Let me know what you find! Thanks!

How should I go about using the toggle button? I've looked up a few things and its still not as clear as I would have hoped. In my form Current I set the caption for the button to be "Edit" and allowEdits = False. I tried using AfterUpdate to change the caption and editing permissions like so...

I can honestly say I've never actually fiddled with the toggle button before. I'll see if that helps at all. Thanks!

Hi everyone. This is a super generic and frankly probably a very dumb question but I'll ask it for the sake of finding out. I have a button that enables editing on a form and when clicked the text within will change to "Editing". What I would like is once a user is done editing, for them to...

Actually that would be very helpful. I'll look into it! Thanks for the words of advice!

Thanks for the help everyone, I came to my own conclusion using the replies you guys gave. I decided I wanted the report to show the most used items AND how much overall quantity of those items has been out of the department just to provide some metrics. Here is what my SQL ended up looking...

I have two tables. One is associated with the user information side of things and the other is information pertaining to the dates signed out and items being signed out.

I'm not the most inclined with Microsoft Access yet so if you don't mind helping me further. My field for item name is simply called "Item" and I am pulling the information for Item name from a query called "qry_ItemMasterNoInput". I'm not sure what tData represents either if you could further...

Hi Everyone! I have a database responsible for tracking items coming in and out of the department I am working in. There are a multitude of items that users can sign out and I think a valuable option on the database would be to find out which items are the most popular in order to better...

So I'm not sure exactly where I should start here but I have a master report that shows data like the username of an individual, the items they took out, how many of those items they took out and if they returned them. What I would like to be able to do is have totals tied to the username of the...

Hi Everyone! I am in the process of trying to create a query that will pull from user input and return all of the different loans associated with a range of dates that the user inputs. I have a field called "Loan Date" in a query which is effectively just the day the loan was put into the...

Using that statement worked quite nicely, I have also allowed for the user to search items due or overdue via their own input. I have two textboxes (one called txt_StartDate and the other called txt_EndDate) with the code being something like this: >=[Forms]![Item Search]![txt_StartDate] And...

I apologize I have been hard at work on other tasks lately and did not notice your messages. I solved the issue by querying the query that had the parameters set, i.e. I had an master query that would show any and all information associated with the database and a user could filter that...

Ended up finding my own way around it, I appreciate the help though! Thank you everyone!