Recent content by naterook

Hey everyone. This isn't critical, but would be a nice feature. I have a list box of clients and a list box of account managers that manage those clients. Does anyone know a bit of code that would let me click on an account manager in their list box and it would then filter the client list...

Perfection! Is it the PasteAppend that's fixing it? In other words, if it's just 'paste', is it going to fast, but if it's paste append, it's not pasting it in the current field, but instead adding it to the bottom of the table? Thank you for this!

I've gotten this far: https://stackoverflow.com/questions/72075278/how-to-avoid-ms-access-error-the-command-or-action-paste-is-not-available-now Maybe I need to slow it down before the paste option. But the duplicate record button creates a macro, not a VBA sequence. I've tried writing the dba...

Hey everyone. I can't figure out why this works only sometimes. I have a Tabular (continuous) subform. I've added a Duplicate Record button to duplicate my subform records. However, I click on it once or twice and it works. Then I click again and it gives me the error 'The command or action...

So... something I found online said to go to Database Tools > Analyze Performance. I did that and it seems to be working now... although a couple buttons that I added for filtering don't work anymore, but I think I can fix those.

Someone else mentioned to me that it may be because I'm not signed in. I'm having our admin reset my Office pw so I can add my credentials. I will let you know if that works.

Attached... not zipped though.

Sure... Not sure how to do that either. :D

So I have my database working pretty well and I'm trying to polish it up. Suddenly, my forms won't save. I try to close them and it offers to save, but when I click on 'Yes' it doesn't close the form. The only way I can close the form is to not save it. Is it me or is this a known issue?

Pretty much. :)

arnelgp, you are fabulous! It works! Thank you so much!!

Thanks for this. VBA is new to me. Do I just drop this in the On Click area or do I need to substitute text? For example, on Private Sub Button 1_Click() do I need to change Button 1 to the name of my button?

That sounds like the simplest option... sorry, I'm super green here. Is that a form-level thing I need to change? How do I do that?

Hi everyone. Is there a way to create a Macro to filter by selection? I know there's a button in the ribbon, but some of our users are on RunTime and don't have the ribbon. In a form, I just need them to be able to Filter by Selection. Thanks in advance.

Hi all. I'm self-taught in Access. I first started using it about 20 years ago and then didn't for another 10 years... and then didn't again for another 10 years. I'm picking it back up and some of it come right back and some of it is a little frustrating, but I'm excited to learn more. I...