Recent content by InfernoJaffa

  1. I

    Delete query to remove only pictures from attachments

    Hi Minty, Sorry I was referring to ridders initial reply for exporting attachment files and linking them to the database.
  2. I

    Delete query to remove only pictures from attachments

    This is what i was struggling with before, can't seem to find any step by step methods online...?
  3. I

    Delete query to remove only pictures from attachments

    The raw data itself is too large (I exported it all with a VBA macro).
  4. I

    Delete query to remove only pictures from attachments

    Hi Ridders, Are you talking about transferring the data to the disk drive and hyperlinking to it? I spent a couple of days looking into getting this working but struggled with it which is why I decided to delete the bulky, less important data.
  5. I

    Delete query to remove only pictures from attachments

    Hi, thanks for your suggestion. Sadly, most the size (1.8GB of it) is in that one field so splitting down further won't help.
  6. I

    Delete query to remove only pictures from attachments

    Hi All, Long story short, my database is at 1.9GB so I need to perform drastic action before I hit the 2GB limit. Is there any way to delete only pictures files from the attachments field? I have PDF's which aren't too large (150mb in total accrued over 2 years) which i would like to keep...
  7. I

    How I Exported an Attachment fields data to a folder

    Hi Chuck, Gravedigging here as there is not a lot of coverage over running out of space due to the attachments fields...! I'm following your guide religiously and now struggling at the form stage. I've been able to get the form to open and show the filtered query data but have not been able...
  8. I

    .Filter like syntax error

    Bingo! Thank you.
  9. I

    .Filter like syntax error

    Hi Guys I have managed to get this working: Private Sub FilterLoc1_Click() With Me.[DS].Form .Filter = "Serial = ""1.5""" .FilterOn = True End With I would like to change the code to look for a like statement of "1.*" but have not managed to get my attempts to work. Any help is appreciated.
  10. I

    Access to Excel Linked table pulling first column only

    Hi, I can not get this working.
  11. I

    Access to Excel Linked table pulling first column only

    Thanks, half way there.. Now setting the value in access i get "the value you entered isn't valid for this field". My Data type is set to number but the source grabs data from another table: SELECT [tblProducts].[ID], [tblProducts].[ProductID] FROM tblProducts ORDER BY [ID];
  12. I

    Access to Excel Linked table pulling first column only

    Hi Guys I have a linked table from access to excel. Some of my fields are drop down lists and the data linked is reading the first column, the ID column (which is hidden in access). Is there a way of asking excel to look at column 2 rather than 1? Thanks
  13. I

    Help with converting Excel to Access

    Hi Minty, Thank you for your help, I have no idea with access so have given up on the task.:banghead:
  14. I

    Help with converting Excel to Access

    That worked perfect for joining the two tables. I now need to join all the tables together to get a view to display: RigID, BayID, SerialNo, Build, TestType, Failure, TestCompleted, TestComments When add add another link I get an error saying it could not execute due to ambiguous outer joins?
  15. I

    Help with converting Excel to Access

    I think I'm half way there but my query shows no data. I have 400 bays in the table and have joined it (i think?) with the test table. Can you spot what I have done wrong?
See more
Back
Top Bottom