Recent content by Nick Booth

I have two .mdb files. db1.mdb contains the tables which are linked to db2.mdb. This second .mdb contains the queries, forms etc. I tried to open db1 from db2 using OpenDatabase and got a run time error saying that I did not have suitable permissions. I am baffled because I have the same user...

Thanks for the helpful suggestions folks.

I can't get the Year function to work. Month and Day both work fine and code completion works with them but when I type Year( no code completion hint pops up. If I complete the function it always produces a run-time error such as type mismatch as if the year function did not exist. Can anyone...

Thanks MHM. In fact I knew this already but want the column widths to be set from code to make life easier for some of my more technophobe users.

I have written code behind a form to create acrosstab query and run it. I want the code to set all the column widths to best fit. Can it be done? I have used SendKeys to select the columns and DoCmd to open the format columnwidth dialog but the dialog won't accept SendKeys input to 'click' the...