Recent content by azalea

  1. A

    Attach PDF to Form

    Thank you so much for all your help. Now comes more fun, creating an app for the student records department being able to view the uploads
  2. A

    Attach PDF to Form

    Our document sever has a lot more users, and the documents would be more else available to anyone. The SQL server has more security on the database, according to legal that's what's required. I have solved it. It was a stupid error, i was trying to load the document into the wrong field...
  3. A

    Attach PDF to Form

    The documents will primarily be stored, they will be viewed by student records department. The reason that we have to store them in the database is due to the very strict privacy & personal information laws in South Africa. Most of the documents are confidential and contain information that...
  4. A

    Attach PDF to Form

    RequestBlob is varbinary(max) on the SQL server. It is the field to store the PDF documents.
  5. A

    Attach PDF to Form

    I had changed the Description to RS!RequestBlob = strDescription I noticed that when I put the cursor over the statement in debug the following appeared: RS!RequestBlob = strDescription = False (Not sure of the relevance) I am still getting "Multiple-step OLE DB operation generated errors...
  6. A

    Attach PDF to Form

    The table that the recordsource calls has the following fields: CertSupportingDocID CertificateRequestNumber RequestBlob RequestFileName RequestFileExtension RequestFileMimeType There is no "Description". Am I correct in assuming that RecordSet uses the table manes that it is being referenced...
  7. A

    Attach PDF to Form

    I think that I am getting there. I have created a blank form with a button, and a test table in my DB called BLOBTest. The table has 3 fields: TestID BLOBName BLOBData I then set the On Click event runs the following code Private Sub Command0_Click() Dim str1 As String Dim str2 As String str1...
  8. A

    Attach PDF to Form

    Thanks so much for the help. I am definitely moving in the right direction. I have used the code pretty much as was given. Now I keep getting a 3265 Run time error (Item cannot be found in the colection corresponding to the requested name or ordinal.). The piece of code that I get it on is...
  9. A

    Attach PDF to Form

    Please Help with Attaching a PDF to Form Dear All, I am still very new to any type of programming. The company I work is in education and I have been tasked with setting up a certificate request database. I have an Access 2032 FE & SQL 2012 BE. I need to store PDF documents from all our...
  10. A

    Form not displaying data properly

    namliam, thank you so much for the feedback. I did have a circular reference. Azalea
  11. A

    Form not displaying data properly

    namliam - you are my Hero. Thanks I have got it almost 100%. I think that it is a case of not seeing the wood for the trees. My issue no is that there are so many records (See the attached) when i open the report. I suspect that there is an issue with one of the relationships between the...
  12. A

    Form not displaying data properly

    Dear All, I am brand new to MS Access 2013 & VBA. I have a report that I need to develop. The setup is as follows There is a form that collects the data and writes it to a SQL database. The form is a certificate order form for a school. There are two tables that data is written to...
  13. A

    Hi All

    Hi All, I have been asked to do all sorts of interesting things at my office. I am considered the Jack of all Trades / Fire Chief and General Dogs body. I am brand new to any type of programming, any help here will be fantastic. Thanks in advance Azalea
See more
Back
Top Bottom