Search results

Works like a charm, thank you!

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

Hey arnelgp, Hoping you could help me and let me know what you mean by pm is the key. Doesn't look like my version allows for a product key. Thanks!

Yeah, it seems like it's pretty complicated, and plus I would probably need to know what exactly I'm trying to ask, as I don't know the DAX terminology.

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!

Looks like the demo version won't work for me sadly Not sure what you mean by the pm is the key, unless it's license key, in which case I'm still unsure where that goes in this program.

Would this work for the actual protected sheet? Also not sure if there is a free option, I see it says demo, not sure if that means I could actually use it without paying. Thanks for your reply!!!!

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!

As always, a VBA saviour from God above. Thank you so much!

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

You're a genius, thank you, works perfectly fine now!

Hey there, Tried this out, says it's missing syntax, tried adding 2 "))" at the end, didn't work. Not sure where to place the code you added as well? Thanks for replying!

This is the exact copy of what I had in the criteria

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

https://drive.google.com/file/d/1X3KvJqu-LvisGdvjLSJJRtG7HSr7byzs/view?usp=sharing The website said there was an error, here you are!

The issue is the way I've made the join queries, I'm going to upload them as that is probably more logical

Hey gasman, that is exactly how it's done now. I think I've found the issue but unsure how to solve it. The Union Query is pulling from 2 JOIN queries, I don't know why I did this, it was the only way I knew how, so basically, the records are combined, MTL and ROF tables, and a total query...

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

TransactionID: [RoFID] & "" & [MTLID] works for the combination issue as one is always blank,

Disregard!