Recent content by BahBah

I think I have found the problem. For whatever reason after I had closed my access application I noticed an MSACCESS instance still running in Task Manager. When I killed it, access starting prompting me again to save changes. Weird.

Hello I have not used the SetWarnings command in any of my code. Whenever I modify a form, or anything, in my access database it no longer asks if I would like to save the changes and instead just saves whatever I've done. How can I turn this back on please ? I have already tried creating a...

Hello Thank you for your reply. I have found the problem. I am on a network and the person who shares my default printer had his PC turned off. Access must have been checking to look for the printer as it wasn't available.

Out of the blue and at rare times in the day my access reports seem to take 10-15secs longer to load than normal. I use linked tables if that is relevant. If I run the queries manually they are fast, which makes me think it must be something to do with the reports themselves and not their...

Hello I'm guessing there isn't but thought it prudent to ask before starting, is it possible to automatically "upgrade" the style of forms created in Access 2000 to Access 2007 please ? Thank you

Thanks for your help ;)

Lastly, and I guess this is MSSQL specific, does BETWEEN include the start and end dates ? So BETWEEN(01/01/2009 AND 01/30/2009) would include anything on the 1st and the 30th ? And whilst I take your point re: US date formats, SQL appears to save in UK format. Is it access that has the...

Thank you for your very helpful replies :) I used SELECT * just as an example to my issue, however I too also read somewhere, and it may have pertained only to MySQL (although I doubt it), that SELECT * was often faster than specifying field names. I always thought it was faster with field...

Something like this ?: dateadd("m",1,Date()) - Day(date()) = last day of the current month Yes I did edit my post as it dawned on me whilst I was rereading my post that I understood how the Date() - Day(date()) + 1 worked. Thanks :-)

Thank you for the welcome and replies :) How would I get the last date of the month using a similar method ? or better still the first day of the next month ?

Hi My database is linked to SQL server using linked tables. I am trying to move some of my queries to being passthrough queries for efficiency and speed. I am trying to do this primarily for combo boxes, and for reports. Can passthrough queries deal with the access date() function ? eg...