Recent content by 01491

Fantastic !!! Thanks very much.

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

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

Brilliant - Thanks a lot!!

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.

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

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

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

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

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

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.

That's brill, Thanks mate!!

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

Perfect!! Thanks.

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