Search results

Great stuff. Thank you very much!

@isladogs - I have not. I'm not familiar with that. What does Ctrl+G do? Also, I tried your code that you provided in your article and it worked beautifully. I was able to reverse the code from another database. Very elegant. Thanks!

@June7 - I hide the ribbon, hide the navigation pane and disabled all Access close out buttons. How can I get to the module that contains my function? Can I still get to the VBA editor?

Okay. I realize this is probably a stupid question - but how do I get back in after the shift key bypass is disabled? What if I want to turn it off so that I can modify something?

Many thanks isladogs!

Thank you both very much!

I'm trying to disable the Shift Key Bypass functionality. I found the following methodology in an AI website. It seems simple enough but it doesn't work. Can anyone help? I want the autoexec macro to run even if the Shift key is held down. To disable the shift key bypass in Microsoft Access...

Nevermind. I found the issue. There was a problem with my eyesight.

I wrote a procedure to rename a file and place it in a new directory. I am using the NAME statement to do this. I keep getting a "File not found" error on the first record. I tried it with the destination directory being blank. I tried it with the destination directory having the same files as...

Thanks MajP. Works perfectly now!

I'm getting a type mismatch error in the following code on the "Set lstname = txt_CurrentListBox" line. I realize that lstname is an object (listbox) and txt_CurrentListBox is a textbox holding a string so the error makes sense. However, what can I do to use a variable for the listbox name so...

Pat - I wrote you a poem: If you said you were cold, I would wrap my arms around you. If you said you were thirsty, I would give you the ocean blue. I would give you anything: the moon, the stars, the sunset too. This heart in my hands I hold out to you.

Thank you all for your responses. GPGeorge - thanks for the explanation. It seemed to simple to be true.

My mistake. 2/22 is a Saturday. The only reason those queries work is because -2 and +5 are hard coded.

If the date entered is a Monday I would want that date as the "Previous Monday". I don't quite understand that query. There is a dash before Weekday and also a "-2". How could the -2 be hard coded?

The user enters a date on a form: 2/18/2025 I need a query that will calculate the previous Monday and the coming Saturday. The result should look like this: I'm familiar with DatePart and DateAdd but just can't figure out the logic. ANy help will be appreciated.

Nevermind. I used a non-proportional font and it solved my problem. Thanks so much for your help!

Okay. I guess this is a dumb question but what is a "non-proportional font"?

I have a listbox whose rowsource is a table consisting of two columns. Works great. However, the user wants the data to be displayed as text in a text box so that they can copy/paste into a Word document. I already wrote the code to loop through the table and write the table's rows into a text...

Yes. I see that now. Thanks everyone!