Search results

  1. K

    Corrupt Query

    Greetings to the well of knowledge... Posting this as a general question as I really don't think I'm dealing with a true corrupt query. I have an Access front-end to a back-end SQL Server DB. I make periodic updates to the front-end, on about an every-two-weeks basis. After the most recent...
  2. K

    Report orientation

    Greetings to the well of knowledge... This one has me gobsmacked. I have an Access 2016 front end with an SQL Server back end, with several reports, running on Windows 10 (fully updated). Some of these reports are landscape. All of my users, save one, get a landscape report when they print...
  3. K

    Solved Most recent records query

    Greetings to the well of knowledge... I'm at a loss on this particular query design. We have a table of donors that contains the donor's name, the date of the donation, and the amount of the donation (among other fields). A user would like a list of all donors with the date and amount of the...
  4. K

    Strange Behavior in a Combo Box

    Greetings to the well of knowledge... This is a strange one. I have a user of one of our Access front-end apps that often has need to move from an app that requires data entered as all caps (primitive, I know) to the Access front end. There is a drop-down search field that users can employ to...
  5. K

    Solved Actions to take before move to a different record in a form

    I come again to the well of knowledge... Having a brain cramp here... I display US address information, Address, City, State, and ZIP Code, in a simple user demographics form. Prior to displaying the current record in the form, I set a variable, BeforeFullAddress, consisting of a...
  6. K

    Gmail to stop using SMTP for authentication

    Greetings to the well of knowledge... As some of you may know, Google will be dropping support for SMTP as an account authentication methodology, replacing this with OAuth.. I have several snippets of code that uses the native CDO library to handle email within my VBA code. Has anyone been...
  7. K

    Data Conversion Question

    Greetings to the well of knowledge... When I upgraded my Access front-end from 2010 to 2016, one of my currency fields was converted to a Varbinary(510). The field displays properly in a report but I am unable to export the data into a spreadsheet; the field is blank. Is there a conversion I...
  8. K

    Error 3265 executing Query

    Greetings to the well of knowledge... Not sure of where I should post this, so posting it here. I recently upgraded my SQL Server back-end from 2008R2 to 2017. I am now trying to get my existing front-ends working using 2017. I have encountered one issue. I have some code that executes...
  9. K

    SQL Login Error

    Greetings to the well of knowledge... I have an Access front-end that talks to an SQL Server 2008R2 back-end (yes, I know I need to upgrade this). This front-end is used by users on a Server 2008R2 remote desktop server. I am in the process of completing the build-out of a new Server 2012R2...
  10. K

    MS Updates

    Greetings to the well of knowledge... I am sure most if not all of you have been touched by the recent rash of defective MS updates for Office. :banghead: Despite my best efforts to remove the bad patch(es) or apply the alleged fixes, I continue to have problems where my applications just...
  11. K

    Question A Question of Trust

    Greetings to the well of knowledge... All of my Access DBs are front-ends that talk to our central SQL Server. I manage the development and release new versions on a fairly frequent basis. I install the "gold" copy of the Access DB on a network share and instruct my users to take a copy of...
  12. K

    Table Locked???

    Greetings to the well of knowledge... I have an Access 2016 front-end talking to an SQL instance. Last week, some issues arose that required me to restore a couple of corrupted tables from backup. These tables restored successfully but since then, one of the tables appears to be in "read...
  13. K

    Runtime Error 2424

    Greetings to the well of knowledge... I've read a few posts about this particular error occurring ad now it is with my particular project. Let me preface this by saying that I just recently switched over to using Access 2016. When doing this sort of simple programming under Access 2010, I...
  14. K

    Cannot print a report in Layout View

    Greetings to the well of knowledge... I have been trying to print a report in Layout view for documentation purposes. I get the error: "A custom macro in this report has failed to run and is preventing the report from rendering." I am not using macros anywhere but some of the reports do have...
  15. K

    Question Access 2010 DBs running on Access 2016 runtime

    Greetings to the well of knowledge... We recently upgraded on Office 2016 including Access 2016 runtime at our HQ. We have several remote locations still running Office 2010 with Access 2010 runtime. We have plans of upgrading these remote locations but we have some logistical issues...
  16. K

    Question General Runtime Error?

    Greetings to the well of knowledge... We have an MS Access front-end interface to an SQL Server 2014 DB. Our users access it via MS Access Runtime 2016. As the developer, I use full Access 2010 as we still have some individuals using 2010 runtime. On occasion, a user will receive the error...
  17. K

    Item Not Found in Collection

    Greeting to the well of knowledge... I hope someone can explain to me what happens when a report is printed. I have a report that "previews" fine. I can scroll through all the pages and everything looks right and proper. When I hit the print button in the ribbon, I get the dreaded "Item Not...
  18. K

    Finding records with the most recent date

    Greetings to the well of knowledge... I have a table of donations made by various individuals. Each individual may have made one or more donations over time. I need to find the one record for each individual that has the most recent donation date. I can't seem to find the right method for...
  19. K

    Open Excel Spreadsheet after TransferSpreadsheet

    :banghead: Greetings to the well of knowledge... Running Access 2010 and suffering from CRS... There was a time, as I recall, when one could launch Excel from Access VB with a single command line but now I cannot recall how to do this. Additionally, when I execute TransferSpreadsheet, I only...
  20. K

    Report Printing doesn't work the first time

    Greetings to the well of knowledge... This is weird one :confused:. Using Access 2010... I run my application and then I use a form to provide parameters for a report. When the parameters are fully entered, it launches the report just fine. However, when I click Print Report, what prints...
Top Bottom