Search results

This is the probelm. You are correct but that doesn't work. What this has done is put identical values in, including 00/01/1900.

=IF(H2,H2,"") Yes, I don't actually understand whats happening but it appears to omit the data I don't need.

OK, I have stuck a formula in the next column along. The IF logic test which I have set to return the value of the date cells in my original column when true and when false return a blank string. This appears to work leaving the cells in the new column that should have had 00/01/1900 empty...

Sorry, I had clocked the typo , the code runs fine it just can not find the date.

The code does not get around the problem. I initially thought is was something to do with the format but tried different settings but no joy. I also tried setting validation on the cells so that date could not be accepted but it is (for some reasons) when the data is first extracted from the...

It is just this date, the data is extracted from a database and the value 00/01/1900 are from fields that have not been filled in. I have put the # # like you said but this now returns a syntax error.

The code is below. Cells.Replace What:="00/01/1900", Replacement:="", LookAt:=xlWhole, _ SearchOrder:=xlByColumns, MatchCase:=False

I have a problem with a macro that finds a date and replaces it with nothing leaving an empty cell. When I record the macro it works fine, however when I run it again on new data it doesnt find the date, even though I can clearly see the date exists. Another strange thing is if I select the...

It can be hard to find what you need, this should help. http://www.fontstuff.com/access/acctut17.htm

I had forgotten about using 2 fields as the PK. I think I may have been looking at the problem too closely to see the answer. Thanks:)

I found if I used too many of these in a query it started to return incorrect data. You would be bettter using VBA to query form data entered onto the form. Although you may be able to use the 'Like' criteria at the beginning of what you currently have.:)

Hi everyone, first time on this site, hope someone can help. I have put it under this title but it may not be possible by this method. I have a problem that I can not get my head around, it is a quiz database that has a table of questions and another table of venues. How can I stop the same...