Search results

tried what u suggested but only gave '#Error'. Just to emphaisise, i want to get a total number of Ref nos where status is A or B.

Hi, Im trying to ammend this, will be simple i know but my sum isnt working. I want the following count to ALSO include values where Status = B. =DCount("[Ref_No]","Old","[Status]='A'") I tried =DCount("[Ref_No]","New","[Status]='A' " AND "[Status ='B']") but shows a number that doesnt...

KILL solved the problem though dunno why, oh well Thanks guys :)

And when thats not the reason it wont delete?? (yes i tried >.>)

Hi, When i run a piece of code to run through subfolders finding files that arent named after the subfolder, and delete them, i hit a problem. An error says 'permission denied' when it hits this line, BUT if i then open the file, close it, then run again, it will delete it :x For...

Some of the cells contain more than just the afformentioned line, and i didnt mention that this counted for aa1242 '01_Access/aa1242 (Name)' where as the first is still '01_Acccess/aa12' Could this be causing an issue? aa12 does not contain a psace in front of it, as to your earlier...

Sorry guys!! thought i had already posted that id finished it :x position = InStr(26, strLineOfText, ";") endLine = position - 26 If Trim(Mid(strLineOfText, 26, endLine)) <> "" Then

Morning, Looked straight into this and had a browse around and found solutions which involve forms and buttons but none that assume the form is just one screen / record. Now ive looked at someones tool and theres DOES print one record, im assuming this is in the properties of the form or...

is it not possible to force a single print?

Hi, When i put the print screen view on a form ,the form seems to multiply, making it go for pages and pages and pages showing the exact same form and i cant see why :x

If its correct in that i should use xlWhole, then somethings wrong with my code as it returns NO on nearly every string it searches for / leaves me at a dead end :(

Hi, thanks for putting the time in to help. I took your advice and it told me what i knew really :x Range S searched for value: '01_Access/aa12' Range S value Found: '01_Access/aa1242' Range S searched for value: '01_General/aa1242' Range S value Found: '01_Access/aa1242' Surprisingly...

Sub mappingReference() On Error GoTo ErrorHandler: Dim ws As Worksheet, SheetNames() As Variant, oneSheetName As Variant Dim seekForCell As Range, foundCell As Range Dim newCount As Long, Count As Long, LastRow As Long Set ws = ThisWorkbook.Sheets("Fields Mapped & Not...

Tried but to no avail, even lookat:=xlpart didnt work right. Your solution just returned NO for nearly everything :( If Not foundCell Is Nothing Then ws.Cells(newCount, 5) = oneSheetName Else ws.Cells(newCount, 5).Value = "No" Ive tried making it so it needs to abide by the length of the...

Hi, I have a problem with a line of code which checks against 2 cells and searches for it in all the worksheets in the workbook which works fine in the most case however, it seems to be looking for a likeness, not the exact value. Set foundCell = .Range("S:S").Find(what:=ws.Cells(newCount...

inStr might have saved me an extra line of code than if i wanted to do with SPLIT as i needed the position of a character created for mthe split. Thanks for both your help though :)

97 ^^; would explain something as i have it working on 2000. Is there a work around?

Hi, starting to pull my hair out over this one now, i really have no idea whats wrong with it. Im trying to use a split function (even a stand alone one which should 100% work) yet still come up with an error. One ive taken from this board to test im not doing wrong and is standalone: Dim...

the plsit isnt working, and tbh i dont understand why not as ive used the exact same thing elsewhere. Dim strArray() As String strArray = Split(strLineOfText, ";") it keeps saying that the sub or function not defined (for Split) changed it to variant and still doesnt work :x

sorry i should have specified the data more. The text fiel thats being read has (for example) ABC;JOHNS;27 MAPLE ROAD; So i want to pick up the second occurance (will always be the second occurance, always starting at position 5) but i dont know how to include the 5th position start...