How do I update a form via e-mail

[ptaylor-west]

I have changed an input mask for one field on a form. I need to know how do I send this as an update in the form of an e-mail attachment.

I also need to know exactly what the recipient needs to do to apply the update.

Normally I just import the update from one database into another but this is different as I cannot get the whole database sent to me and it would be very time consuming for multiple sites to complete.

I would preferably like an automated solution such as building a self extracting zip file or similar.

All contributions will be gratefully received.

 

[ptaylor-west]

Thanks for the link but it is too expensive @ 500$ for my meagre funds. I will look at the fe/be structure but I would still like to know how can I send just an update or addition for say a report or form that could be imported by a self executable file.

 

[John.Woody]

Totally agree with Pat. You need to go the fe/be route. You can then test the fe where you are and know that you havn't missed anything out. Also if their data entry isn't what youv'e expected then that could lead you up a wrong path. In the short term you could use an access db and transfer database.

DoCmd.TransferDatabase acExport, "Microsoft Access", a, acForm, "FromFormName", "ToFormName", False

If you used Winzip self extractor you could get them to unzip the file which would then autorun and as you open the main form you could run the code to import the form. May be not as clean as a straight forward exe but an alternative. Of course nou need not use the exe, you could just email the db with just a couple of forms it shouldn't be too big.

HTH
John

 

[ptaylor-west]

Absolutely spot on - both ethe idea for a fe/be and the Transferdatabse method. Thanks your advice and help is greatly appreciated