Search results

  1. I

    Save Form / WebBrowser Control Contents to an Image

    Thank you for your response. 1. Interesting I never thought of that. 2. I actually did. I used the forum search function and didn't find anything. 3. I am using Access 2007. Does it only work in 2010? Thanks
  2. I

    Save Form / WebBrowser Control Contents to an Image

    Hello Access Expert. I have a form that contains one WebBrowser Control. In this WebBrowser control I interact with the Google Maps API to produce a map. I would like to save the contents of the WebBrowser Control (Google Map) to an image file. I have not been able to figure out how to do...
    • ions
    • Thread
    • Replies: 2
    • Forum: Forms
  3. 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.
  4. 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
  5. I

    Programming PivotChart Form

    Has anyone been able to figure this out? I am still looking for a solution. Thanks.
  6. 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 =...
  7. 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.
  8. 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
  9. 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...
  10. 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
  11. 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...
  12. 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
  13. 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...
  14. 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...
  15. I

    Outputing report to excel with naming.

    Dim strFileName as string strFileName = "FileName" & Reports![myReportName]![ReferenceNo] & ".xls" DoCmd.OutputTo acOutputReport, "myReportName", acFormatXLS, strFileName
  16. 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...
  17. 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.
  18. 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.
  19. 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.
  20. I

    Form trigger for focus

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