Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Fonzie

    Duplicate of cell

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

    Duplicate of cell

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

    Footer - right below detail on all pages

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

    Close object.workbook without saving

    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?
  5. Fonzie

    Close object.workbook without saving

    objXl.activeworkbook.close savechange:=true
  6. Fonzie

    Close object.workbook without saving

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

    Close object.workbook without saving

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

    Close object.workbook without saving

    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 =...
  9. Fonzie

    Change RecordSetType - Form refreshes

    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?
  10. Fonzie

    IIF statement, criteria, nulls

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

    IIF statement, criteria, nulls

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

    Change RecordSetType - Form refreshes

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

    Change RecordSetType - Form refreshes

    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?
  14. Fonzie

    search table before opening form

    Thanks, that works awesome.
  15. Fonzie

    search table before opening form

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

    search table before opening form

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

    CBO filters subform - Select 'ALL'

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

    CBO filters subform - Select 'ALL'

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

    Filter By Form + Date Filter

    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?
  20. Fonzie

    Filter By Form + Date Filter

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

Part and Inventory Search

Back
Top