Search results

  1. Y

    Solved How to copy a file when closing a File Dialog?

    I want to copy a selected file to a folder and I think a good time for it is when I'm closing the File Dialog. How do I do this? File Dialog entry and exit: Private Sub File_Dialog_Click() Dim fd As FileDialog Dim varFile As Variant Set fDialog =...
  2. Y

    Help with a linking table

    Hi, I'm in a process of creating a file tagging system. I'm trying to create a table that will display for every file what tags are assigned to it. I tried several ways with relationships and it doesn't seem to work. EXP: for file num 1 I have tags 1,4,5. I made "Tags" multiselect with the...
  3. Y

    How do I use a function on a button?

    I have this code in a module and I don't know how do I use it in a button. [ Function Create_Folder(sFolder As String) If Len(Dir(sFolder, vbDirectory)) = 0 Then MkDir sFolder End If End Function Function FolderCheck() Create_Folder ("E:\" & Format(Date, "yyyy"))...
  4. Y

    How do I copy data from a form to a table?

    I'm trying to copy the data from my form to my table. I wrote this code. and when I'm activating it an error '3061' pops. [ Private Sub ADD_Click() CurrentDb.Execute "INSERT INTO MAIN(File_Name, File_Type) VALUES('" & File_Name & "', " & File_Type & ")" Main2.Form.Requery End Sub ]...
  5. Y

    How Do I Display A Full File Path And Creation Date?

    Hi, I'm new to access but I have some experience, I'm having trouble finding a way to display a full file path and creation date. Thx for the help.
Top Bottom