Search results

Hello, I am trying to use VBA to create an automatic date entry when the feilds in B:B are first added. This will be recorded in the adjacent A column. I'd like each seperate row to record the date, which I'll use for a calculation between the two dates (in A and in B columns) I would prefer...

Hola, Trying to make a card filter based on two collums selections, not sure where to begin with the DAX, totally new concept to me. If there is anyone that knows anything about PowerBI and what I'm talking about, I'll explain a bit better. Thanks!

Hola, I'm a fool and have either mistyped the password (I've tried every possible combination) or I forget that I changed it from what I usually used. Any ideas? I've tried the VBA method that will attempt to try passwords, but it just crashes contstantly. Thanks!

Hola, I'm just making a form that will add users in for a login page, there are two categories of users, employees and management. if a checkbox is clicked before update, the information recorded in the control source tblUsers will be added to tblUsersKey (the exact same collums and setup)...

Hey there, Seems I am having an issue in the same realm as this below. https://www.access-programmers.co.uk/forums/threads/cannot-filter-on-date-fields-in-access-ms-access-crashes.163510/ The feild I am trying to filter is defaulted to Now() when a user generates the record. It is a date/time...

Hey all, I'm having an issue where records are combining into one row if the PatronID matches, as it is normalized to do so. There are two source tables, tblReceiptofFunds and tblMultipleTransactionLogs combine in the rows, which makes some other functions I have like combining the ID's for a...

Hey all, So I have two tables, tblMultipleTransactionLogs, and tblReceiptofFunds - they are both two types of transactions we do, therefore stored and normalized. The common field among them is the [Patron], which is a number field related to [tblPatrons.PatronID]. Both have some unique...

Hey all, Not sure how to title this, as I'm not sure what to even call this. Essentially the database I'm building is for transaction records, the query in question totals the transactions and sums them for each person. I'll attach a screenshot below. ---------------- The query...

Hey All! I have a query that I am trying to run that'll populate a chart showing transactions from one period to another within the "day". Essentially, in our business we have a time period which transactions "reset" a threshold. At 4AM every day I need to clear the query and begin only...

Hey guys, I've got a database that I'm building that will be used by hundreds of people per day, per property at my company. To limit the possibility of design changes etc, I've created a login screen and on startup have disabled basically every menu and toolbar, as the database is made to be...

Hey All, This may be very easy, or very difficult, I'm not entirely sure. Basically, there is a user form that is filled out as a regulatory obligation for every transaction completed. These records require some personal information, and based on this information collected (first, last, date...

Hey All, I've created a new project for my work, it's essentially a computer assisted dispatch, storing call records for Security Operations. Essentially with each "call" (record) there is a total of 6 fields to assign "staff" to. What I'd like to do is make it so that only staff with the...

Hey All, So there are a few things to note about my database - firstly it's a comprehensive database for Employees. One of the issues I am having is with training. I have a form that creates new entries for training (for example, lets say next week I roll out a training/sign off for a Health...

Hello all, I have been building an employee database, it has gone amazingly, just ran into something I wouldn't know how to sort out. Basically, when we have a new training requirement come out we need to track completion. The way I currently do that is adding it in through the "Add New...

Hello all, I have been building an employee database, it has gone amazingly, just ran into something I wouldn't know how to sort out. Basically, when we have a new training requirement come out we need to track completion. The way I currently do that is adding it in through the "Add New...

Good afternoon/evening all! I am back again, I am moving forward with my project wonderfully! I have run into another area that just makes the user experience easier and allows for more consistency in records. I've attached a screenshot of what I am trying to do. In my form, I have a form that...

Hello! I am trying to make a code that will open a message box is the "txtEmerg" box is = to or > than "10" to display a message that Emergency Days Have Been Exhausted. I have no experience with VBA Code and would love to learn but start small. Any help you can offer would be greatly...

Hello, I am creating an employee database, and am working on tracking attendance. Below is a working code to count all occurrences no matter what type of category (sick, emergency, etc.) =CDbl(Nz(Sum([Number of Days]),0)) I am struggling with making a code that references the "Number of Days"...