Search results for query: *

Is there not a way to set the ColorIndex of a cell = ColorIndex of a different cell? If I can get the value of the cell and the fill color, that is all I really need.

Is there a way to run a macro or write a formula in Excel XP so a certain cell is an exact duplicate of another cell, formatting and coloring included? For example, D1 is always the same as A1 no matter what changes are made to A1.

My report usually has 4 or 5 pages, but none of them are full with records. They are grouped so there are only a couple records per page. Is there any way to have the footer show up right below the detail section (not the bottom of the page) on EVERY page? The report footer does this, but...

I still recieve the same error, but the error is on a line in the excel document, must be one of the macros. Can I disable the macros in my code somehow?

objXl.activeworkbook.close savechange:=true

bubba, that gives me a 'Application-defined or object-defined error'

PHV, I tried your suggestion and it worked fine for the example I posted. I then changed the code from a test excel doc to the production excel doc and I still get the message prompting to save changes. The difference between the two is I am changing the active worksheet. Do I need to do...

I have the following code running from a button which is working fine, but it always prompts if I want to save changes to the excel file, which I do not. Is there anything I can add so it closes/quits the excel object without prompting to save? Dim objXL As Object Set objXL =...

That works perfectly, thank you. However, if I had a filter applied before I change the recordsetype, is there a way to pass that same filter on after the requery?

You know I seen you posted that code in a different thread and I tried it before with no results. Sure as heck, works like a charm this time. Thanks a lot.

The criteria in my query references some fields on a search form. What I need it to do is if Text24 is null, select all values from the table including null value fields. If Text24 is not null, select the records where FieldA = Text24. I tried to use an IIF statement, but I would either get...

This sounds like what I'm looking for, but I get the error: Run-time error '3159' Not a valid bookmark Any ideas?

On my form I have an edit button that changes the recordsettype of the form. When I do this it requeries the form and goes to the first record. How can I make it stay on/go to the record I was on when I hit the edit button?

Thanks, that works awesome.

Thanks. I tried entering the following be keep getting an 'Expected:=' error. Whats going on? DLookup("[assettag]", "[test1]", "[assettag]='"& forms!frmInventory!txtAssetTag &"'")

I have a form with a button that opens a second form. What I need it to do is to search a table to see if a field contains a specific value (equal to field on current form). If the field contains the required value, continue opening second form. If not, just display a message box that says...

Yes, I've seen it and tried to apply it, but with no luck. In my table I have about 600 records, with each one in either GROUP A, GROUP B, or GROUP C. When I edit my query as suggested in the tip, it lists all 600 records in the drop down, not 3 (GROUP A, GROUP B, GROUP C) or 4 (GROUP A...

I have a combo box on a main form with the options GROUP A, GROUP B, GROUP C. These are used to filter the subform results. The subform runs on a query with the criteria FIELDX = main form combo box. How would I create an option for the user to select all records? As long as the query has...

To elaborate, I need the same results from the two unbound text boxes (startdate and enddate) combined with the filter-by-form as I would get by typing 'Between #2005/01/01# AND #2006/01/01#' into the date field. Anyone?

I have a form that has about 12 different fields that users enter information into. They are constantly using the 'filter by form' so they can narrow down the records they are looking for. This has been working great, but one of the fields is a date field and I needed to add a way to filter...