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 derfloh 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: *

  • Users: 01491
  • Order by date
  1. 01491

    Help - change VLOOKUP reference using a loop

    Fantastic !!! Thanks very much.
  2. 01491

    Help - change VLOOKUP reference using a loop

    I'm having a problem changing the reference in a vlookup formula for each cycle of a For..Next loop. Current code is: ActiveCell.FormulaR1C1 = "=IF(ISNA(VLOOKUP(RC1,QryRecDetailsCalc!R2C1:R2C3,3,FALSE)),"""",VLOOKUP(RC1,QryRecDetailsCalc!R2C1:R2C3,3,FALSE))" I...
  3. 01491

    Help - Vlookup reference nightmare

    I'm trying to write a For..Next loop for a vlookup in Excel. For each loop, I want the reference area to move down a row. ie. vlookup(A1,Sheet1!A1:D1,3,False) then next loop vlookup(A1,Sheet1!A2:D2,3,false) Declaring a variable V for the reference area - just doesn't work. Any ideas...
  4. 01491

    HELP!! Highlight Range using string

    Brilliant - Thanks a lot!!
  5. 01491

    HELP!! Highlight Range using string

    I'm trying to highlight the range from ActiveCell to Activecell+(value in the activecell). Doesn't like: Range(ActiveCell:(ActiveCell.Offset(ActiveCell.Value,0)).select Any help, much appreciated.
  6. 01491

    HELP - filtering dates

    In Excel, I'm trying to find a way of filtering using date variables. I have 'Startdate' as 01/03/02 and 'EndDate' as 31/03/02. I need to filter out all entries in a list between these dates but 'Criteria' within VB does not like "=>StartDate" Any help much appreciated. John
  7. 01491

    Database nightmare!!!

    I have some code that opens up another database (reference db1) Dim appAccess As Access.Application Dim strDB As String strDB = "R:\Rad\RAD Application 97.mdb" Set appAccess = _ CreateObject("Access.Application.8") appAccess.OpenCurrentDatabase strDB This works...
  8. 01491

    Running a module from another database

    Thanks for the tip. I managed to reference my other database, but 'Help' doesn't make it any clearer as to how to run the actual module from the current database. Can you point me in the right direction. Much obliged
  9. 01491

    Running a module from another database

    I'm trying to find some code that will run a module in another database. Any ideas? many thanks
  10. 01491

    Calling VBA gurus - need of Excel-Access interaction

    I'm trying to run an Access module from pressing a button in an Excel file. The module creates a table and then I need it to be exported to the excel file with the button. Any help would be very appreciated!!!!
  11. 01491

    Running an Access module from an Excel macro

    I need some code that runs a module in Access then imports the resulting table into an excel file, preferably by just click a button. Any help? Thanks.
  12. 01491

    Counting using 'build expression'

    That's brill, Thanks mate!!
  13. 01491

    Counting using 'build expression'

    I'm trying to use a textbox on a form that brings the number of records held in an unopened query. The expression =count([QryName]) does not work. Can anyone help me? Thanks
  14. 01491

    Displaying just egg timer when running long multisheet macro

    Perfect!! Thanks.
  15. 01491

    Displaying just egg timer when running long multisheet macro

    Sorry, I'm not quite sure what you mean. Is this VBA code or an option from the menu. Thanks.
  16. 01491

    Displaying just egg timer when running long multisheet macro

    I have a VBA code that does various editing functions over multiple worksheets. I am looking for a piece of code that displays just the opening sheet with an eggtimer instead of having the strobe effect from swapping from page to page. Any offers? Thanks.
  17. 01491

    Need of exporting module - qry to particular sheet in Excel book

    I need somehow to export a query onto a particular sheet in an Excel workbook. This is because I want to export a different query onto a different sheet in the same workbook. I have enclosed the code so far: any help be much appreciated!!! Sub Export() DoCmd.TransferSpreadsheet acExport, 8...

Part and Inventory Search

Back
Top