Normal Topic Locked Q&A 4.0 database (Read 9252 times)
jfreeman
Member
*
Offline


No personal text

Posts: 23
Location: KZN, South Africa
Joined: Apr 10th, 2005
Locked Q&A 4.0 database
Feb 13th, 2020 at 10:55am
Print Post Print Post  
Like many another, I have converted most of my old Q&A databases to Sesame 2.6, but the biggest macro-connected suite of 5 databases have so far defeated me.
Unfortunately they are my financial records - shareholdings, share dealings, income, holdings history and bank statements.
Yesterday I had a macro malfunction and I am locked out of my bank statements (password changed by the macro).
Can anyone help?  And it is urgent!  Tax year ends in a few days.

With thanks for even a glimmer of light!
John Freeman
  

John F
Back to top
 
IP Logged
 
jfreeman
Member
*
Offline


No personal text

Posts: 23
Location: KZN, South Africa
Joined: Apr 10th, 2005
Re: Locked Q&A 4.0 database
Reply #1 - Feb 13th, 2020 at 4:12pm
Print Post Print Post  
The macro that misbehaved (probably finger trouble) was one that captured four pieces of entered data to be inserted into a bank transaction, then automatically entered these, inserting the correct folio number for tax purposes.  After thinking about it, I realised that one of those data entries was probably now the new password.
I was right - it was the amount of interest from a savings account, to wit 409,51.  So then I was able to use that to change the password back to the original so that the macro suites would work again.
Huge relief!

John Freeman
  

John F
Back to top
 
IP Logged