Recent content by leolanza

Sorri DCrake, been a long day!!

Thanks Drake, i will test it and get back to you!

Thanks for your assistance I placed the code in and got an unexpected message 'Compile Error Expected Variable or Procedure, not Module' I placed the code in teh Command_Click of the event button. Should I have placed it somewhere else?

Hello everyone and thanks for reading this. Im developing a database and theres one part of it i seem to be seriously struggling on as im new to VBA. My system as a login that is hard coded into a form and draws from a query in the database. What i would like to do is declare a global...

Thanks Im going to have a look at this when I get home tonight. I will post the results. Many thanks to all of you who have spent the time on this. Leo

THis seems to be the case, if i add test data for february and change the system date to January the query works fine. However if i the next month also involves a year change it just throws up a problem and doesnt select anything. The problem with the month function is that it only returns an...

Thanks for that It does work but i need to to look automatically at the next months forecast. Leo

Sorry Bob Ive added the criteria as specified but it supplied the exact same result. Im going to try playing around with it some more and hopefully with some luck get better results. Leo

Thanks I will try that later tonight Doesnt the dateadd function just add date values to fields though. I will test it and post the results.....thanks again

Hello I have been attempting to solve this problem for about 2 days now and need some assistance. The query I am developing requires furturistic forecasts that are placed manually into a date field(shortdate). I am using the month() function to automatically take todays date, find todays month...