Search results

  1. A

    Exporting Formatted Report to Excel

    Hmmm... yep have come across co. directors like that before... makes your job *sooo* much easier, don't they! Other than completely re-creating this report from scratch in Excel, the only other option I would consider would be to create a PDF document "on the fly". How comfy are you with...
  2. A

    Exporting Formatted Report to Excel

    Unfortunately you can't do this - as you have discovered, when you export a report into Excel it only pulls the data through. I guess it would be possible to do this - however you'd need quite a bit of coding and playing around with the query behind the report. Alternatively, you can always...
  3. A

    "File sharing lock count exceeded"

    Is the network at your work Novell NetWare? If so, that's your answer - the network admin would need to increase the record lock limit in the server settings to stop this from occuring. HTH, Ad
  4. A

    ipconfig obtain IP Address

    Hi, IP Address of..... what? The current machine? Or some other machine? Ad
  5. A

    Turn off Delete Table confirmation box???

    Hiya, You don't specify how the query is being run - via a macro or a VB module. If it's a macro, you can setwarnings to false, run the query and then setwarnings to True again (essential step!). If it's via a VB module, something like this will do: DoCmd.SetWarnings False DoCmd.OpenQuery...
  6. A

    Another Dlookup Question

    Sometimes a fresh pair of eyes is required... I spotted this - particularly the bits in red... Methinks the bits I've highlighted should be "tblImportDetails" instead. HTH, Ad
  7. A

    Checking if Recordset has data

    An alternative to the suggestion from OldSoftBoss would be to do the following: Private Sub TextSupCodeSearch_AfterUpdate() Dim exist, result1, result2 Me.Requery TextSupCodeSearch.SetFocus On Error Resume Next Me.Recordset.MoveFirst If CBool(Err.Number) Then...
  8. A

    WinZip

    Email it to me and I'll zip and post for you :) Check your PMs for my email. Ad
  9. A

    The Silly Links Thread

    Not for the easily offended: Silly Molecules Ad
  10. A

    The Silly Links Thread

    I caught this a couple of months ago here in the UK on Discovery Home and Leisure - Joy of Painting, I think it was called. 9am on Sky 133 or 134 I think. Don't know if they still show it. But I was in awe of the man - unbeleiveable what he could do with a few different colours. I'd not...
  11. A

    Notes 6 - Check for email

    Any takers? I really need help with this... Ad
  12. A

    Why doensn't this work

    Try being a little more expressive, and storing Date() in a variable before passing through to DateAdd. Something like: Dim dtDate as Date dtDate=Date() DateAdd("d", -1, dtDate) This is untested, but should work... Ad
  13. A

    Notes 6 - Check for email

    Hi folks, We use Notes as our intranet here, and I really wish we used Outlook. Why? I need to be able to determine if an email has been received with a specific header. Via Access. We have a db at one of our remote sites that the users there log daily delivery shortages onto. At the end...
  14. A

    Story

    little yellow stickers
  15. A

    Access data keeps getting corrupted some how?

    Hi, Am I right in thinking that the database is not split - ie all tables are in a "back end" db, while all the forms etc are in the "front end"? If the db isn't split, I'd strongly recommend doing this. HTH, Ad
  16. A

    Story

    ever invented since
Top Bottom