Is it possible to code an 'automatic restart' (F5) after a breakpoint

[AJParkinson]

Is it possible to code an 'automatic restart' (F5) after a breakpoint - preferably without the user seeing the VBA code windows?
This is in relation to my earlier post -

http://www.tek-tips.com/viewthread.cfm?SQID=817814&SPID=705&page=1

as a coded pause does not appear to solve the problem.

 

[smedvid]

Perhaps issue a Compact command to Compact and re-open? htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[AJParkinson]

Thanks for your reply smedvid, but not to sure that would help - "Compact command to Compact and re-open" forgive my ignorance but do you mean as in the entire DB?
If you do, then only if it can be done litterally within a second or two and then repoen to the exact same spot, forms, variables and all - I'm guessing that couldn't be done, or could it???

 

[smedvid]

Well... perhaps I don't understand the requirements. Seemed you wanted a ReStart. However, it can be accomplished provided you design your system to track the user's location and record position in a table. Then upon start up take them to that form and record.

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[AJParkinson]

Hello again smedvid, no not a complete restart of the database - just restart the code running again.

In brief from my other post:
Form2 opened from Form1,
Value form unbound 'sum' field to be passed back to Form1,

...Form2.field.Value always passes a 0 (zero) value back.
if I put a breakpoint in on the '.setfocus' statement immediately before the Form2.field.Value, the code breaks as requested, F5 to continue and the value passed is correct ie not 0.
or
...Form2.field.text always errors with type mismatch.
if I immediately press F5 to continue and the value passed is correct ie not 0.

I could do as you suggested, it would involve some major recoding on all forms etc, and if I can't find what I'm looking for, well maybe...

 

[AJParkinson]

Hello again smedvid, no not a complete restart of the database - just restart the code running again.

In brief from my other post:
Form1 opened,

Form2 opened from Form1,

'sum' field calculated,
Value from unbound 'sum' field to be passed back to Form1,



...Form2.field.Value always passes a 0 (zero) value back.
if I put a breakpoint in on the '.setfocus' statement that's just before the Form2.field.Value, the code breaks as requested, if I immediately press F5 to continue and the value passed is correct ie not 0.
or
...Form2.field.text always errors with type mismatch.
if I immediately press F5 to continue and the value passed is correct ie not 0.

I could do as you suggested, it would involve some major recoding on all forms etc, and if I can't find what I'm looking for, well maybe...