Search results

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...

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...

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...

All users have their own local copy of the front end. The front end builds several local tables as part of its processing so a shared network copy would be dangerous.

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...

Just one line of code in the Detail section that concatenates FirstName and LastName into FullName.

Interesting. The report does contain a subreport. When I removed the subreport, the report printed with no errors.

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...

Oh, and further, if an individual made more than one donation on a given most recent date, I want to select the record that has the highest donation amount. I don't think I have any such records, but I've been asked to account for this.

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...

I understand this. The issue is identifying the end user's file/save folder. For example, my default file/save folder is on my E: drive, but using Environ("USERPROFILE") only tells me that profile is on my C: drive. There must be another system variable that tells me where that file/save...

: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...

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...

Cool! Thank you!

Hmmm...I'm not quite sure how I'd do that.

Let's see if I can explain this, then: I think I need to transform... Record I: Name A lives at Address 1 Record II: Name B lives at Address 1 ...into... Record I: Name A and Name B lives at Address 1. There could be one or more records per Address.

Apologies. The tables don't look good when posted.

Greetings to the well of knowledge... I have received an unusual query request that I need help to put together: I have a table of clients. For each client, there may be one or more family members identified. We are going to be doing a mailing out to all family members but in order to save...

The entirety of the message is: "You can't carry out this action at the present time. You tried to run a macro or used the DoCmd object in Visual Basic to carry out an action. However <DBNAME> is performing another activity that prevents this action from being carried out now. For example, no...

Greetings to the well of knowledge... Have read every other posting on this particular error message but have not found my particular circumstance. It's an Access 2010 front-end using an SQL Server DB using ODBC. The users reporting this error successfully opened the database at some point...