Search results

  1. A

    Upload files to a DB table using a button on a form

    I know and I agree with everyone here but the person who is responsible of this program wants to store the file inside the database using the code I have shared. That is what I´m trying to do. Here is the error that comes out: Perhaps something is missing...
  2. A

    Upload files to a DB table using a button on a form

    Good news!! I could finally save the file location in the table!! Thanks for your help Pat! That step is done. I could also manage to store the table on SharePoint instead of Ms Access, Access is only the front-end section of the program but the table is stored in other place. Now, I´m...
  3. A

    Upload files to a DB table using a button on a form

    I don´t want to add a new row since the row has already been created before. Just want to update the table with the new data using UPDATE command. Which part do i need to remove? Private Sub Command870_Click() Dim strSql7 As String Dim f As Object Dim strFile As String Dim strFolder As...
  4. A

    Upload files to a DB table using a button on a form

    Do I need to set it as FALSE or remove it from the code. If i removed it, would i need to remove or modificate the code reltated to "varItem"?? Dim f As Object Dim strFile As String Dim strFolder As String Dim varItem As Variant Set f = Application.FileDialog(3) f.AllowMultiSelect = True...
  5. A

    Upload files to a DB table using a button on a form

    To update the table Gc_Eventos in which I am updating the field "Cont" and placing the location of the file there. But it doesn´t work anyway. I don´t know why is the cause of the error??
  6. A

    Upload files to a DB table using a button on a form

    Actually the users have the files on their computers! I only want to include the file (or file location) they have on their computers in my program.
  7. A

    Upload files to a DB table using a button on a form

    I have tried something similar. Actually I am trying in many ways. I get the file location and then placed it in a textbox (txtLocation) in the form. And then, when I try to update the table using a query, it does not let me continue because something is broken. Perhaps because the query is...
  8. A

    Upload files to a DB table using a button on a form

    Because it is a personal process, the users are actually people who make contracts with their customers. There is confidential information in the files they need to upload. But I was thinking that this might work because they have already been separated when they access the program ... so a...
  9. A

    Upload files to a DB table using a button on a form

    I have no IT support. If this solution needs IT support, I would rather go for the option of storing the file in the DB. The DB is not large and will not grow enough to become a potential issue. Just one the easiest and simplest option. :unsure:
  10. A

    Upload files to a DB table using a button on a form

    Indeed, The Access app already has a security filter which filter the records for a specific user when logging in. So, how to make this? Where to place the folder hub? Share Point??
  11. A

    Upload files to a DB table using a button on a form

    I got it. So the idea is to has like a "folder hub" where all the files the users upload will be placed in. Access will only store the location of the file within the folder hub but without compromising the other files other users have uploaded. That means that a specific user can only get...
  12. A

    Upload files to a DB table using a button on a form

    Well, I do not know. The users will upload the file and later, if they want to see the file, they should be able to see and download the file. It is just a simple program where the final user is requested to upload a file through a form when clicking on a button in the form. The file needs to...
  13. A

    Upload files to a DB table using a button on a form

    It´s a PDF file. Indeed, attached files make the database to grow faster but in this case, the file is needed to be attached because other users need to have access to the file and the db is not large. Or where can they store the files not using the Access DB and at the same time, another user...
  14. A

    Upload files to a DB table using a button on a form

    Hi everyone Hope you are doing well. I´m struggling with VBA code. Since i´m a beginner with Access, I don´t know how to proceed with this. So basically, I have a form and there is a button inside that form. So everytime, the user clicks on it, it should be able to upload an external file and...
  15. A

    Updating Two different tables through one form

    Yeah that would be useful for my program. And what about inserting a new record on the table GC_Eventos using the last Event_ID created as the reference??? I cant related a previous Event_ID because there is no previous Event_ID. It is a totally new register. So, once you have filled out a...
  16. A

    Updating Two different tables through one form

    You are right!!!!! That was the problem!!! a single letter!!!! Now it works properly!!!! Thank you very much for your help MajP, June7, Pat Hartman, theDBguy. I really appreciate your help
  17. A

    Updating Two different tables through one form

    I have verified everything and I cannot figure out why this code is failing to execute. I do not get it. 😭 Everything seems to be OK.
  18. A

    Updating Two different tables through one form

    Does this work??
  19. A

    Updating Two different tables through one form

    Well since the data will be stored in a table that has been already created, using "Inser Into" command will create a new register, isn't it?? So have to declere StrDate to fix the problem of the dots that are shown, right?
  20. A

    Updating Two different tables through one form

    this one?? This is the window that came out after running the code???
Top Bottom