Hi, I have an access 2003 program that I’m currently working on that I intend to place on the Internet for sale. I plan on selling it with the option of upgrades / add-on forms
My question is what would be the best way to insert these upgrade/add-in forms into their remote database.
One of the add-in forms will be a contract/proposal form that will be custom made per company, In that it will be capable of inserting there logo, slogan and any specific text Company name. In order for me to able accomplish this I will need to have the client email me their logo text etc. so I can place it in their new contract/proposal form.
Is it possible to have this registration form activate instructions/code that would place the new form into their database by overwriting their existing form or change the command button procedure to point to this new working add-in form?
How the process would have to work:
- Once they purchase this add-in form contract/proposal and their credit card clears they would down load both the activation number and the new form, called contract/proposal, (after the new form contract/proposal has been updated with there specific requirements: Logo, Company name, address etc.)
The they will enter the activation number into the registration form in there program and click done this command button (Done) would have instructions/code to place the new form in their program by over writing the existing demo form contract/proposal or change the command button procedure to point to this new working add-in form contract/proposal? All other objects and code would already be in the their database.
All other forms would not need to be downloaded (only this contract/proposal form,) these other working forms would already be in there program I could just have them activated by changing the on-click procedure code instruct the new add-in form contract/proposal to open and not the demo form that it was opening, So I could use the same command button named contract/propsal form.
The reason I want to have these demo forms in the basic database they purchased is so they will be able to view the forms in a very basic version, which may temp them into purchasing the new working versions of the form.
More specifically what I need to have done to make this work is:
On my registration form will be 2 labels named (Contract/Proposal) and (Tile) with 2 text boxes next to them named (txtcontreg) and (txttilereg) with command buttons next to these.
Each text box and command button will have a specific registration number associated with it, once the user enters this registration number it must compare it to its associated number if they match it will fire the code/instructions specific for this form.
In the case of the contract/proposal form the code/instructions (possibly put in a module) will have to find the form that was downloaded and place it in with all the other forms in the database by overwriting the existing demo form, (if it does not over write this existing demo form then it will need to change the command button to point to this new down loaded working form,) or it will need to be named the same name as the demo form so the command button that opens the demo form called contract/proposal will now open this new updated working form.
Alternative way this could work, not use this registration form in the case of the contract/proposal form and use an install program.exe that will install this new working contract/proposal into there database by over writing there existing demo contract/proposal forms or change the command buttons onclick procedure to point to this new downloaded working contract/proposal.
I apologize for the detailed explanation and repetitive examples, I’m just not sure that I will be able to accomplish this my self so this helps me to have to describe exactly what needs to be accomplished, in case I have to use a 3rd party to help accomplish this.
Any suggestions and advice to help to accomplish this will be greatly appreciated.
Thanks--Experts
My question is what would be the best way to insert these upgrade/add-in forms into their remote database.
One of the add-in forms will be a contract/proposal form that will be custom made per company, In that it will be capable of inserting there logo, slogan and any specific text Company name. In order for me to able accomplish this I will need to have the client email me their logo text etc. so I can place it in their new contract/proposal form.
Is it possible to have this registration form activate instructions/code that would place the new form into their database by overwriting their existing form or change the command button procedure to point to this new working add-in form?
How the process would have to work:
- Once they purchase this add-in form contract/proposal and their credit card clears they would down load both the activation number and the new form, called contract/proposal, (after the new form contract/proposal has been updated with there specific requirements: Logo, Company name, address etc.)
The they will enter the activation number into the registration form in there program and click done this command button (Done) would have instructions/code to place the new form in their program by over writing the existing demo form contract/proposal or change the command button procedure to point to this new working add-in form contract/proposal? All other objects and code would already be in the their database.
All other forms would not need to be downloaded (only this contract/proposal form,) these other working forms would already be in there program I could just have them activated by changing the on-click procedure code instruct the new add-in form contract/proposal to open and not the demo form that it was opening, So I could use the same command button named contract/propsal form.
The reason I want to have these demo forms in the basic database they purchased is so they will be able to view the forms in a very basic version, which may temp them into purchasing the new working versions of the form.
More specifically what I need to have done to make this work is:
On my registration form will be 2 labels named (Contract/Proposal) and (Tile) with 2 text boxes next to them named (txtcontreg) and (txttilereg) with command buttons next to these.
Each text box and command button will have a specific registration number associated with it, once the user enters this registration number it must compare it to its associated number if they match it will fire the code/instructions specific for this form.
In the case of the contract/proposal form the code/instructions (possibly put in a module) will have to find the form that was downloaded and place it in with all the other forms in the database by overwriting the existing demo form, (if it does not over write this existing demo form then it will need to change the command button to point to this new down loaded working form,) or it will need to be named the same name as the demo form so the command button that opens the demo form called contract/proposal will now open this new updated working form.
Alternative way this could work, not use this registration form in the case of the contract/proposal form and use an install program.exe that will install this new working contract/proposal into there database by over writing there existing demo contract/proposal forms or change the command buttons onclick procedure to point to this new downloaded working contract/proposal.
I apologize for the detailed explanation and repetitive examples, I’m just not sure that I will be able to accomplish this my self so this helps me to have to describe exactly what needs to be accomplished, in case I have to use a 3rd party to help accomplish this.
Any suggestions and advice to help to accomplish this will be greatly appreciated.
Thanks--Experts