Search results

  1. Pyro

    WebBrowser Control > Google Maps

    Probably not... There is additional code that grabs a screenshot of the WebBrowser control, saves it as an image file, and displays it in a report to be PDF>Emailed...
  2. Pyro

    WebBrowser Control > Google Maps

    I have a project wherein a Google Map is used to display pins of various jobs within a WebBrowser control. Recently it has been brought to my attention that the use of the Maps JavaScript API and Embed API for IE11 will be fully decommissioned. At present the map still displays correctly with...
  3. Pyro

    BackEnd getting corrupted since (I think) Win 10 updates

    Hi, It has been a while, but i wanted to weigh in on this. I have had several databases come up with the same issue over the past couple of weeks. After many headaches, and much researching, it appears that this error may be linked with the 1803 update. MS seem to have acknowledged it (see link...
  4. Pyro

    Third Party Controls (Yay or Nay)???

    Just curious to know if many developers are using third party controls in their applications? Personally in 8 years of developing Access databases, I have only ever used one non-native control. Generally I try to steer clear of them as (in my limited experience) i find front end deployment...
  5. Pyro

    Contextual ribbon tabs

    This was one of those occasions where i think i had fallen too far down the rabbit hole, and was definitely overthinking. The answer was simply: Screen.ActiveReport.Name Clicking on any control in a contextual tab activates the underlying object that the tab has been called from.
  6. Pyro

    Contextual ribbon tabs

    tl;dr How does one refer to the object (form or report) from which a contextual ribbon tab is called? The story I have a contextual ribbon tab that is used for previewing reports. There are the standard print, zoom, close etc buttons which are just built in features of Access. I also have a...
  7. Pyro

    Enlarge the form

    See my last attachment in your other thread.
  8. Pyro

    urgent:to lock and unlock a form that with a subform

    i am running out the door, but see the attached. I think it does what you want?
  9. Pyro

    Escaping special characters when entering values in DataSheet view

    If it at all helps, you can insert "" as a literal through VBA by using 6 double quotes: me!<myfield>=""""""
  10. Pyro

    urgent:to lock and unlock a form that with a subform

    It is working correctly for me. It locks with the lock button, and unlocks with the unlock button. Try typing in the field after locking it. If you want the field to be "disabled" i.e. greyed out, then we need to look at a different procedure.
  11. Pyro

    Enlarge the form

    Try setting both the "Horizontal Anchor" and "Vertical Anchor" properties to "Both".
  12. Pyro

    Enlarge the form

    See my example from your other current thread, the onload event maximizes the form. Note it will not maximize to full screen unless you set the forms Pop up property to "Yes".
  13. Pyro

    urgent:to lock and unlock a form that with a subform

    I have put together a quick example database demonstrating how to lock/unlock existing records as well as prevent/allow new records. The example uses a main form with a subform that has its source set to a table.
  14. Pyro

    Enlarge the form

    Try: DoCmd.Maximize
  15. Pyro

    urgent:to lock and unlock a form that with a subform

    Are you able to upload a copy of your database?
  16. Pyro

    urgent:to lock and unlock a form that with a subform

    If you only have a couple of sfrms on the main form then: Dim ctl as control For each ctl in me.controls Select case ctl.controltype Case acSubform Ctl.form.allowedits = False 'or true End Select Next You could put this in a function and call this...
  17. Pyro

    Question Check to see if import file has matching table field before import

    I don't think you can do what you are asking with saved imports (or at least i haven't tried it :rolleyes:). Two potential solutions would be: 1. Automate the entire import process, and check each column as you go. 2. Import the data to a temporary table, then use an append query to copy only...
  18. Pyro

    Problem getting update to show on continuous form

    Not sure how you are updating your record, but if you run an SQL statement, then requery your control, the conditional formatting should update without requerying the entire dataset and taking you back to the top of your form. Dim strSQL As String Dim db As DAO.Database Set db = CurrentDb()...
  19. Pyro

    Remove picture from Subform after go to new record

    You have to set the .picture property of the control. Me!subfrmEquipmentAdd.Image46.picture = "Z:\Shared\Location\Machine\No Picture.jpg"
  20. Pyro

    Blank pages in Report

    Is there a page break after your subreport? If so, it might work to set the pagebreak control to invisible in the .hasdata test.
Top Bottom