Search results

Hi all, What could be the reason for A2013 not opening a mde file. It opens the login and splash screens fine but fails when it has to open the main form. It is tough to find the problem since it opens the mdb version fine all the way without any errors. Both the mdb and mde version work 100%...

I agree - A2003 was developed with the Developer in mind and all versions from there on more and more with the End User in mind. Gggrrrr

@Paul and RG - thanks a lot. I'll leave it alone until I really need to change and then go for the routine idea - thanks

Hi all, Found my answer here: http://www.access-programmers.co.uk/forums/showthread.php?t=152839 had to do with overlapping windows

Hi all, I'm busy upgrading from A2003 to A2013. At the moment the FE is converted to ACCDB but the BE data tables it is linking to are still in MDB format. Is it a good thing to also update those (which means I have to go to each Client to do it on site) or is it fine to keep the tables in the...

Hi all, I'm busy upgrading my A2003 app to A2013. So far so good. I managed to hide the ribbon and nav panel. But I noticed that the DoCmd.Restore command is acting up. In the mdb format (in A2013) it does Auto Centre all my forms but in the a accdb format it pushes all forms to the top...

@Rx - thanks for the detailed report. I haven't moved over yet and already missing A2003 :) :)

Thanks a lot!

@Rx - Thanks for the advice. Is importing objects better than opening and converting base to 2013? Also - any advice on the ribbon. Thanks

Hi guys, I have a bit of a strange request for input here. I work for a corporate company but am also a Access developer hobbits in my own time. I started on A2003 years ago and still love that more than the modern versions. I use my company PC for that (well for everything). However the IT guys...

@Doc - thanks for the link. I hear you on the necessity of the file but I also noticed that if I create a new blank db in A2003 then the reference is not tick and not even available to select. You have to actually browse to the FM20 dll file to be able to add it to the list of references (that...

More details just in case: Old files (before replacement) New files FM20 FM20 Ver: 15.0.4420.1017 Ver: 12.0.6025.5000 Product name: MS Forms 2007 MS Office...

Update2: So I took the next step and renamed the system files: FM20.dll FM20ENU.dll When I re-opened my app, it re-installed Access 2003 (or part of it) and during the process I could see it replacing the 2 files so I guess Access really likes to have the files and this is without any Forms...

Update: I deleted every Form and then every Report and then every Module in my app and the ref sticks like mud to a carpet... What on earth could be jamming it

@ Husky - thanks and I agree I'm sure it's a false error code. Nope Clients all run diffrent O/S and Office packages (some with RT and some full Access) and 32/64 combo. The specific Client has 64 I just deleted a progress bar on the form that I 'forgot' I added but it wasn't the problem - could...

Hi all, I have an issue at one of my Clients where my app refuse to open giving some Expression of Timer event on the Form error. I have no idea if I look at the error code as the Form does not even have a timer event. Anyway - the app works fine at all other Clients. I ended up installing a...

@Ranman - thanks for the reply. I very seldom work with Excel and if I do it is never VBA So could you kindly explain the code - maybe just the Shift bit if you don't mind. Also would be greatly appreciated if you could re-post my original code with the changes as I battle to fit it in the...

Hi all Excel Gurus I'm using the following VBA code in Access 2003 to "fix" a spreadsheet by deleting the first 3 rows before I can use it in an Access Query. Is there any reason why the code should not work for other versions of Office. It works fine on my PC running Access2003 and Win7 plus...

@arnelgp - thanks once again for that - it is an impressive piece of SQL string and still a bit baffling. The ordercode and orderdate was swapped around (the result giving the max order instead of the max date) but that gave me an opportunity to edit the string which was great to get it right...

Thanks a lot. Can only check it out tomorrow night but sure it will be what i need. Regards :)