Hello,
Sorry for question. I would like to open a table for viewing and change a fieldname, but the fieldname is not changed. How can I make this to work?
/P
Please Login or Register to view this content.
Hello,
Sorry for question. I would like to open a table for viewing and change a fieldname, but the fieldname is not changed. How can I make this to work?
/P
Please Login or Register to view this content.
Last edited by alansidman; 11-18-2020 at 01:19 AM.
you cannot change a field's name by using the tableDefs collection and reference the .fields() index without setting an object. I don't believe anyway. the best way to do this, which is a very common method used in every web-based database in the world, including SQL server, MYSQL, Oracle, MongoDB and others, called DDL (data definition language). However, you cannot change a field name with that technique very easily. at least not in one statement. thus, you should rename it using VBA code, modified from what you already have. try this:
if that doesn't work, you'll have to use DDL more than likely.Please Login or Register to view this content.
Thanks again! I got it to work. I created two different functions.
Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html
(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi,
I dont have a DMD, I use 2 screens. But in this table with BAM I cannot see the display on the DMD1 and DMD2 that I can see in the editor.
So im not able to see score, count of ball etc....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks