Search results

  1. B

    Import from spreadsheet and overwrite existing

    Hi, Basically I have a macro that runs the TransferSpreadsheet action to import data from an Excel file. As it stands if the field containing the primary key already exists it will flag an error message and not import that record. What I want to do is overwrite the current record with the new...
  2. B

    Suggestions for solution to run access macro in receipt of email

    Hi, Currently I have a rule within Outlook to move mails meeting certain criteria to a specific folder and display a msgbox confirming that a new mail (which contains a report in text file format) has been received. I then run some code within Access which downloads the text file attachment...
  3. B

    Help needed opening instance of Outlook from Access and running code

    Hi, I have the following code which downloads any email in a specific inbox sub-folder to a specified location and then deletes it. It works fine when I call the sub routine directly from Outlook, but when put the code into a module in Access it says there is a compile error and that the...
  4. B

    How to divide result of one select query by another?

    Hi, I'm struggling with the correct syntax for this, but ideally what I want to achieve is: SELECT (SELECT Count(Status) FROM P_T WHERE 'criteria are met') / (SELECT Count(Status) FROM P_T WHERE 'different criteria are met') They are both fairly simplistic select statements, so I imagine...
  5. B

    Code question - problems including windows login as variable in file name

    Hi, I'm trying to delete a file that uses the user's windows login id as a variable in the file name but am having a little trouble. I think I'm nearly there... I've assigned the windows login ID to the string User_FX with a function and have written the following code, but it returns an error...
  6. B

    Combobox as variable in where clause

    Hi, I have exhausted my tried and tested technique or trial and error and copious amounts of searching the internet to try and resolve this but to no avail. Basically what I have a table called Pnd_Trades and a combobox called 'broker' located on a form called 'Getstats' and I want to...
  7. B

    Query to returns rows where field contents <= today + 2 business days

    Hi all, This is my first post so be gentle. I have tried searching for what I am looking for but to no avail (if the code is floating around somewhere on here I apologise but I did have a good look prior to posting). Basically what I want to do is something along the lines of the following. I...
Back
Top Bottom