Recent content by sychoangel

Thanks Namliam - this one worked perfectly also. From a learning perspective - my interpritiation of the formula is : if less than end of this month - 14 months (+1month) then 0 if greater than end of this month - 1 month (+1month) then 0 otherwise 1 & if my interpritation is correct - why...

Hi Anakardian - worked perfectly. I had to replace the ; with , due to my excel 2010 config - but it works well - THANK YOU!

I am running around in circles and not getting anywhere... I am trying to put together a formula that looks at a date & -if the date is in the current month (i.e. Mar 2014) it returns a 0 - if the date is in the last 13 months (i.e. between Feb 2013 & Feb 2014) it returns a 1 - if the date is...

That is very interesting! Have just tried it & it works with cells selected in the named range & not columns. Thanks for your help with this :)

BlahName is the name of the named range I am trying to import.... as I only need to import specific columns and not the entire tab....

hi vbaInet... That didnt work either. When running that code I get Run-Time error '3125': 'BlahNames$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is now too long. Have attached a moc up of the 2007 db/2003 ss if anyone wants to look...

A week later & I'm still no closer to resolving this!!! not happy :(

This is a bizare one that I cant seem to find an answer for... I have an excel 2003 file (users dont want to change it to excel07) that needs to be imported into an access 2007 database. When I try importing it using from the quick access tool bar : External Data Tab > Import > Excel >...

Thats Wonderful & Easy :) Thankyou very much for your help!

Hello, Firstly i'd like to say : Thank God this site exists - reading through posts has helped me soooo many times I need some help with Counting unique Records and showing total in Header (not Footer) [Access 2007] My report is grouped by TicketNo and each ticket can have multiple...

Hello, I have a report that has about 50 fields... I need any fields that have been left blank to be shaded. I am able to Set a field to shade grey by going into conditional formatting: Expression Is IsNull([FieldName]) And select Grey from the paint bucket Is there any way to do...

Thanks guys! Replace([TITLE],"{",Chr(13) & Chr(10)) worked perfectly :) I did try the other ones perviously, but they didnt work... thanks for letting me know why.

Hello! I have created an update query that finds characters in a column and replaces them with something else... e.g. Field: TITLE Table: DETAILS Update to: Replace([TITLE],"{","") That all works ok... but how can I do an update query to replace a character with a carriage return... I...

Hello J I’m using Access2007… I have a Database with 2 tables... One is where the primary information is stored, and the second has a list of reserved IDs. I need to set up a form where based on the values of the first 2 fields , it will look at the second table & find the next available ID...

Thankyou for that :) is there are reason why you recommend the API instead