Question You are subscribed to this thread
Applies to Office Access Windows 10 Office 2016
3 views
need help in data on access
SYSnirben yossef asked on January 3, 2017See post history
Hi guys,
Problem 1:
i have a form with TabControls inside one of the Tabcontrol i have other Tabconrol. and inside one of the pages i have a subfrom that i can add items to by ID
so i create a macro to open the "ItemsTable" in a new window when i click on a new entry.
but how can i make the ID go to the subfrom and copy it there.
any help?
Problem 2:
ihave two tables
"Catalog"
"CatalogDetails"
in "CatalogDetails" Table i have a field of "IDCatalog" its Relate to the "ID" in the Catalog Table.
So i create a form with the CatalogDetails table and add fileds from the "Catalog" table
Also i have a Field in "Catalog" table "KGM",
and in the CatalogDeatils table i have a field name: "KGMfromCatalog"
when i put the ID lets say 12 i get all the info form the Catalog table.
but i want also to copy the "KGM" Vaule from Catalog Table to the "KGMfromCatalog" Vaule in table "CatalogDetails" in order to see it on the other table.
can someone help me with that?
Applies to Office Access Windows 10 Office 2016
3 views
need help in data on access
SYSnirben yossef asked on January 3, 2017See post history
Hi guys,
Problem 1:
i have a form with TabControls inside one of the Tabcontrol i have other Tabconrol. and inside one of the pages i have a subfrom that i can add items to by ID
so i create a macro to open the "ItemsTable" in a new window when i click on a new entry.
but how can i make the ID go to the subfrom and copy it there.
any help?
Problem 2:
ihave two tables
"Catalog"
"CatalogDetails"
in "CatalogDetails" Table i have a field of "IDCatalog" its Relate to the "ID" in the Catalog Table.
So i create a form with the CatalogDetails table and add fileds from the "Catalog" table
Also i have a Field in "Catalog" table "KGM",
and in the CatalogDeatils table i have a field name: "KGMfromCatalog"
when i put the ID lets say 12 i get all the info form the Catalog table.
but i want also to copy the "KGM" Vaule from Catalog Table to the "KGMfromCatalog" Vaule in table "CatalogDetails" in order to see it on the other table.
can someone help me with that?
