Search results

NAILED IT! How did you know????

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

Yes. I noticed the typo. I changed all Me. references to Me!...these did not work.

Something amiss in Access 2016??? I just took the last good version of the DB and made the same changes to the DB using Access 2010 and no errors are being thrown, either in Access 2010 or Access 2016. This is weird.

Me! = No good.

I must also mention that these "Provider..." fields were just added to the DB using Access 2016. If I do this using Access 2010, no errors.

Unfortunately, I can't. It's all linked tables from an SQL Server DB. The Access piece is just a front end.

"The expression you entered has a field, control, or property name the <application> can't find."

Yes, all text boxes. The data is provided from an external web form source and fills the form so that it can be viewed (not edited). The "user" chooses" this from the web form and the data is written to the table from the web form. Basically, the form asks if the application is being filled...

I should also add that all of the other "Provider..." fields display as #Name? in the form.

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