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
=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
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
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...
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 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...
Can anyone advise how I could, by giving a date find the start date of the year. For example:
Date Result
30/06/2010 01/01/2010
14/12/2008 01/01/2008
Probaly simple!!!!
Thanks in advance.
Hi
I am using the SQL statement below with a variable which changes via a loop, can anyone advise where the SQL is incorrect as I get an error.
DoCmd.RunSQL "UPDATE" & myvar & "SET" & myvar & ".LOB = 'MOTOR'" & _
"WHERE (((" & myvar & ".LOB) Like '*mot*'));"