Search results

  1. A

    Saving report to pdf fails with error 2501 "The OutputTo action was canceled"

    Saving report to pdf fails with error 2501 "The OutputTo action was canceled" Hello, I am trying to put a "Open as PDF" button in a report's header, so that users can share the report as a pdf. I hide the ribbon from users, so it needs to be done as a button with vba. Every time I try to run...
  2. A

    Pass a value back to vba when form is closed

    I wonder if this is possible, and if so how. Background: I've just been testing a process for uploading a file and checking for duplicates. It presents a series of forms for the user to check and confirm before proceeding. What I've found in testing is that it's easy to miss something and I...
  3. A

    Query to find a match when words in a different order

    I'm trying to implement duplicate checking for importing data from an external system: basically querying the imported data against existing data using Allen Browne's Soundex and (well, or) simple like, but there's one thing that avoids detection by either: if the words are there but in a...
  4. A

    Making 32 bit VBA code work under 64-bit - any gotchas other than Declare Functions?

    Some users here now have whiz-bang new Surface Pros running Windows 10 64 bit, and 64 bit Office. When they try to use the Access database I look after, they get a "the code in this project must be updated for use on 64-bit systems" error. Reading on this forum and elsewhere, this relates to...
  5. A

    Error 3341: The current field must match the join key

    I'm coming up against this error, and really struggling to work it out. Googling reveals very little for this error, so it must be something really simple and stupid that I'm missing. Can anyone help? The error: "The current field must match the join key '?' in the table that serves as the...
  6. A

    Procedures for importing and duplicate checking?

    A request to see if I don't need to reinvent the wheel ... We've been using Eventbrite for managing bookings on workshops etc and I've been asked to look at importing that data into our Access contacts database. I can download the booking data from the Eventbrite website in Excel format, and...
  7. A

    Is there a way to tell if contents of a field fit in a text box

    Short version: Is there a way to check if the contents of a field fit in a textbox which is bound to that field? Or is it just a matter of estimating how many characters would normally be visible in the textbox, and checking the length of the field? Long version: I have a subform in continuous...
  8. A

    How to check if a window is modal/popup

    Here's the situation: User can type into a Enter Company Name combobox. If there's a match, the match is displayed. If there isn't a match, a NotInList event asks them if they want to add a new company. So far, so good. If they say yes, frm_companies opens using DoCmd.OpenForm...
  9. A

    Query treating blank field as equal to criteria

    I have a table as follows WorkorderListID Workorder Workorder_Name Wo_Status All Short Text, except WorkorderListID which is autonumbered. Wo_Status contains one of two entries: N or C Running the following query, I noticed that one expected record was not being returned. This...
  10. A

    Can Access match words in any order in a query?

    I have implemented a search-as-you-type function on a combobox on a form displaying company details, so that a user can can start typing an organisation's name and get a drop down of matches, from which they can pick the one they want, and that organisations details are displayed. That works...
  11. A

    Hello

    Returning to database design after a break, and slowly coming to terms with Access2016. I started programming in the youth of personal computing in the UK with the Grundy NewBrain. Anyone remember that? It had a massive 32Kb memory and a built in LED display that could show about 16...
Top Bottom