access 2016

Hi Guys, First of all I am new here, Here's the problem: Why access no longer rename a blank column or has invalid character such as '.' into NoName or '#'. Is it because update? how to change the preference back to the old one? or maybe I can edit the registry to change it back? I really...

I have a table of data in Excel with around 1,500 columns and around the same number of rows and I'd like to transfer the data into Access for further calculations. Excel is struggling to cope given the size of the data set. I cannot reference the table directly from within Access because of...

Hi all, Long time no see, how is everyone? :) I've just updated to Access 2016, and one of my reports is no longer publishing to PDF correctly. Everything looks like it has rendered OK, but is too large, and so the text is overrunning and getting cut off on the right hand side of the page...

Hi Just wondering, as the title suggests how to write a query that - based on what is entered on a form - dynamically refers to a column heading in a table. So: I have a table called "Required training": <tbody> Training Teacher Admin Senior Management Safeguarding 1 1 1 First Aid 1 0 0...

Good Morning, I noticed that CollectDataViaEmail is no longer in my list of options in Access 2016, is there a work around for this? I would like to be able for a person to fill out a form in access and click a button to send an email to the owner of the task. Once he or she receives it, I would...