Creating new form from existing form

[Dave E]

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 any more problems.

As far as I can tell, I have restored the db to the state before I submitted it, i.e. API working and code as original.

If it re-occurs then I will think about changing the MainOptions form design to simplify its operation.

In the meantime - thanks again for your input and time. And Pat's.

DaveE

 

[arnelgp]

i delete the autoexec macro where MainOptions form is being opened.
instead i use it as the Startup form.
i haven't encounter any crashing since.
for you to test.

 

[MajP]

@Dave E and @arnelgp,
I tested @arnelgp version and it seems to be stable. If the only difference is the Autoexec then I am even more baffled why that is. I have never heard of any autoexec issues.

 

[Dave E]

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

 

[MajP]

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.

Was that last version stable for you? If so then you probably can readd the pointer code. If it is fixed I have no idea why.

 

[Dave E]

Was that last version stable for you? If so then you probably can readd the pointer code. If it is fixed I have no idea why.

The version from arnelgp seems to be OK. I have been using it normally with no failures.
Last night, I started to gradually remove some of the changes arnelgp made to see which may have made a difference. Still functioning well.

I will post a fuller report toarnelgp shortly.

Thanks for your help. It has been constructive.

Dave E

 

[Dave E]

i delete the autoexec macro where MainOptions form is being opened.
instead i use it as the Startup form.
i haven't encounter any crashing since.
for you to test.

Hi arnelgp,

The good news is that I have had no further problems with the database.

I took the modified db from you and -

Removed all of Module 2, reverted to OpenForm (Maximise) with all previous property settings for the form.
Added back all the tables, forms, queries and reports that I removed prior to posting it to the forum.
Left the startup for MainOptions as you demonstrated.
Left the mods to the PlantList subform - it seemed better than my version.

I still have no idea about the cause of the problem but I'm grateful to have the database working in a way that doesn't make me cringe every time I steer the cursor towards the Design View option.

Thanks for all your help. I would describe your help as cool, calm, polite and professional.

Kind Regards

Dave E