Hello! Happy Christmas/holidays to you all
I have this huge table named "Positions" with more than 160 fields of which the fields are named with non obvious abbreviations.
I have another table named "definition s" which has the column name and definition fields.
In order to help me all along my forthcoming developments, I would like to use these definitions from table "definition s" into "Positions" . Of course i can manually copy each definition, one by one but there is a risk of error and also, the table "Positions" might be updated by the party which delivers it to us... so automatic might be better over the long term in this case.
What are the automatic options?
- Import once?
- Is it possible to link the description field of "Positions" with the "Definition s" table?
Thank you in advance for your input guys.
Best regards
10 4319 PEB 1,418
Recognized Expert Top Contributor
So i n the table definitions u have other fields out of those 160 in Positions?
and u want to add those fileds from definitions to Positions...
If they a large size those fields u can have a pb with Access! There can't be more than 255 fields into an Access table! And can tell u that if u have more than 220 fields u will have problems...
So i don't think as a good idea to import more fields in Positions.
So my suggestion...
Create tirth table and in this table create 3 fields:
ID_Position, ID_definition and Value
In this structure u can introduce info for each position and definition that u have!
Is this helpful?
Table "positions" is made of 160 fields but there are no field definitions
I am looking to add automatically the definitions of these fields by importing them from table "defintions "
Table definitions includes the following fields:
"Field" which actually matches the "positions" table fields names.
and "definition "
THank you
PEB 1,418
Recognized Expert Top Contributor
Table "positions" is made of 160 fields but there are no field definitions
Table definitions includes the following fields:
"Field" which actually matches the "positions" table fields names.
and "definition "
THank you
What do u mean under field definition? Validation Rules, Keys, Indexes, Validation text, Size? All of those properties of each field can be considered as Field definition! So tell me what property of the field u want to update automatically?
Principally programatically can be done while the field is created! When the field is created i'll check TableDef properties in Access help for more info!
I mean Field description which is displayed in the status bar when this field is selected. Sorry for misunderstandin g.
I was thinking about another mean of getting to the point:
for example: a text popup showing when hovering over the field on table or form view.
thanks!!!
I mean Field description which is displayed in the status bar when this field is selected. Sorry for misunderstandin g.
I was thinking about another mean of getting to the point:
for example: a text popup showing when hovering over the field on table or form view.
thanks!!!
So would you say that what you want to do is automate the process of loading a bunch of text entries from one table ("definition s") into the descriptions for the corresponding fields in the table "Positions" ?
This doesn't seem as though it would be excessively difficult. I'm sure that with all the Access experts here we can work something out.
Yes, that's exactly what I'm looking for!
NeoPa 32,569
Recognized Expert Moderator MVP
If it's just the Description of the field you're looking for then it can be found by referencing : - CurrentDb.TableDefs("TableName").Fields("FieldName").Properties("Description")
You would have to cycle through the fields (Fields can also be referenced via their number) and update each one with the next item from the Definitions table.
If it's just the Description of the field you're looking for then it can be found by referencing : - CurrentDb.TableDefs("TableName").Fields("FieldName").Properties("Description")
You would have to cycle through the fields (Fields can also be referenced via their number) and update each one with the next item from the Definitions table.
So NeoPa, how would I go about referring to the Description property in a field definition object? I seem to recall that I've had problems with this in the past.
As I see it, the actual process required will be quite simple. Something along these lines (just rough pseudo-code, the syntax will be all wrong)... - Dim fld As Field
-
For Each fld In CurrentDb.TableDefs("Positions").Fields
-
Go look up fld.Name in the "Definitions" table
-
fld.Description = text found in "Definitions"
-
' Do I need to update fld, or is that automatic?
- Next
-
NeoPa 32,569
Recognized Expert Moderator MVP
So NeoPa, how would I go about referring to the Description property in a field definition object? I seem to recall that I've had problems with this in the past.
As I see it, the actual process required will be quite simple. Something along these lines (just rough pseudo-code, the syntax will be all wrong)... - Dim fld As Field
-
For Each fld In CurrentDb.TableDefs("Positions").Fields
-
Go look up fld.Name in the "Definitions" table
-
fld.Description = text found in "Definitions"
-
' Do I need to update fld, or is that automatic?
- Next
-
That's about the size of it.
It is a property of an object (if that helps) rather than data within a record so no .Edit / .Update required.
You may need a For IntegerVar type construct instead though, as the records in the other table would be likely to be positionally dependant.
HTH -Ade.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Fiala |
last post by:
Table A
+--------+-----------+
| A-num | text |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
+--------+-----------+
|
by: sparks |
last post by:
I was copying fields from one table to another.
IF the var name starts with milk I change it to egg and create it in
the destination table.
It works fine but I want to copy the description as well.
Short version :)
For Each fld In tdf.Fields
pos = InStr(fld.Name, "milk")
If pos > 0 Then
|
by: bitoulis |
last post by:
Hi,
is it possible to use the records of a table as the field names of
another table?
If yes, how is it done?
Thanks in advance
Laertes
|
by: Leonardo Gangemi |
last post by:
How to align right a table based on another table created dinamically?
Leonardo
|
by: S0ck3t |
last post by:
Please could I have some help on matching records between tables. I
want to return a check (true/false) stating whether the field
combination in table 1 occurs in table 2. Obviously it's easy with just
one field, but two is more problematic.
I have the following
Table1
--------
field1
| |
by: Shizbart |
last post by:
MS Access 97
Beginner/Moderate Level User
I am trying to create a Database to track Workouts in MS Access 97.
I have one Table named Workouts that contains the following Fields: Workout Code (e.g: U100), WorkoutActivity (e.g.: Bench Press: Flat Bench Straightbar) (note: this is the Primary Key of this Table), and Target Area (e.g.: Upper Body / Chest).
A second Table named Workout_Log contains the following Fields: Date,...
|
by: joshua.nicholes |
last post by:
I have an access database that consists of two tables.A data
collection table and a species list table. The data collection table
has about 1500 records in it and the species list has about 600. The
species list has 7 fields the first is a four digit unique identifier
(species) it is set as the primary key. I have created a relationship
to the data collection table which also has a species field (4 digit
id). In my form I have the species...
|
by: MrCrunchy |
last post by:
Hi All
I have 2 tables (as shown below), if i add a row to the FILES TABLE then the myid value is added to mydata list in the PLAYLISTS TABLE, based on the genre matching the myname values.
Hope this makes sense.
So my question is how do i add myid to mydata when new files are added to the FILES TABLE.
Thanks
FILES TABLE
filepath.........artist..............album.....genre.......myid...
|
by: Arielle |
last post by:
Problem:
I have a few related tables that collects information about a given publication. The information collected varies based on the type of collection and is stored in a few different tables. The latest requirement the customer wants is to alert the faculty when a publication is added that is 90% similar to another publication. To facilitate this I want to create a flat lookup table that I can easily query and manipulate.
The Database
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |