access 2016

Hi All. Having trouble opening SharePoint link(s) in MS Access 2016/365. Getting the following message: The file can not be opeened. The requested information could not be downloaded. Looked through the security settings, added the SharePoint folder(s) to be safe but no luck. The link points...

Hi All. I am trying to create a simple date search function but Access always complaining about the DoCmd.ApplyFilter task. See below. Any insight would be greatly appriciated. Option Compare Database Private Sub Command22_Click() ' Search button Call Search End Sub Sub Search() Dim...

hi all, I have 2 different tables in Excel; I have managed to get them into Access database in Table format. But I have a task to join these 2 table and get a new table. I have written the query, but its not working; while executing I get the error that its too complex.... Request your help...

I have the current macro (Code below) that adds one record to an access database which works great. How do I create a loop that would insert all 500 rows and stops at the next blank cell? Or is there another option I should be looking at to insert multiple rows into access? Sub Add_Record()...

I have the following code but have not found a solution online. Has anyone figured out a solution? or would this relate to an authentication issue from my company's server? how do I get around that? I have the following references: Microsoft Access 16.0 Object Library Microsoft DAO 3.6...

I need a excel macro to add records to an access 2016 database. I have tried using multiple sets of code and can't get it to work. Access 2016 database name: Development Team Table Name: Costs *Headers are the same on access and excel* Excel sheet: Tab: Temp <tbody> Date Item 1 Item 2...

Need a solution to return the highest value of PO number issued. Our PO log has over 2500 entries at present including duplicate PO references on numerous jobs. Filtering is rather cumbersome with this many entries. Purchase order structure: Job Number PO Sequence# PO Requestor 1878...

I am trying to determine the amount of days between two dates on a matching serial number. My data has serial numbers that were seen in the past and I am only using the same serial number if it appears twice. I want to know the amount of days in between the date fields we saw these last. The...

I cannot find a way to fix an issue with Access 2016 concerning graphs in forms. When I make a graph in other versions of Access, the graph automatically centers on the box it is in. Not in 2016 though. Is there something I am overlooking? I have tried everything I know can cannot figure out...

<tbody> Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 Lookup John Smith 12345 HoS Jane Simpson 3456 Another Name 9876 Hector Wilson 34523 etc etc 12345 Jane Jones 53425 Another Name 9876 Kelly White 19282 Adam Lewis 45455 etc etc 45455 Hector Wilson 34523 John Smith 12345...

I am having an issue with how some people entered their work. When they closed the tasks they closed it as the year it was closed and the quarter it closed in and not a date of close. Can I create a date of close by taking the Quarter and the year and combining them to show something like this...

I get the below messages in access: Table is a linked table whose design can't be modified. if you want to add or remove field or change their properties or data types you must do so in the source database. I want to change the source data types, how do I do that?

Ok, so just to give a quick disclaimer, I am fairly new to using Access. I took a college class on it like back in either 2011 or 2013. I really haven't had to use since then and so I apologize in advance for any simple/silly mistakes, follow-up questions, etc. Although I may be new to this...

Good morning. I am looking for some VBA that would label each row in a table in sequence from 1 to 10. I am counting the number of times a model number comes up during the year. I have them in order of largest to smallest by top 10. I now need to label each row from 1 thru 10. Autonumber will...

When I switched from Access 2013 to 2016 all of the charts that I had previously created changed to a smaller size in every form. How to I resize these back to the normal size they were before? I utilized two versions of Access because of a customer need for different versions from 2013 to 2016...

I have a DB that culminates into 4 export queries. I would like to create a macro to export the 4 queries into one workbook per Business Unit. There are 10+ Business Units. A single Business Unit workbook would contain the output of from each of the export queries for the respective Business...

Hi all, I have a query that I use to export a text file for another database. I am currently testing changes, and need the same output, but formatted into a series of "Insert Into" statements to be able to develop. So I wrote another query to produce a fully formatted text string for each of...

Good morning, I have a question about why I cannot load a table onto my SharePoint site using the SharePoint Lists command in Access. My data gets to 33% and goes very slowly from that point. I have not been able to load up any table I have tried. There is a large amount of data in the tables...

Hi everyone, I'm currently working on a project where I want data taken from an excel table imported into an access database. The excel table cannot be linked to the access. This is the code I am currently using: Sub AccImport() Set cn = CreateObject("ADODB.Connection") dbpath =...

Just found out that one of our company's sites that I support got Access 2016 on new computer. Most of our apps are written in Access 2010 and separate versions are set to handle the Reference differences for 2013. Anything I need to know about 2016? Thanks,