Search results for query: *

Thanks for your reply. Janice

Greetings, Is there a way to determine the current Application.Echo status? I would like to be able to use that information to eliminate some screen flashing that occurs when subs containing application.echo false call subs that also turn it off and back on. I've tried If Application.Echo...

I'm not sure I'm using the right terminology with "hot keys" here. I've tried some general searching and I'm not finding anything helpful, so please bear with me. I have a table containing text that I want to paste into fields when a user presses an associated combination of keys. KeyCode as...

Thanks, AceMan. That is more trouble than it is worth. I was just trying to be nice to my users. They can minimize the second form... I appreciate your response. J

I have two forms that are open at the same time. When the first form is minimized, I want to minimize the second form. What form event is fired when a users clicks the minimize control? J

Thanks, I appreciate the info! J

Yes, I did check the properties. I wasn't able to find exactly what I was looking for. Do you know how to use one of the properties for what I would like to accomplish? J

Okay, thanks. I just thought that there had be a property to reference and didn't want to write unnecessary code. J

Hi I'm writing a macro that may or may not make changes to its worksheet. I turn protection off and disable events when it does. Later, since I have turned protection off, I want to turn it back on, but I cannot see how to determine if the worksheet protection is currently turned on. I want...

Thanks, AceMan! Your instructions helped and I was able to accomplish what I needed to do. However, I must say that the toolbar interface is one of the least intuitive interfaces I have ever used. grump, grump. J

Hello, This is rather embarassing, but I've spent too much time on it already, so here goes... Years ago, I manually created a custom toolbar. I would now like to add items to one of the groups. I can see how to delete items and modify items, but I cannot see how to add an item. Can you...

Hi all, I'm very new to the Excel macro world and I have encountered a problem with losing the ability to undo. My code runs under the SheetChange event. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Application.EnableEvents = False...

Thank you so much!! I really appreciate your taking the time to share your knowledge. J

thread700-1594597 Is there any easy way or utility that I can use to quickly swap between my test and production database? The linked table manager is so slow... Also, how do you remove a table from the linked table manager? They hang around after the table is deleted and then just...

thread181-1439402 Hi all, I realize that the referenced thread is quite old, but I am wondering if anyone has a copy of the tool BobLarson refers to: The site is no longer accessible. Best regards, j

I thought that might be the response.... Thanks for taking the time. J

thread703-985550 Hi all, I have a report that prompts the user for multiple values because they are referenced in the report and otherwise unknown. It works nicely, except that I am getting prompted again when I decide to print the report I am previewing. Ideas? Thanks, J

Thanks so much. I was afraid that was going to be the answer. I think I may be too lazy for this job. ;) Janice

HI all, I want to popup a message box anytime a field is edited on a form after that record has already been reported (I know this from looking at another field on the form). I'm trying to use the Form's AfterUpdate event but it doesn't fire on every field, so I am confused. Here's what I...

I have a form that the user is allowed to "filter" in various ways. I accomplish this by creating a query based on their selections, using that query to open a recordset to make sure it returns rows and then setting the form's record source equal to that query text. dim r as object r.Open...