Replace In Ms Access' title='Replace In Ms Access' />John. Lute wrote in message news f. Im wondering if Ive been clear or if Im not following your train of thought. The swapping of subforms works just fine as youve tested and observed. Yes the problem seems to be that the subform MUST be loadedat the time. After Update Event of the control in the main form is executed. So I think were on the same page. So what youre syuggesting is to check sfrm. Ctl prior to this And Formsfrm. Finished. Goodssfrm. Ctl. FormUnit. Count 0 Or Formsfrm. Finished. Goodssfrm. Ctl. FormSub. Ms Access In ClauseUnit. Keygen Generator. Count 0 I believe this is the problem line and not the other two lines that I previously thought. This line occurs first and I think its whats tripping the error. Sql In Ms Access' title='Sql In Ms Access' />enspenspSometime ago I wrote a VB6 program to launch the correct version of MS Access, depending on what version a file was made with. The program grabs all the MS. Adobe Pdf Excel Converter'>Adobe Pdf Excel Converter. No These are the conditions 1. If theres no child record in the subforms recordset then we dont need to do anything. If theres a child record in the subforms recordset then we need to. Unit. Count and Sub. Unit. Count accordingly. So I guess that this is first a recordset check and then a loading and navigation to the subform if condition 2 occurs Thats not exactly what I meant, but it does introduce an extra possible issue. Here are the circumstances I can think of, though maybe some of them. At the moment this code executes that is, when the. Status combo box any of the following might. The Source. Object property of sfrm. Ctl is blank, meaning no subform is currently loaded into it. The Source. Object of sfrm. Ctl is not blank, but the subform currently load into it is not the one that your code is trying to act on its some other. Unit. Count and Sub. Unit. Count. 3. The Source. Object of sfrm. Ctl is the one you want, the one containing Unit. Count and Sub. Unit. Access cant create MDE File Ive tried everything I think I am getting the error message that Access cannot create an MDE File. Introduction to the Access 2007 file format. This format takes the place of the. Access. I have just installed Access 2010 and when I try to open a database from Access 97, an error comes up You cant covert or enable and MDE file. Is this database not. Install Toilet Tank Bolts Diagram Of Ear. I have created a database consisting of 12 tables, 14 forms, 4 queries, 12 reports, 2 modules. Each form contains minimal VBA code. I have split the database. MSFSVCA File Set Version Comparison Algorithms. MSRRASM Routing and Remote Access Server. MSMDE since it was. Count, but there are no records in the subform. Its up to you to say, which, if any of these conditions could ever possibly. Can you identify one of them. Or is there some other. Your code can be amended to check for any and all of those conditions, but theres no real point in adding protective logic for something that couldnt. Thats why Id like to know exactly which conditions are. Dirk Goldgar, MS Access MVP. Access tips www. For Some reason Sounds like the guy that made the mdb file as an mde, FORGOT to back up the mdb files. Find that guy and see if he has a back up somewhere. Hi, Probably a stupid question, but is there any way to access the code behind forms e. We dont have an original copy of the. Mde File In Ms Access' title='Mde File In Ms Access' />An MDE file is a Compiled Access Addin file. Learn how to open an. MDE file or convert an MDE file to MDB, EXE, or some other file format. How to convert MDE file to MDB enter image description here I cant change design the form because design view is disable.