Quit program

G

Gary Dikkema

I have a table. I want to terminate Access if a value in the table exceeds a
certain value.

Can this be done?

Gary D
 
L

Lynn Trapp

Gary,
First, no, it can't be done via the table itself. Second, I guess I need a
bit more information about what you want to do. Are you saying that if a
user enters a value that exceeds your target value you want Access to shut
down? Do you want to give the user the opportunity to correct that value
before you injudiciously boot them out of the database?
 
G

Gary Dikkema

Hehe! I am NOT that frivolous. I should have explained my reason for booting
people out though.

I have an application and I want the application to expire based upon an
event that happens in the processing. You could look at it and say, after X
uses the application will NOT run.

I want to ensure I get paid. This WILL all be spelled out in the EULA and
Contract... but one can't be too careful.

So no, I want the user to get a pop-up saying Problem, Contact Developer and
a phone number. And then acquiescence.

A usage table would hold a count; a macro could be used to Quit if the count
exceeds a certain criteria. I just can't seem to tie the two together in my
head.

Thanks!
 
G

Gary Dikkema

Not sure this is a security topic...

However, now that I've Closed or Quit the application how do I compact the
database?

Turning the Option on somehow doesn't do it. It does for my Dev system but
not my Distr system.

Not sure why they're diff except that the Dev system I log on as the Admins
user and Owner.
 
G

Gary Dikkema

How do I get a Macro to run when the database opens... I am using the
builtin Switchboard. I need to verify the invoice has been fully paid BEFORE
allowing someone to continue using the application. I have everything else
done... presently, they can NOT update anything... but... they can list and
report on existing information. They could then export content and import it
into their own 'vehicle'.

I thought DISALLOWING everything might be more persuausive.

Will I be 'able to break in' using the shift-bypass in my Dev system?

Sorry to ask if this has been asked and answered already!

Gary D
 
G

Gary Dikkema

And sometimes we do locate the answer first.

Onload of the Switchboard seems to do the job...
 
L

Lynn Trapp

You can either create a macro called Autoexec or, else, put a call to run
the macro in the Open event of your Switchboard.
 
G

Gary Dikkema

Didn't like it in Open...

Also, the value I use to test 'lock out', gets altered during a process
invoked from the Switchboard menu... is there a way to re-invoke the macro
to test this? Wondering... not a big deal; I have some other traps to check
for this condition... just wondering.

Thanks!
 
G

Gary Dikkema

Didn't word the question too well...

What I mean to say is that if the value changes during events while running
the program the load on opening of the Switchboard wouldn't be invoked...
it's not recursive and doesn't know that the value has changed... just
wondered if there was an event for switching from a submenu back to main
menu. I would tie the run macro to that... I do have some backup tests that
will kill the program otherwise...

Pretty dang good if I say so myself!

Had a lot of help from the friendly folks here...

Thanks again all!

Gary D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top