Search results

  1. theDBguy

    requested type library or wizard is not a vba project

    Hi @EmmanuelLan Welcome to AWF! That's an interesting solution that I didn't even try when I wrote this blog a while back. https://thedbguy.blogspot.com/2016/02/requested-type-library-or-wizard-is-not.html
  2. theDBguy

    Introduction

    Hi. Welcome to AWF!
  3. theDBguy

    SetProperty visible problems

    Instead of using Yes/No, try True/False. Edit: Oops, too slow...
  4. theDBguy

    Missing acReport part of coding

    Unfortunately, I couldn't find it on MS website, but I did find some links for external sites. I don't feel comfortable passing them to you, in case any of them might be risky. Good luck!
  5. theDBguy

    Missing acReport part of coding

    Hi Jeff. I believe for Acc2007, the PDF driver had to be installed manually. It used to be a download from MS. I'm not sure if it's still available now. If I find a link, I'll repost.
  6. theDBguy

    Solved Using dynamic sql instead of saved query in Insert Into queries...

    If the function CreateSql() returns a String, then I don't see why not. Can you post the code for the function?
  7. theDBguy

    I'm an Oldie but goodie

    Hi. Welcome to AWF!
  8. theDBguy

    Help query Count

    It's possible to use a single process if you were using SQL Server but not with Access, I'm afraid.
  9. theDBguy

    New member

    Hi. Welcome to AWF!
  10. theDBguy

    Calendar events but not in Outlook

    Thank you for the clarification. If the end goal is to eliminate the need to email PDFs to the volunteers, then the simple solution might be to simply invite the volunteers as guests to the SharePoint calendar, so they can view them as needed. If so, you can continue to use Access to update the...
  11. theDBguy

    Cancel,Save and Delete buttons for Order form

    If you were able to do it on one form but not on another, then you'll have to determine what is different between the two. If you think it's the requeries and recalcs, try removing them to see if you can get it to work. If you still need help, maybe post a sample db with test data.
  12. theDBguy

    How to use a combo box to filter a forms data

    You could start with using the combobox wizard and selecting the third option. I would suggest using two separate buttons to clear the filter (All option) and going to a new record (New option).
  13. theDBguy

    Create a form with dynamic number of tab?

    You would usually include as many tab pages you'll ever need and simply show only the ones you need for a particular case and hide the rest.
  14. theDBguy

    Calendar events but not in Outlook

    I'm not quite sure I get this statement. What does it mean to "push out electronically" the SharePoint calendar? How is that different from "emailing PDFs?" Also, will you be pushing the entire calendar or just the events?
  15. theDBguy

    Performance Issue

    Are you using linked tables to SQL Server? Just curious...
  16. theDBguy

    I have saved the picture of Compliance 1 in my D:\picture folder. I want that when Compliance 2 is selected, the picture corresponding to 2 should

    Try explaining your problem in the body of the post instead of in the title to help us understand your issue.
  17. theDBguy

    Problems creating 'front-end' portion of split database (ie. no 'Save As' dialogue after clicking 'Make ACCDE' and 'Save As' button)

    When you use the wizard to split the database, it automatically creates two files: the BE and the FE. So, it sounds like your friend didn't have any problems creating an FE. Rather, it sounds like the problem is with creating an ACCDE. Why are they trying to do that? If that is the problem, then...
  18. theDBguy

    Old Newbie

    Hi. Welcome to AWF!
  19. theDBguy

    Solved VBA code for deleting Outlook 'Appointments' lying within a specified date range

    Have you tried stepping through the code and examine the properties of each event you were able to capture?
  20. theDBguy

    Solved Show "no" results

    Is the Subform linked to the main form? If so, do you want to filter it relative to its relationship with the main form?
Back
Top Bottom