Results 1 to 2 of 2

Thread: Assign Variable

  1. #1
    Join Date
    Nov 2011

    Unanswered: Assign Variable

    Hello. In my access vba code I am trying to change a hard coded drive to a textbox value assigned to a variable.

    I would like to change this;
    DeleteFiles "s:\APLINKED\", "", DateAdd("d", -10, Date)

    to something like this;

    varFrmDrv = Me.frm_entfname_path
    DeleteFiles varFrmDrv & "APLINKED\", "", DateAdd("d", -10, Date)

    Where s:\ can now be c:\ or whatever drive letter is entered in the text box "frm_entfname_path"

    Thank you.

  2. #2
    Join Date
    Nov 2003
    Christchurch, New Zealand
    So other than specify that you want the text property of Me.frm_entfname_path what are you missing?

    Where are you having problems. Your approach seems pretty straight forward to me.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts