Search results

  1. D

    Creating new form from existing form

    Hi MajP, I deleted the Autoexec and opened the form from the Forms List. I don't think it's an Autoexec problem. I will start to look at how to resolve the problem while retaining the functionality of the MainOptions form. That could be a nice winter project. Dave E
  2. D

    Creating new form from existing form

    I am grateful for the time you've spent on this problem but I think, like me, you like a challenge. I worked on the database last night without a single issue. It was a pleasure to be able to do that, but that only means I've been lucky. I will continue to develop the database and look out for...
  3. D

    Creating new form from existing form

    Hi arnelgp, No change, I'm afraid. MajP, I tried that too without any success. This is real challenge...
  4. D

    Creating new form from existing form

    Hi arnelgp, I see that, but it didn't stop the issues. Thanks for trying though. DaveE
  5. D

    Creating new form from existing form

    I commented out the Load/SetCursor and compacted and compile to no avail - the same issue persists. It is not a consistent bug and, just when you think you've found the problem, it screws you up... Could you explain the second part of your post about using a transparent button on, presumably...
  6. D

    Creating new form from existing form

    Hi MajP, I 'commented out' all references to LoadCursor and SetCursor from the form (the only only that calls the LoadCursor action) and the function in Module1, compacted and compiled it, but the problem persists. The trouble is that the issues happen at, what seems to be, random moments...
  7. D

    Creating new form from existing form

    Hi Pat, Looking back, chronologically, through this thread I see that I had already supplied the answers prior to your questions. Maybe that was why you didn't see them. Thanks for your help. DaveE
  8. D

    Creating new form from existing form

    There are only 2 issues that I can find. The first involves the opening of the form in View mode and then selecting Design View by right-mouse-clicking the form's top bar or anywhere on the open space on the form. In some, but not all cases, the db will close leaving the database locking file...
  9. D

    Creating new form from existing form

    I'm sorry if I missed a question somewhere along the line. Your last 2 questions were answered though; size and whether it was split...perhaps there was a time delay in you receiving the responses. I have compacted the db so many times I've lost count. It was compacted after being reduced and...
  10. D

    Creating new form from existing form

    OK, the db has been compressed down to almost nothing... It should get through Before compressing it exhibited the same problem, as described earlier. I have cut it down, removed a lot of forms/reports/tables/code. I have disabled some of the controls on the MainForm to avoid error messages for...
  11. D

    Creating new form from existing form

    I have reduced the db to a main form with 2 subforms and a few small pop-up forms to show functionality. 2 tables, a few queries, and a fair bit of VBA code. The db is not split. Would compressing the db be worthwhile? DaveE
  12. D

    Creating new form from existing form

    What is the max size allowed for the server? The cut-down db is around 3.7MB. DaveE
  13. D

    Creating new form from existing form

    The database is too large for the server - it says. So I will, tomorrow, cut down the db to just the mainform, subforms, and tables which should provide something to look at and analyse. DaveE
  14. D

    Creating new form from existing form

    Hi Pat, Yes, I tried C&R, in fact I use that function regularly. I have also decompiled/recompiled the database to a new, balnk database several times. I've uninstalled Windows Office 2010 and reinstalled and ensured all updates are in place. Every time I think I've cured the problem, it...
  15. D

    Creating new form from existing form

    How do you compact when the the it's a text file? I compacted before and after the process of changing the form. I didn't export the SQL separately. Wouldn't that have gone through the same process with the text? DaveE
  16. D

    Creating new form from existing form

    Still testing... Exported and imported Text of subform to new form - no change.
  17. D

    Creating new form from existing form

    Indeed, I did. I followed the methods set out in the other thread, along with several other methods found online. The annoying thing is the randomness of the crashes. Sometimes it will and sometimes it won't crash. And there's nothing going on in VBA or queries at the time of clicking on the...
  18. D

    Creating new form from existing form

    It would be difficult to post the db and it work away from its designed environment.
  19. D

    Creating new form from existing form

    Thanks for all your replies. If you read my initial post I asked how to move all objects and code from one form to a new one. The rest of the post was an explanation of why I was looking do it. I have tried all of the suggestions given thus far for my problem without success. Finding that...
  20. D

    Creating new form from existing form

    Hi all, Does anybody know a way to create a new form and move all the objects and code from one form with all its parameters and make a copy in a new blank form? I have an existing problem which appears to be only on the db's main form. I have so far - decompiled, recompiled, compressed and...
Back
Top Bottom