Search results

  1. I

    Programming PivotChart Form

    Sorry for the confusion. I have been able to figure out how to Filter the Selections by using the Where argument in the Docmd. The only thing missing now is being to Select All once the Pivot Chart Form is open. Thank you.
  2. I

    Programming PivotChart Form

    JHB, The Selecting all items can be done once the Pivot Chart form is open. The Selecting All Code can even reside in the form that opened the Pivot Chart form. I am looking for something like this. frm.ChartSpace.PivotFields("Waste Class").ShowAllItems = True
  3. I

    Programming PivotChart Form

    Has anyone been able to figure this out? I am still looking for a solution. Thanks.
  4. I

    Set Focus Back To Access Application

    Pr2. Thanks for that link. I was hopeful that it would work but Call fSetAccessWindow(SW_SHOWMAXIMIZED) did not set the focus back to Access for some reason. Since every user will have IE installed I decided to use the following solution. Set objIEapp =...
  5. I

    Set Focus Back To Access Application

    The code is executed from a report in Report View. Me.Setfocus doesn't seem to be available for reports.
  6. I

    Set Focus Back To Access Application

    Hello, In my VBA I open the default browser using the following code. Application.FollowHyperlink "http://www.google.com", , False Right after opening the browser I would like Focus to go back to Access. How can I do this? Thank you
  7. I

    PivotChart form adding new series with VBA

    RandomCoder, I am just looking at your solution. I am running it in Access 2007. The functionality is very good and the code is very well documented. Thank you for providing this solution. I don't believe you implemented the feature I am looking for in your example but I will keep studying...
  8. I

    PivotChart form adding new series with VBA

    Hi RandomCoder Can you check out my PivotChart VBA question below? I have downloaded your solution and will also look for the answer there. Thank you http://www.access-programmers.co.uk/forums/showthread.php?t=257010
  9. I

    Programming PivotChart Form

    Hello Access Expert, I have created a PivotChart Form. In the Open Event of the form I would like to Select specific categories determined at runtime for each of the Drop Zones / Filter Combo Boxes. So for example if one of the Filter Combo Boxes has a list of Provinces I want to be able to...
  10. I

    System Resource Exceeded

    I googled 'System Resource Exceeded' and got the below. It sounds like what you are experiencing. http://support.microsoft.com/kb/2726928
  11. I

    Update to: 2007, 2010 or 2013?

    I have wanted to upgrade for a while now but you can't have Access 2007, Access 2010 and Access 2013 installed on the same machine without using Virtual machines. If you build your solution in 2013 or 2010 it won't run for your users that are running 2003 etc... you will have to install a...
  12. I

    Access 2010 / 2013 menu

    It may be Access 2007. I use Access 2007 and my Find and Replace pop up looks like your screenshot. If I press Ctr+F and I am in a form LookIn has the name of the Form. I would recommend having the same version as the course. There are slight differences between each version that may trip...
  13. I

    Outputing report to excel with naming.

    Dim strFileName as string strFileName = "FileName" & Reports![myReportName]![ReferenceNo] & ".xls" DoCmd.OutputTo acOutputReport, "myReportName", acFormatXLS, strFileName
  14. I

    runtime error 3027 - read only access problems

    1) Try the following code at the start Dim dbs as DAO.Database Dim rsSession As DAO.Recordset Set dbs = CurrentDb() Set rsSession = dbs.OpenRecordset("SELECT ....... I have been told by MS Access MVP's not to open recordsets without creating a separate dbs variable. Perhaps that will fix...
  15. I

    Installation Packages

    I use SageKey Installation software and I do not have the above problems. I install into the Programs Folder on Windows 7 machines with SageKey.
  16. I

    ACCESS 2002 desktop developer's handbook

    I would recommend Alison Balter's Mastering Microsoft Office Access 2007 Development if you want VBA at an intermediate - advanced level. I also like John Viescas' Inside Out books. John Viescas also has a Building Access Applications with 2003 that is good for VBA.
  17. I

    str variable in dlookup criteria

    I also prefer to use Chr(34). It's a good habit to get into because if the string itself contains ' (i.e. Company's Database) you will get a runtime error. With chr(34) you will never get a runtime error so I prefer to use it over "'". It's just a good habit.
  18. I

    Form trigger for focus

    Missingling, Interesting I never used Refresh. It's only useful in optimistic locking I presume.
  19. I

    CDO Emailing. Is the DLL required or does it come with OS?

    Thanks Solo. Yes I found the file in windows\system32. I am using Late Binding on the CDO object so I am not referencing the library. I include cdosys.dll in my installation package and place it in the same folder as the FE just in case the user's machine doesn't have it. I believe XP...
  20. I

    CDO Emailing. Is the DLL required or does it come with OS?

    Paul, Thanks for the reply. I read over some books after posting the question and I believe if I include the .DLL file in the same folder as the FE Access will find it. Thanks
Back
Top Bottom