Search results

  1. A

    Front End Auto Update

    Ha! the arcane mysteries of DOS command lines ... It does seem to work nicely though I made one change to the penultimate line of the batch file writing procedure to Print #1, "START /I " & """MSAccess.exe"" " & Restart & " /runtime" to open it in runtime mode (i.e. without ribbon...
  2. A

    Front End Auto Update

    Thanks for posting this, Minty. I know it's a year on, and my question isn't strictly Access related, but for my general education can you explain what's happening in the above line of the batch file? I don't like using code that I don't understand, as I can't really troubleshoot it when...
  3. A

    Printing reports

    I put a button (called btnPrint) on the report with the following code attached to it: Private Sub btnPrint_Click() DoCmd.PrintOut End Sub It prints directly to the default printer with no opportunity for the user to change the printer, but that works for me.
  4. A

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

    Re: Saving report to pdf fails with error 2501 "The OutputTo action was canceled" Oh for heaven's sake. I am an idiot. <slaps self around head> Though I did have it in originally when I was trying to use the %appdata% evironment variable, so I guess I was part right, and access doesn't...
  5. 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...
  6. A

    Object or class does not support the set of events

    This is a very old thread, but this just happened to me. I had been updating some records, closed Access, then a minute or two later reopened it, opened a data entry form, and all form events brought up a message like Taking one of the suggestions above, under References, I unchecked...
  7. 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...
  8. A

    Query to find a match when words in a different order

    Thanks both, I'll progress down this route. Pat, Ha! Yes, you're right of course. This is only a relatively small system though - essentially a basic CRM system, to allow tracking of interaction with businesses and their employees. This particular process I'm working on is for importing...
  9. 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...
  10. A

    Better way to DoCmd.TransferSpreadsheet

    Resurrecting an old thread, and you've no doubt got this working now, but one thing that I don't think was addressed in responses above is the filepath. You can still use the old DOS variables in paths (even in Windows 10), so, for example, .InitialFileName = "%USERPROFILE%\Desktop\" will...
  11. A

    Hide subreport on no data

    Just been struggling with this myself, and trying to force it to open in PrintPreview so the empty subreports would actually hide, and it kept opening in ReportView. Then it was facepalm moment when I read this post and realised I needed to change the code that runs the report to...
  12. A

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

    Thanks ridders. Wish I'd found that link amid all the noise that Mr Google returned! Very clear. Bookmarked for future reference.
  13. 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...
  14. A

    Error 3341: The current field must match the join key

    Thanks arnelgp. Yes!!! That's got it! Adding Organisation to tbl_PeopleRegistrations and using that to link parent & child forms has fixed it. Thanks also CJ London: you're quite right about the people combo rowsource - I set that using VBA in the parent form's On Current, and in the...
  15. 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...
  16. 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...
  17. A

    How to open form with blank fields rather thn first record!

    Resurrecting a very old thread (sorry) to add my solution. I have the search for record combobox in the header of the form and the textboxes and other controls where users can actually view/edit data in the detail of the form. Private Sub Form_Load() Me.Detail.Visible = False End Sub...
  18. A

    Filter as you type text box

    I've just looked again at the OpenGate Software sample database, and blnspace is a variable, dim'd right at the top of the code for frmSearchExample, and defined in the keyPress event of the txtSearch textbox. It is to ignore the spacebar being pressed. Personally, I don't know why if you're...
  19. A

    Filter as you type text box

    I use the flivesearch function from OpenGate Software a lot. Like others, I'm finding it difficult to understand exactly what you want to do and what bit of it isn't working. I think you have a form with a textbox called txtsearch in the header and a subform called LstItems in the detail...
  20. A

    Check if function or sub exists

    I struggled to get this to work. It would find procedures in the first module only. Checking the error number on each pass through the for-next loop, revealed that Err.Number was not resetting on each pass, so that when it found a match, Err.Number was still 35. Amending the code to reset...
Top Bottom