Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ajrimmer

  1. ajrimmer

    Help Needed - PDF Printing via command line

    Have you looked at the examples distributed with PDFCreator?
  2. ajrimmer

    Password Protect MS Access Project (.adp file)

    As lameid says it sounds like you've already got security of the data provided. If you just don't want people to change the adp then why not distribute it as a .ade?
  3. ajrimmer

    How to change the position of a legend in a chart using VBA?

    Yes, sorry, I answered the wrong question.
  4. ajrimmer

    How to change the position of a legend in a chart using VBA?

    Somebody will come up with something neater but Sheets("Chart1").Activate ActiveChart.Legend.Top = 100 ActiveChart.Legend.Left = 100 should get you started
  5. ajrimmer

    Specify Printer Destination

    This is getting old but shows how to change printer. http://www.members.shaw.ca/AlbertKallal/msaccess/printch2k.zip
  6. ajrimmer

    Excel Formula Question

    Making some assumptions about data consistency... =LEFT(A1,FIND(",",A1)-1) =TRIM(MID(A1,FIND(",",A1)+1,LEN(A1)-FIND(",",A1)-(LEN(A1)-SEARCH("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))))
  7. ajrimmer

    Visio Replacement

    M$ do a Visio Viewer if you only need to read the doc http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d88e4542-b174-4198-ae31-6884e9edd524&displaylang=en
  8. ajrimmer

    query performance

    Have you installed SP2? Solved a couple of performance issues for me.
  9. ajrimmer

    Switchboard vs. Form for Main menu

    Personally, I stopped using the switchboard method a long time ago for anything but the simplest of solutions which need a quick (& temporary) answer.
  10. ajrimmer

    Some reports open really slow, sometimes.

    Are you using Access 2007? If yes, then installing SP2 could help.
  11. ajrimmer

    Using Enterprise Manager to mimic Queries in Access 2003

    You need M$ SQL Server Management Studio for SQL Server 2005. There's an "express" (free) version here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
  12. ajrimmer

    Why is code opening a Project in Read Only

    You say "opens the project again" - so are you opening up two instances of the front end at the same time? If a front end is already open (by the current or other user) then subsequent users will get a read only warning (which relates to changes to the front end, not the data on the server)...
  13. ajrimmer

    Access 2003 vs 2007

    Have you installed SP2? I had some speed issues with Access 2007 which improved dramatically with SP2.
  14. ajrimmer

    Moving database location

    You need to change the connection. In Access 2003 goto File - Connection & amend appropriately. If you're using Access 2007 it's a bit more complicated & is described here: http://support.microsoft.com/kb/306881
  15. ajrimmer

    Column alias

    Strange one. Don't know why that's happening. However, have you tried nesting select statements to get them in the order you want? eg SELECT Account, Month_Year FROM (SELECT BANK_NUMBER AS ACCOUNT, MONTH_YEAR FROM MYTABLE.... ) tblAlias
See more

Part and Inventory Search

Back
Top