No announcements
Found 3354275 threads
-
0 VotesVBA to change all "SubdatasheetName " in a table from "Auto" to "none"
Hi Is there a code to change SubdatasheetName from "Auto" to "None" i all tables of an Access ...Answered | 2 Replies | 378 Views | Created by ForssPeterNova - Monday, July 11, 2016 4:36 PM | Last reply by ForssPeterNova - Monday, July 11, 2016 4:47 PM
-
1 Votes
PowerPivot - list of all tables (tabs) - using VBA
Regarding the update of a PowerPivot model, Tom Gleeson (Goban Saor blog) has found a way to do ...Answered | 2 Replies | 5609 Views | Created by Ganeshmurthy - Friday, December 21, 2012 9:16 AM | Last reply by Elvis Long - Tuesday, December 25, 2012 7:38 AM -
0 Votes
Create linked table from VBA
One question - if there are four users, each with the front end MDB, if I do create temp table, move temp table, link temp table, how do I keep ...Answered | 11 Replies | 3378 Views | Created by JHarding08 - Thursday, June 7, 2018 7:35 PM | Last reply by .theDBguy - Monday, June 11, 2018 4:40 PM -
0 Votes
Turning IDENITY Auto Increment off on All tables.
Dan how I can make change persistent on Azure i.e. turn off identity feature on all tablesAnswered | 12 Replies | 5912 Views | Created by Zaid Mirza - Monday, April 11, 2016 4:31 PM | Last reply by JuneT - Tuesday, April 12, 2016 3:10 PM -
0 Votes
Pivot table auto refresh in excel sheet without using Macro/VBA while changing source data section data filter
See for example http://www.get-digital-help.com/2011/04/26/how-to-create-a-dynamic-pivot-table-and-refresh-automatically-in-excel-2007/ ...Answered | 3 Replies | 5902 Views | Created by TestPr123 - Tuesday, June 30, 2015 5:14 AM | Last reply by Hans Vogelaar MVP - Tuesday, June 30, 2015 4:15 PM -
0 Votes
VBA powerpoint - code to change cell shading in a table
Hi jakub, To change the cell shading of a table, you could specify ForeColor to the Shape of the cell.Answered | 1 Replies | 4459 Views | Created by jakub dusek - Saturday, December 6, 2014 8:22 AM | Last reply by Starian chen - Monday, December 8, 2014 7:38 AM -
0 Votes
Changing all tasks font to not bold in VBA
All, I managed to write a VBA code that suited my needs.Answered | 6 Replies | 1248 Views | Created by Yuval.p - Monday, May 2, 2016 6:53 AM | Last reply by Yuval.p - Monday, May 2, 2016 12:37 PM -
0 Votes
Link tables with VBA
I realized that I have to relink the tables on open anyway.Answered | 1 Replies | 4130 Views | Created by mbrad - Wednesday, March 9, 2011 7:58 PM | Last reply by mbrad - Wednesday, March 9, 2011 8:20 PM -
0 Votes
VBA Pivot Tables
Hello, I changed the VBA slightly to the following which works for "Country" perfectly, but im still at a total loss as to how to do ...Answered | 5 Replies | 1068 Views | Created by InzieBear - Wednesday, August 24, 2016 3:28 PM | Last reply by Edward8520 - Monday, August 29, 2016 5:23 AM -
1 Votes
Auto Updating a Pivot Table when Data changes
The language I use is C# from Visual Studio 2010, and the Excel version is 2007.Answered | 3 Replies | 8085 Views | Created by Tom Madsen - Monday, November 8, 2010 11:03 AM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Wednesday, November 10, 2010 4:58 PM -
1 Votes
flowdocument table columns auto-width
From some whre you need to have the information about font ... when you build the table.Answered | 17 Replies | 15179 Views | Created by YismanOl - Wednesday, June 20, 2012 11:02 AM | Last reply by Reinhard Ostermeier - Tuesday, September 4, 2012 1:49 PM -
0 Votes
Pivot Table VBA Filters
All you have to do is record a specific task once.Answered | 2 Replies | 1863 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
Can I create a table from vba code?
This is the object to the BE database containing all user tables: Set Data_db = ...Answered | 3 Replies | 1046 Views | Created by DenSolis - Monday, June 9, 2014 7:26 PM | Last reply by Imb-hb - Tuesday, June 10, 2014 7:44 AM -
4 Votes
refresh micro charts from pivot table with VBA
No worries, I'm all set.Answered | 7 Replies | 6758 Views | Created by Zero2ThreeSixty - Monday, May 7, 2012 3:24 PM | Last reply by Zero2ThreeSixty - Monday, November 25, 2013 7:08 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 | 1735 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
Change Tracking - Auto Cleanup
We came across same situation and the change tracking auto cleanup was unable to keep up with the amount of activity on the tables.Answered | 5 Replies | 4037 Views | Created by maxcpp - Saturday, December 24, 2016 12:03 AM | Last reply by maxcpp - Saturday, December 24, 2016 3:50 PM -
0 Votes
VBA to create a pivot table
Please also understand: pivot tables in Access are a DEAD END.Answered | 3 Replies | 902 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 -
0 Votes
Changing schema for all tables in a database
Try below code to change the schema of all tables into new schema.Answered | 2 Replies | 10236 Views | Created by DBA_LEARNER - Friday, August 24, 2012 4:14 PM | Last reply by RohitGarg - Friday, August 24, 2012 7:22 PM -
2 Votes
VBA TO TRACK CHANGES
Tip on VBA Programming: When Using Find in VBA all of the parameters (Except After:=ActiveCell) should be included in the code (See your Find in the code ...Answered | 19 Replies | 1625 Views | Created by jay.nz - Sunday, July 1, 2018 5:35 AM | Last reply by jay.nz - Saturday, July 7, 2018 2:50 AM -
3 Votes
VBA fails to recognise new field names leading to "Method or data member not found" errors, and failure of code auto-completion.
Answered | 6 Replies | 16652 Views | Created by Matthew Slyman - Friday, June 24, 2011 11:10 AM | Last reply by NyemaSanya - Friday, May 16, 2014 2:06 PM - Items 1 to 20 of 3354275 Next ›
No announcements
