Search results

  1. W

    Query not returning all results

    I have a table listing a number of cell phone products and their carrier along with their status' in the production process. I want the query to return the most recent status for each product for each carrier. However, out of the 20+ products that I'd like the most recent status for for each...
  2. W

    Help with Max function!

    I'm trying to link a table to a query called M Gate Status. Each product has a certain status that matches it and I'd like my query to show the most recent status for each product. I've created an M Gate Status # column on the MGS table and want to select the maximum number, but I can't figure...
  3. W

    A code for selecting If any cell = then...

    Hello All, I'm new to visual basic and am wondering if there's anyway I can write a code that will scan to see if any name in a cell is equal to another name in a cell, and if so, take the highest number (located in another column) corresponding to that name. Any help would be much appreciated...
  4. W

    Access VBA-Export to Excel file

    I'm trying to export my access database to excel without overwriting what was already on the file. My query is called Combined Data Query and I'd like it pasted on the first worksheet of an Excel file called Stoplightchart.xls Can anyone write the code for me or point me in the right...
  5. W

    VBA Looping with Autofilter!!!

    I need to create a document that searches for a criteria in autofilter, copy & pastes that into another sheet, uses autofilter to search for another criteria, copy & pastes that, etc 128 times. Any ideas for how to do this using a loop? This is for work & I need help ASAP!!!
  6. W

    Procedure too large--help!! VB Novice

    I'm extremely new to Visual Basics and instead of learning how to use it, am trying to record an extremely long macro. It told me my procedure is too large and I'm only 1/4 of the way done with my macro. I have no idea how to begin using visual basic and need any help I can get to either shorten...
Back
Top Bottom