tables

Hi, I am new to MS Access. I wanted to know, does Access support Pivot tables now. I am required to edit couple of existing macro. These macro has pivot tables in this. However, I guess, pivot tables are no longer available in Access. Please correct me if am wrong. How do I proceed if pivot is...

suppose I have three data tables in same worksheet, I need to create their corresponding Pivot tables Is it possible EX:- tbl1 -> Pivtble1 tbl -> Pivtble2 etc also I am notsure what is table range and table name can I create pivot table for such scenario using VBA ? Thnks

Hi I understand ‘Globe with blue arrow’ tables are liked to external tables. Have few of such table in my database. What pre-cautions I must follow when trying to play or edit such tables. For example, if I try to check ‘Design View’ of such table, access gives me warning. Table is a linked...

Hi I am trying to set something up in VBA where it would cycle through each table on the Activesheet and if the 3rd column header says "Start Date" then add 7 for each element on the 3rd column of that table. How would this be written in VBA?

Can someone please help me? I am trying to import this webpage to PQ but the Navigator lists no tables at all. Is there some special technique? https://www.nhl.com/standings/2019/league

Hi, I have a workbook with 3 different sheets containing tables. All 3 sheets are the same exact format, the only thing different is that it is divided into 3 regions. So column headers are exactly the same in all 3 tables. I am trying to copy all 3 tables into one new sheet. Is there a simple...

Hi, Im trying to filter multiple tables by a common table header cell called "Match:". If the row in any table on the worksheet in column "Match:" is True, then show that row with the table that it is in, otherwise i want the entire table hidden including the first row right above the table. I...

I am creating a userform to record incoming business opportunities across multiple work-streams and need help with the Unique ID feature of the coding (appreciate this is a common question and I have looked, and looked again and Googled - but I couldn't find anything for my situation) as I'm...

Does the iPad version of excel allow for 2 variable data tables? I have a workbook with 1 and 2 variable data tables that are not updating. Similarly, is there the equivalent of an f9 key for mobile Excel?

Hi everyone, Long time reader, first time poster. I have a Power Query (Main Verification Query) which collects data from a dozen spreadsheets, appends them into a table (TBL_Main_Append_Query), and each record has a unique ID. Unfortunately, the Unique iD is specific to each original...

Hi, I have 50 DAX tables. I would like to change the order of the tables. But every time I move the tables. They go back to the original order (order of when created). Is there not a way to set the order of the tables? Thanks

I have a Front_DB_A with a table called RS and another Front_DB_B with a table called RS_Hist, both are split databases and have tables linked to the Front_DB_A database. My dilemma until we can move it to SQL Server which we are waiting on is that I have a run a query that will combine both...

Hi all, I'm struggling with a macro for automatic formatting tables in a Word document. The macro below, while flawed did work when only tables of a certain format where in the Word file. Now other tables have been added and that breaks down the macro. The macro should only format specific...

Hi All, I have searched the internet for a solution but cannot find one. can someone help me with Power Query in excel. so i have separate tables for items which can contain a varied amount of rows. i then have a merged copy of all these individual tables in another tab as one big table. so...

Hi! I want to take tables from a Word document and put them into excel where the columns are transposed to rows in a certain way. The word document has three tables, each of which can spread across 3 to around 20 pages. Each table has two columns. The first has a table number which tends to be...

I have an Append Qry where I am using 2 tables linked by a key and all have it to where I am providing pop ups to enter specific data. However it has stopped working. Anyone have an issue like this before? Trouble shooting has yielded nothing. The data exists in both tables and the data I am...

Hello everybody, I have two tables in the following format: tblSkills: <tbody> Name ID Function Assembly Drilling Polishing Package Jeremy 001 Operator 1 1 0 0 Rodger 002 Operator 1 0 0 0 </tbody> tblPlanning: <tbody> Date ID State 01.01.2019 001 Assembly 01.01.2019 001 Drilling...

Hello. I have an 2003 access database (mdb file) with all tables having Unknown as owner except one table which has Admin as owner. Is there a way I can use VBA to transfer tables ownership from unknown back to Admin?

Hi I have two excel files stored in Dropbox - one a database that is not opened by users and the other a tool that runs two query tables from the database and is supposed to refresh the query tables on auto_open by setting the connectionstring to the users filepath to find the data source -...

Hi, Can someone derive formulas for I3:I8? Thanks Excel WorkbookBCDEFGHI1Table 1Table 2Table 32CodePriceCodePriceCodePrice3X1$ 2.00Y1$ 1.00X14X2$ 4.00Y2$ 3.00X25X3$ 6.00Y3$ 5.00X36Y17Y28Y3Sheet1