If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Ck a new version
Hi,
I'd like Access to point to a folder when a file version has changed so I came up with this: If Nz(DLookup("[Version]", "[fileversion]"), "") = "20061211" Then Me.Visible = False Else strMsg = "There's a new version. Would you like to dnload it?" If MsgBox(strMsg, vbExclamation + vbOKCancel, "Ck Version") = vbOK Then ....XXXX DoCmd.Quit End If When OK is chosen on the msg box, I'd like the folder \\server\access\newfile.ade to open so that the user can dnload the new version while access is shuting down (DoCmd.Quit). HOWTO? TIA Gil -------------------------------------------------------------------------------- Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados. Ha eliminado 1019 correos spam hasta la fecha. Los abonados no tienen este mensaje en sus correos. ˇPruebe SPAMfighter gratis ya! |
#2
|
|||
|
|||
Ck a new version
Why not simply use the Auto FE utility Tony Toews has for free at
http://www.granite.ab.ca/access/autofe.htm ? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Gil Stone" wrote in message ... Hi, I'd like Access to point to a folder when a file version has changed so I came up with this: If Nz(DLookup("[Version]", "[fileversion]"), "") = "20061211" Then Me.Visible = False Else strMsg = "There's a new version. Would you like to dnload it?" If MsgBox(strMsg, vbExclamation + vbOKCancel, "Ck Version") = vbOK Then ....XXXX DoCmd.Quit End If When OK is chosen on the msg box, I'd like the folder \\server\access\newfile.ade to open so that the user can dnload the new version while access is shuting down (DoCmd.Quit). HOWTO? TIA Gil -------------------------------------------------------------------------------- Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados. Ha eliminado 1019 correos spam hasta la fecha. Los abonados no tienen este mensaje en sus correos. ˇPruebe SPAMfighter gratis ya! |
Thread Tools | |
Display Modes | |
|
|