Search results

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...

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...

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...