Hi Chaps,
I have built a database that is using the sql code below to dump a list of components from a SQL data warehouse into the access database.
Whilst the access file is in one piece this works fine.
When I split the database into front and back end, it then falls over.
If a product has 14 components for example, it will enter 14 lines of the first component, instead of 14 lines of different components.
How do i resolve this when the database is split and all the tables are then links?
The table im dropping them into is tbl_temp. Mo1 is the MO number taken from an Input box field.
From SQL:
EIT_GB_MVXCDTA_MWOMAT - The table i'm getting the data from
VMMTNO - Item number
VMMFNO - MO number
VMMSEQ - Component sequence number
I have built a database that is using the sql code below to dump a list of components from a SQL data warehouse into the access database.
Whilst the access file is in one piece this works fine.
When I split the database into front and back end, it then falls over.
If a product has 14 components for example, it will enter 14 lines of the first component, instead of 14 lines of different components.
How do i resolve this when the database is split and all the tables are then links?
The table im dropping them into is tbl_temp. Mo1 is the MO number taken from an Input box field.
From SQL:
EIT_GB_MVXCDTA_MWOMAT - The table i'm getting the data from
VMMTNO - Item number
VMMFNO - MO number
VMMSEQ - Component sequence number
Code:
Dim db As DAO.Database
Set db = CurrentDb
db.Execute "Insert Into tbl_temp (Comp) Select VMMTNO From EIT_GB_MVXCDTA_MWOMAT Where VMMFNO=" & [Mo1] & " Order By VMMSEQ;", dbFailOnError
Set db = Nothing