Search results for query: *

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

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

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

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

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

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

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

I am exporting data to an excel worksheet. I would like to set default values for some of my columns, so that the user doesn't have to worry about those fields when he inserts a row. Here's what I am doing now. With .Columns("A:A") With .Validation .Delete...

Hi all, This is a really basic question, but I have spent 2 hours on it so far and I'm losing it. I have a control name stored in a string field: ControlName For instance: Forms!Reports_Form.CmbSignature I want to requery the field whose name is in the ControlName field. I have tried every...

I cannot see or get to my database objects window. I have no code in place to hide the window. The Toolbar and Menubar options to show that window isn't working. Suggestions, please... J

I'm looking for a utility that will sort the fields in a table definition alphabetically. Ideally, I would like to leave the indicies at the top and sort everything else, but that is not a requirement. I can move the indicies by hand if necessary. I am also looking for a way to compare the...

Is there a function or standard way to format the day portion of a date to something like 21st or 4th? Thanks. J

I'm "exporting" a query to Excel with the following: Dim xlApp As New Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Set xlApp = Excel.Application Set xlBook = xlApp.Workbooks.Add xlApp.DisplayAlerts = False For i = xlBook.Worksheets.Count...

I am trying to set the formula of a cell in my vb code. Here's what I am doing: Dim myexpr As String Dim myrange As String myexpr = """<>0""" myrange = "D5:D" & lastrow ActiveCell.FormulaR1C1 = "=CountIf(" & myrange & ", " & myexpr & " )" What ends up in the formula of the...

In an old thread (thread703-1563912) dhookom (Programmer) posted this link to code for keeping track of page numbers by group in a report: http://www.mvps.org/access/reports/rpt0013.htmPrinting This looks like just what I need, but I am having problems. Me.Pages is always = 0 for me, so I...

Hi all, In my forms I generally change the backcolor of a control when it gets focus. However, that doesn't work for checkboxes so I would like to make the label associated with the control that just got focus bold. I can't find a way to refer to the associated label. Any ideas? Best, Janice