Search results

thanks alot work fine.

thanks Sir, it was working fine. but what if there is no attachment get error message in "Kill sFile", can you please advise how to avoid as i want if no attachment then proceed.

HI; this work fine but it does not attach the file. as the form ID is linked with subforum. can you please advise how to solve it. thanks

" If Me.Documents.Form.Recordset.Fields("Sigend_Form").AttachmentCount > 0 Then"

Dears; I need your kind support to modify the below to get the attachment from subforum in maniform. Main form = Holiday_Dialysis Subform = Documents attachment filed = Sigend_Form as i get error in " If Me.Documents.Form.Recordset.Fields("Sigend_Form").AttachmentCount > 0 Then" the...

can you please help for attached file.

Yes its in report view but when copied the code got error: " Syntax error" If Me.Recordset.Fields(Me.Sigend_Form.AttachmentCount > 0 Then

HI: what if i want to place the button in Report and upon click do the same for attachment (attach to email) how to do it?

thanks a lot teams, really appreciated your kind support.

2019

Dears: Kind support. is there a way to attach the Form present in main form from current record to outlook on button click. as I want upon button click any attached files in current record go to outlook email. File attached, kind support on how to do this.

thanks team, its work fine. but is there a way to clear the page once opening to sign. as it always show attached signature then has to click on clear before signing the new signature.

HI: got Run time error3188: could not update: currently locked by another session on this machine. once i click on Debug highligh the below code: If Me.Dirty Then Me.Dirty = False. this error sometime appear and sometime not. can you please advise to solve this.

Dears: kind support, as I have main form where need to get the signature from 2 user. i tried different way but got error when sign the 2nd signature. can you please help me to fix this issue.

yes, but i got Error. as i want to get 2 signature from 2 different people. so can you please guide me and correct file attached.

HI, thanks. is there a way to clear a siganture with button click.

Thanks, can you please help me . file attached.

Dears: I Have a form and used attaches the report to "Signed_Form). so want to create a button to 1- Open email 2- Attache the File from "Signed_Form". is there a way to do that. as i tried below but got error message "Object does not support this property" Private Sub Command297_Click()...

Hi can you please help me for that and modify my file attached. thanks

Dears; kind support, as i have a form where I want the once scan the QR code on medication to extract the Expiry date and batch. 1- For expiry date to extract and place it in [Expd final] in "yymmdd". 2- For batch number want to see if the code start after "10" more than 2 then take the 2nd 10...