Search results

  1. 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...
  2. 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.
  3. 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
  4. I

    Help with converting Excel to Access

    Hi Guys, I have created a shared workbook in Excel and it isn't working very well with constant lock outs and losing data. I would like to create an access database to replicate what the workbook does but I am having trouble on how to start. Basically, the workbook tracks and records cycle...
  5. I

    Grab and calculate days between two dates

    Hi All, Firstly, thank you for clicking onto my thread. What I have is two fields, one is a simple date and the other is slightly more complex as it holds a date but in a different structure (a dated case number). The case numbers are for example, 150211551223 the date being the first 6...
Back
Top Bottom