autofill from unbound textbox (1 Viewer)

saqassemi · Nov 11, 2017

Hi, this is an MS access file that shows pc information, I want after showing the pc information, automatic save cpu serial number in the table if it is empty. If it is not empty check both information cpu s/n and the table value, if they are equal open mainform if not equal open warningform

Note: this works like a lock for my file, when I open in a pc for first time it auto save the cpu s/n to the table. So when the user copy the file to other pcs it shows warning.

if is it possible summrize the codes to show only cpu s/n not all pc information too.

Thanks for your help

arnelgp · Nov 11, 2017

check Module1.
i have disabled the Opening form, instead run an Autoexec macro.
as per your request.

saqassemi · Nov 11, 2017

thanks a lot, but it add a new record. is it possible if the record is empty or is filled with "aa" then change it with cpu s/n and if it is not "aa" check it's value with cpu s/n, if they are equal open mainform, if not open warning form.

arnelgp · Nov 11, 2017

if cpuid = "aa", change it. will i show warning or mainform after changing?

moke123 · Nov 11, 2017

try this one

moke123 · Nov 11, 2017

i'm assuming your using aa as a placeholder record but that is not necessary.
my example tests for a null field and enters the serial number on the first run.
it then does the comparison on subsequent runs.

saqassemi · Nov 11, 2017

moke123 said:
try this one

Thanks a lot, It solved my problem.

saqassemi · Nov 11, 2017

arnelgp said:
if cpuid = "aa", change it. will i show warning or mainform after changing?

Note: this works like a lock for my file, when I open it in a pc for the first time it auto save the cpu s/n to a table (one record as a place holder). So when the user copy the file to other pcs the cpus s/n don't match and it shows warning.

thanks for your attention

arnelgp · Nov 11, 2017

There is much better way than saving to a table. Somebody knowledgeable can delete the record from your table. It is better to save it as property of the database.

saqassemi · Nov 11, 2017

arnelgp said:
There is much better way than saving to a table. Somebody knowledgeable can delete the record from your table. It is better to save it as property of the database.

Is it possible to delete a record from hidden table in an accde file?

arnelgp · Nov 11, 2017

es. Accde only disalloe changes to form, reports, module and table design. But they can delete the record. If they do that, they can run your db to their workstation

Here i made a demo, saving the serial as property of the database.
Run it to your computer then run it to other pc.

In the module, ResetComputerSerial function resets the serial.

No table is involved.

saqassemi · Nov 12, 2017

arnelgp said:
es. Accde only disalloe changes to form, reports, module and table design. But they can delete the record. If they do that, they can run your db to their workstation

Here i made a demo, saving the serial as property of the database.
Run it to your computer then run it to other pc.

In the module, ResetComputerSerial function resets the serial.

No table is involved.

Thanks, It's all I want.

arnelgp · Nov 12, 2017

Goodluck, and btw, the function also works on .accde.

moke123 · Nov 18, 2017

I never played around with the DB Properties but thanks to Arnel's suggestion I experimented and learned something new.

I figured I'd post my experiment to give you another perspective. there is an accdb and an accde in the zip.

saqassemi · Nov 18, 2017

arnelgp said:
es. Accde only disalloe changes to form, reports, module and table design. But they can delete the record. If they do that, they can run your db to their workstation

Here i made a demo, saving the serial as property of the database.
Run it to your computer then run it to other pc.

In the module, ResetComputerSerial function resets the serial.

No table is involved.

Oh no, the properties is changeable by shift key or bypass. would you help me to prevent this file from bypassing. or is it better that the serial, save as a label in a form in place of changing properties.Thanks

moke123 · Nov 18, 2017

the db i posted has a module to disable the bypass. It also has the right click menu disabled on the warning form which is modal.

be aware though that nothing is foolproof. these methods will probably only deter some people. If the really want to get in they will. I believe you are able to access a databases properties from a separate database so take it for what its worth.

isladogs · Nov 18, 2017

Hi moke

Thanks for this - its another feature that I want to add to some of my own commercial databases. Until now that's not been an issue as all apps have been supplied with a site licence.

However, I'm moving away from schools' databases into more general business applications. For one of these (UK postal addresses), I intend to make it available in various versions and for different numbers of computers (e.g. 1, 2, 5, unlimited)

Your example should help me work out how to achieve this for several PCs using db properties rather than saving to tables.

Very wise to warn that no system of this kind is foolproof.
All any developer can do make it as hard as possible for software to be pirated.

autofill from unbound textbox (1 Viewer)

Registered User.

Attachments

..forever waiting... waiting for jellybean!

Attachments

Registered User.

..forever waiting... waiting for jellybean!

AWF VIP

Attachments

AWF VIP

Registered User.

Registered User.

..forever waiting... waiting for jellybean!

Registered User.

..forever waiting... waiting for jellybean!

Attachments

Registered User.

..forever waiting... waiting for jellybean!

AWF VIP

Attachments

Registered User.

AWF VIP

MVP / VIP

Similar threads

Users who are viewing this thread