Search results

Hi I have field with data such as: YORK, @ YO17ET@ CHELMSLEY WOOD, @ B376RH@ DUDLEY, @ DY11NT@ I want to extract the data between the two @, for example: YO17ET B376RH DY11NT Can anyone help!

Hi Brian Both formulas work great. I am using the sumproduct because I need to identify certain criteria from a data export, and the indirect allows me to identify year to date data from a previous year for comparison.

Hi =SUMPRODUCT((A12:INDIRECT(Current!$AA$1&Current!$AA$3))) I am using the above formula to sum a range the Current ref being the end point IE A20. This works great if the A12 is the current sheet, but if I use the formula below it errors, Previous being another Sheet. Can any one help...

Hi I am trying to get the formula below to work with out success. The M Summary is the sheet where the value is I want to bring back and the Current is where the cell reference is for example L68. Can anyone help! ='M Summary'!&INDIRECT(Current!$AG14) Thanks in advance.

Hi I am tryingto use the code below to update the Named Range Excel but it errors, can anyone advise why! ActiveWorkbook.Names.Add Name:="NOT", RefersToR1C1:= _ "=OFFSET(Extract!$BE$1,0,0,MATCH(" * ",Extract!$BE:BE,-1),1)"

Hi I have data in a table which I want to create a string from. There is a unique number ie SAuto. Number SAuto 03/10/00/00001 23 1323213213313 23 4165468468465 23 So I want the string to be: 03/10/00/00001 - 1323213213313 - 4165468468465 Any ideas, I think...

Hi The validation is on the form.

Hi I am trying to get a Validaytion rule to only allow three letters followed by seven numbers, for example ABC1234567 Can anyone advise as I cannot work out how to do this! Thanks in advance.

Hi Can anyone help... I want code which will open a BO document and then run code in the BO document, all this from Access... Thanks in advance.

Hi Does anyone no how to Maximize Lotus Notes with VBA when the view is Minimized.

Hi I am using the code below to import data from access, unfortunately the code does not recognise the variable 'FindFile' in the 'ODBC;DSN=MS Access Database' section of the code, can anyone advise why!!! Sub MEU_AccessImport() Dim FindFile As String FindFile = Left(ActiveWorkbook.Path...

Is it possible to export query data in access to a specific cell in a excel workbook, tried searching not having much luck!

Hi Does anyone have code which will identify the current path of links I have in a excel sheet!

In a query I get results like: 916576.15 3230200.86 I only want to show thw values as £000s, for example: 916 3230 Can anyone advise!

Hi I am using the code below to look at a table to identify a sub name in a module that I want to run, but I get an error message saying Compile Error, expected sub. It looks like it is something to do with the sub name variable as I am using String. Can anyone help! Sub Update() Dim rNames...

I am using a loop procedure to Call other subs Set rsNames = CurrentDb.OpenRecordset("SELECT tblReportProduction.[Report Name], tblReportProduction.[Sub Name], tblReportProduction.Available, tblReportProduction.AutoNumber FROM tblReportProduction WHERE (((tblReportProduction.Available)=Yes));")...

Hi I have two query's in Access, I want to export the data from both query's to one sheet in excel. Is this possible!

Hi I am using the code below to create variables for us in a SQL statement. I am having problems as the strInList variable will be like (*) using the code below instead of Like "*" which is what I need, can anyone advise! strLike = "Like" strStar = "*" strInList = strLike & strStar

Hi I am trying to use a = symbol as a variable in some SQL code. Current code: ((tblData.[LINE OF BUSINESS]) = '" & strLOB & "') Updated code: ((tblData.[LINE OF BUSINESS]) '" & strSymbol & "' '" & strLOB & "') Can not get it to work, any ideas!

Hi I am using the code below to idntify minus figures, the code does not pick the minus figures up, any ideas why! Function IncurredBand(Incurred) Select Case Incurred Case -1 To -500 IncurredBand = -500 Case -501 To -5000 IncurredBand = -5000...