Search results

  1. M

    VBA import to excel add criteria to set range

    you can do this easier from Access (imo)... open your workbook with vba and then set a named range, so with your code above it would be like; ws.Range("A1:G1").NAME = "cheese" then you can save as and quit then run a docmd.transferspreadsheet, on the last setting ensure the named range is set to...
  2. M

    excel data connection not updating

    I think it's something like ObjXL.Connections("conn name here").refresh iirc - let me know if that does the trick
  3. M

    Alternative to SendObject to achieve automation

    You can also try using CDO automation if you don't want to rely on outlook. See here from quick search as an example; http://www.access-programmers.co.uk/forums/showthread.php?t=191192
  4. M

    shell to/from other MS documents

    Hi sorry I am not understanding this as well as maybe I should, what address facility are you using to store PDFs? You could always just store the location in a field and then program a button to open the link in that field? Or do you mean you want to be able to give the user the dir of the path...
  5. M

    Using Access of Count Worksheets Loop

    you haven't loaded a workbook in this block of code?
  6. M

    mail merge for a single record

    can you post a copy of your db?
  7. M

    Open query recordset

    try opening a query in design view, making the query in there and testing it to make sure it works then when it does go to SQL view and grab that and move it across VBA. Alternatively paste your vba into the immediate window like sql = "Select UKmai.... etc" then ?ssql to get the query info and...
  8. M

    mail merge for a single record

    Let's say your unique ID field was 'employeeID' copy the query you are already using, make a second one (rename it qryNameMerge or whatever you choose) and in this second query set the filter for the employeeID field to forms!yourformnamehere!employeeID then it will only have the record you are...
  9. M

    Error: "Object or class does not support the set of events" connecting Access 07 to O

    Re: Error: "Object or class does not support the set of events" connecting Access 07 Sorry I am a bit confused! Are you trying to get data from Access into Outlook, or data from Outlook into Access?
  10. M

    Emailing Multiple Attachmetns with VBA

    can you post an example of your absolute path to the file that's giving you an issue? likely a missing \ as that's usually the culprit You can send all the files in a folder by looping through them, or you could alternatively search for the specific files using the * wildcard. eg if the...
  11. M

    Error: "Object or class does not support the set of events" connecting Access 07 to O

    Re: Error: "Object or class does not support the set of events" connecting Access 07 Are you linking to an actual table or trying to link to a query? What error(s) are you getting and what's the actual issue besides 'it doesn't work'? If you can be more specific (with what you're doing) it...
  12. M

    Unable to export recordset data to multiple excel range in same sheet

    try rstData.Movelast and then a rstData.MoveFirst before your rstData.eof?
  13. M

    VBA Loop stalling on db.openrecordset when recordcount is 0

    God damnit I am a fool. I didn't reset a value properly and had an error in a date function following an empty recordset further up the line which gave it this effect. Thanks for your help, going to take my GF's advice and stop working..... and play with my cat!!!
  14. M

    VBA Loop stalling on db.openrecordset when recordcount is 0

    Unlikely indeed - just throwing straws at it. When I say stalling - no error message nothing happens it just stays in 'running' mode and no matter how long I leave it for if I pause and debug it ends up highlighting the openrecordset line, but only when it's trying to open a recordset with 0...
  15. M

    VBA Loop stalling on db.openrecordset when recordcount is 0

    Hi guys A really bizarre issue I haven't walked into before. Let me try and explain; I am having issues with this small part of code here; Set rst = CurrentDb.OpenRecordset(sSql1, dbOpenSnapshot) With rst If .RecordCount > 0 Then i = i + 1 .MoveFirst...
  16. M

    Import/Export Specifications

    If you go to navigation options then show system objects in access, you can look at MSysSpecs and MSysColumns which are system tables. In the 1st table you have the names of your import specifications, and the second the column names the specifications are looking for (and their type), you can...
  17. M

    Change the value of a field in an append query using SQL

    So you want the value of accountID to be appended into tblPosts? You could always grab the value and assign it to a variable in a similar fashion you have NewID
  18. M

    Send EMail through access. Focus back to Access

    it allows you to carry on doing what you want while VBA is processing iirc put it on the line above the code, or the one below it I can't remember for sure I think it's the one above. HTH!
  19. M

    Add records to a table referencing a table in another database - DAO

    can you not just link table to database B?
  20. M

    checking if data exist

    do you have a validation rule on the telegram_number field? You are setting it to "", try setting it to null
Top Bottom