No announcements
Found 3588903 threads
-
0 VotesCreate linked table from VBA
Can this be done in VBA from module in front end?Answered | 11 Replies | 3356 Views | Created by JHarding08 - Thursday, June 7, 2018 7:35 PM | Last reply by .theDBguy - Monday, June 11, 2018 4:40 PM
-
0 Votes
Link tables with VBA
I realized that I have to relink the tables on open anyway.Answered | 1 Replies | 4122 Views | Created by mbrad - Wednesday, March 9, 2011 7:58 PM | Last reply by mbrad - Wednesday, March 9, 2011 8:20 PM -
3 Votes
How to change front end from one back end to another
somehow where the linked tables are changed in some form from one backend to another?Answered | 9 Replies | 4410 Views | Created by Matt Demakos - Thursday, July 7, 2011 8:28 PM | Last reply by Tony Toews 0 - Sunday, July 10, 2011 1:19 AM -
0 Votes
New fields added to existing back-end table not 'view-able' in front-end - even after Linked Table Mgr Refresh and 'Repair'
If your Record Source for the Form is the Name of the Table because you did not use the Query Builder within the Form's Record Source, then simply delete and re-select the name of ...Answered | 5 Replies | 748 Views | Created by Mel_3 - Thursday, May 23, 2013 3:35 PM | Last reply by KCDW - Friday, May 24, 2013 1:16 PM -
1 Votes
VBA to change linked database
I use the following VBA code to allow users to select and connect to a different BE file.Answered | 2 Replies | 1720 Views | Created by AshishKumar1200 - Friday, April 24, 2015 10:00 AM | Last reply by Lawrence Ellefson - Friday, April 24, 2015 6:12 PM -
0 Votes
Refreshing PowerPivot Linked Table in Office 2010 from VBA
Thanks Mark but that also does not work, it run through without throwing an exception but if I refresh the PowerPivot tables after running this logic it still executes with the old ...Answered | 6 Replies | 4217 Views | Created by marius.vrstr - Thursday, November 13, 2014 2:30 PM | Last reply by MariusVorster - Tuesday, November 18, 2014 9:00 AM -
0 Votes
VBA to link new table from selected back-end file
I'm not familiar with the FE Updater file in question, but generally, to update a front end in the event of a back end file being relocated or renamed, ...Unanswered | 1 Replies | 901 Views | Created by oxicottin - Tuesday, June 30, 2020 10:09 PM | Last reply by Ken Sheridan - Tuesday, June 30, 2020 11:16 PM -
0 Votes
views or tables back end of cubes?
It allows you to calculate fields dynamically, rather than preprocessing and materialising, which is slow and makes the table large.Answered | 2 Replies | 716 Views | Created by LISA86 - Thursday, October 6, 2016 2:09 AM | Last reply by LISA86 - Thursday, October 6, 2016 1:27 PM -
0 Votes
Access Front-end SQL back-end with linked tables.
How to create a DSN-less connection to SQL Server for linked tables in Access Paul ~~~~ Microsoft MVP (Visual Basic)Answered | 4 Replies | 1375 Views | Created by Ks1Sunflower - Friday, April 14, 2017 7:10 PM | Last reply by Paul P Clement IV - Friday, April 14, 2017 8:02 PM -
4 Votes
refresh micro charts from pivot table with VBA
Yes, sorry that it wasn't answered back last year.Answered | 7 Replies | 6750 Views | Created by Zero2ThreeSixty - Monday, May 7, 2012 3:24 PM | Last reply by Zero2ThreeSixty - Monday, November 25, 2013 7:08 PM -
1 Votes
Best way to connect from access front end to SQL server back end
We do understand that we need to move away from adp format, we hope to convert from adp to accdb.Answered | 5 Replies | 11080 Views | Created by Andrew Barker in Crawley UK - Wednesday, November 18, 2015 2:25 PM | Last reply by chanmm - Tuesday, December 8, 2015 6:23 AM -
0 Votes
One select from 2 different databases in VBA
Have you tried creating a Linked Table in your ACCDB database with the the source being the Table [yyy] from the remorte DB2 database ...Answered | 2 Replies | 863 Views | Created by KorMir - Thursday, January 9, 2014 11:07 PM | Last reply by Van Dinh - Friday, January 10, 2014 2:50 AM -
1 Votes
Linked Tables to SQL Server - Need a New table adding with SQL Data Connection
Now, from Access, you have to link those tables.Answered | 3 Replies | 872 Views | Created by Dan Kient - Friday, January 6, 2017 10:18 AM | Last reply by Dan Kient - Tuesday, January 10, 2017 11:17 AM -
0 Votes
Can I create a table from vba code?
The vax can create two text files per database table.Answered | 3 Replies | 1039 Views | Created by DenSolis - Monday, June 9, 2014 7:26 PM | Last reply by Imb-hb - Tuesday, June 10, 2014 7:44 AM -
1 Votes
Changing linked tables (Excel files) to actual Access tables.
To populate tables in a back end file in this way you'd firstly design and relate the empty tables in the ...Answered | 3 Replies | 595 Views | Created by Louie Warren - Tuesday, January 20, 2015 9:49 PM | Last reply by Ken Sheridan - Saturday, January 24, 2015 6:06 PM -
0 Votes
Pivot Table VBA Filters
In addition could you upload your Excel file on OneDrive, that will help us reproduce and resolve your issue.Answered | 2 Replies | 1843 Views | Created by InzieBear - Wednesday, August 31, 2016 11:38 AM | Last reply by David_JunFeng - Thursday, September 1, 2016 3:10 AM -
0 Votes
SQLserver back end dilemma
It's a simple task with .mdb/.accdb and linked tables as well.Answered | 12 Replies | 1448 Views | Created by msdnPublicIdentity - Tuesday, November 6, 2012 1:41 PM | Last reply by dave2001 - Thursday, November 8, 2012 2:44 PM -
8 Votes
VBA to automatically create linked tables from selected back-end file.
For example, if the user happens to select any BE, how do you know which tables from the selected BE to link to your FE?Answered | 18 Replies | 3651 Views | Created by Amedean - Saturday, February 11, 2017 3:07 AM | Last reply by Ken Sheridan - Tuesday, June 30, 2020 11:53 AM -
0 Votes
VBA to create a pivot table
Please also understand: pivot tables in Access are a DEAD END.Answered | 3 Replies | 896 Views | Created by Casey_M - Monday, August 3, 2015 2:53 PM | Last reply by Tom van Stiphout (MVP) - Thursday, August 6, 2015 5:10 AM -
2 Votes
Pivots based on linked table parameters are not refreshed in Excel
The first steps can be achieved by refreshing the linked table connection from the Connection menu or from VBA, but that will not be reflected in ...Answered | 6 Replies | 2436 Views | Created by Hraskó Gábor - Wednesday, June 22, 2016 7:00 AM | Last reply by Hraskó Gábor - Wednesday, November 2, 2016 8:50 AM - Items 1 to 20 of 3588903 Next ›
No announcements
