Search results

If you're looking for the actual month text to be the value of the cell use; =TEXT(TODAY(),"mmmm") So for today, the value of the cell would then be the text; "August".

:o I feel a wee bit daft now. That was a really simple solution and did in fact do the trick! You are officially a genius, thank you!! :D I'm going to go bang my head on a brick wall for a bit, try and knock some sense into me!!! :p

I know this error is well covered ground but all the solutions suggested have not worked and it's driving me to distraction!!!! :( I've created a form that allows a user to select a date from a combo box and a colleague from another combo box then click a button which builds a filter string...

Yeah it would be one or the other when searching but that's ok I can work with that. Thanks for you help guys, I was curious about the space issue using this method but if you guys say it's fine I believe you! ;) Finally I can finish off this database, it was starting to feel like I was...

Yeah I did think about doing that too, but that would mean that every record is going to have two empty fields. Technically it wouldn't hurt the operation of the database but would it not waste space?

Thanks for the reply, but it's not the Description field i'm having the problem with. I am actually doin that the way you suggested! :) It's with the StartDate and EndDate fields, on some records it'll be fine as they will be dates. However on some records they need to be just numbers, a...

I tried looking but to be honest i'm not sure what i'm looking for, other than advice that is!! ;) I'm designing a database to log details of boxes sent for storage. Users need to be able to enter details of new boxes and search existing data to request them back from storage. My main data...

Not sure about DOS commands but for what you say youre looking to do then this should be all you need: http://msdn.microsoft.com/en-us/library/d6dw7aeh(VS.85).aspx ps My first post ever!! :)