opening an other database from a form

[tomyboy]

Read this from Dev Ashish
http://www.mvps.org/accessfr/forms/frm0034.htm
for opening a form in an other db
This seems useful for my job
I've a db named INVOICING making invoice and a 2nd db name
Mini_D_ASDEV checking debit/payment, without relation between them
Then,
1st : is this /frm0034.htm working with Access 2002 under XP as well?
2nd :
my form OPENED is INVOICE from db INVOICING
the database I want to OPEN is "Mini_D_ASDEV.m bd and
the path is D:\1_Database_D evlt
the form in this db I want to open is 002_CREDIT
The fields I want to transfer from INVOICE form To 002_CREDIT form are
:
LASTNAME > CREDNAME
INVOICEDATE > DATCHECK
INVOICEID > SERVICE
CURRENCY > CURR
AMOUNT > CREDRQST_US
3rd : I would use a button click to transfer
4th : as transferred I would the field "Transferre d" from INVOICING db
set to Yes

What I should write as code for these informations ?
Where I should insert this code in the Dev Ashih application ?

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It seems what you really want to do is transfer data from one db to
another. You can do this with an append query. E.g.:

INSERT INTO OtherTableName In "d:\1_Database_ Devlt\Mini_D_AS DEV.mbd"
(CREDNAME, DATCHECK, SERVICE, CURR, CREDRQST_US)
SELECT LASTNAME, INVOICEDATE, INVOICEID, CURRENCY, AMOUNT
FROM LocalTableName
WHERE ... < your criteria > ...

Or, using VBA in a form:

==
dim strSQL as string
strSQL = "INSERT INTO OtherTableName In " & _
""d:\1_Database _Devlt\Mini_D_A SDEV.mbd"" (CREDNAME, " & _
"DATCHECK, SERVICE, CURR, CREDRQST_US) " & _
"VALUES (" & Me!LASTNAME & ", " & _
Me!INVOICEDATE & ", " & _
Me!INVOICEID & ", " & _
Me!CURRENCY & ", " & _
Me!AMOUNT & ")"

CurrentDB.Execu te strSQL, dbFailOnError
==

Change the table names to suit your table names.

See the Access Help articles on the "In Clause" and the "INSERT INTO
Statement."

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP7qE3YechKq OuFEgEQKU2gCg1u VW/XPSEe+jjTwnTHuf C3EJSu4AoKsc
jTHaThfmYX1Dokg 8nKohCVU0
=NCNe
-----END PGP SIGNATURE-----

tomyboy wrote:

Read this from Dev Ashish
http://www.mvps.org/accessfr/forms/frm0034.htm
for opening a form in an other db
This seems useful for my job
I've a db named INVOICING making invoice and a 2nd db name
Mini_D_ASDEV checking debit/payment, without relation between them
Then,
1st : is this /frm0034.htm working with Access 2002 under XP as well?
2nd :
my form OPENED is INVOICE from db INVOICING
the database I want to OPEN is "Mini_D_ASDEV.m bd and
the path is D:\1_Database_D evlt
the form in this db I want to open is 002_CREDIT
The fields I want to transfer from INVOICE form To 002_CREDIT form are
:
LASTNAME > CREDNAME
INVOICEDATE > DATCHECK
INVOICEID > SERVICE
CURRENCY > CURR
AMOUNT > CREDRQST_US
3rd : I would use a button click to transfer
4th : as transferred I would the field "Transferre d" from INVOICING db
set to Yes

What I should write as code for these informations ?
Where I should insert this code in the Dev Ashih application ?

[tomyboy]

Hi MGF
1st Thks and hello from Switzerland/Geneva

Reg. my problem
Not only the transfer of value, but I also want this 2nd form
(002_CREDIT) opened after transfer as there are 15 others fields to be
updated manually. The cycle should be : creating an invoice in INVOICE
form, click a button to open 002_CREDIT and transfer the 5 fields,
close INVOICE form, complete the fields of 002_CREDIT manually and
close it.
Keeping in mind that both db have no connections (I'd too many
problems with our servers when backing up in the past and these db are
shared without replicas-I know that's a fragile application but it's
works properly !)
BUT I don't know VBA and my age doesn't push me to learn it. That's
why I take ideas from various english/french MVP's. Anyway many thks
for your coop.Rgds Michel


MGFoster <[e-mail] > wrote in message news:<xx******* **********@news read2.news.pas. earthlink.net>. ..

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It seems what you really want to do is transfer data from one db to
another. You can do this with an append query. E.g.:

INSERT INTO OtherTableName In "d:\1_Database_ Devlt\Mini_D_AS DEV.mbd"
(CREDNAME, DATCHECK, SERVICE, CURR, CREDRQST_US)
SELECT LASTNAME, INVOICEDATE, INVOICEID, CURRENCY, AMOUNT
FROM LocalTableName
WHERE ... < your criteria > ...

Or, using VBA in a form:

==
dim strSQL as string
strSQL = "INSERT INTO OtherTableName In " & _
""d:\1_Database _Devlt\Mini_D_A SDEV.mbd"" (CREDNAME, " & _
"DATCHECK, SERVICE, CURR, CREDRQST_US) " & _
"VALUES (" & Me!LASTNAME & ", " & _
Me!INVOICEDATE & ", " & _
Me!INVOICEID & ", " & _
Me!CURRENCY & ", " & _
Me!AMOUNT & ")"

CurrentDB.Execu te strSQL, dbFailOnError
==

Change the table names to suit your table names.

See the Access Help articles on the "In Clause" and the "INSERT INTO
Statement."

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP7qE3YechKq OuFEgEQKU2gCg1u VW/XPSEe+jjTwnTHuf C3EJSu4AoKsc
jTHaThfmYX1Dokg 8nKohCVU0
=NCNe
-----END PGP SIGNATURE-----

tomyboy wrote:

Read this from Dev Ashish
http://www.mvps.org/accessfr/forms/frm0034.htm
for opening a form in an other db
This seems useful for my job
I've a db named INVOICING making invoice and a 2nd db name
Mini_D_ASDEV checking debit/payment, without relation between them
Then,
1st : is this /frm0034.htm working with Access 2002 under XP as well?
2nd :
my form OPENED is INVOICE from db INVOICING
the database I want to OPEN is "Mini_D_ASDEV.m bd and
the path is D:\1_Database_D evlt
the form in this db I want to open is 002_CREDIT
The fields I want to transfer from INVOICE form To 002_CREDIT form are
:
LASTNAME > CREDNAME
INVOICEDATE > DATCHECK
INVOICEID > SERVICE
CURRENCY > CURR
AMOUNT > CREDRQST_US
3rd : I would use a button click to transfer
4th : as transferred I would the field "Transferre d" from INVOICING db
set to Yes

What I should write as code for these informations ?
Where I should insert this code in the Dev Ashih application ?

[tomyboy]

Hi MGF
1st Thks and hello from Switzerland/Geneva

Reg. my problem
Not only the transfer of value, but I also want this 2nd form
(002_CREDIT) opened after transfer as there are 15 others fields to be
updated manually. The cycle should be : creating an invoice in INVOICE
form, click a button to open 002_CREDIT and transfer the 5 fields,
close INVOICE form, complete the fields of 002_CREDIT manually and
close it.
Keeping in mind that both db have no connections (I'd too many
problems with our servers when backing up in the past and these db are
shared without replicas-I know that's a fragile application but it's
works properly !)
BUT I don't know VBA and my age doesn't push me to learn it. That's
why I take ideas from various english/french MVP's. Anyway many thks
for your coop.Rgds Michel


MGFoster <[e-mail] > wrote in message news:<xx******* **********@news read2.news.pas. earthlink.net>. ..

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It seems what you really want to do is transfer data from one db to
another. You can do this with an append query. E.g.:

INSERT INTO OtherTableName In "d:\1_Database_ Devlt\Mini_D_AS DEV.mbd"
(CREDNAME, DATCHECK, SERVICE, CURR, CREDRQST_US)
SELECT LASTNAME, INVOICEDATE, INVOICEID, CURRENCY, AMOUNT
FROM LocalTableName
WHERE ... < your criteria > ...

Or, using VBA in a form:

==
dim strSQL as string
strSQL = "INSERT INTO OtherTableName In " & _
""d:\1_Database _Devlt\Mini_D_A SDEV.mbd"" (CREDNAME, " & _
"DATCHECK, SERVICE, CURR, CREDRQST_US) " & _
"VALUES (" & Me!LASTNAME & ", " & _
Me!INVOICEDATE & ", " & _
Me!INVOICEID & ", " & _
Me!CURRENCY & ", " & _
Me!AMOUNT & ")"

CurrentDB.Execu te strSQL, dbFailOnError
==

Change the table names to suit your table names.

See the Access Help articles on the "In Clause" and the "INSERT INTO
Statement."

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP7qE3YechKq OuFEgEQKU2gCg1u VW/XPSEe+jjTwnTHuf C3EJSu4AoKsc
jTHaThfmYX1Dokg 8nKohCVU0
=NCNe
-----END PGP SIGNATURE-----

tomyboy wrote:

Read this from Dev Ashish
http://www.mvps.org/accessfr/forms/frm0034.htm
for opening a form in an other db
This seems useful for my job
I've a db named INVOICING making invoice and a 2nd db name
Mini_D_ASDEV checking debit/payment, without relation between them
Then,
1st : is this /frm0034.htm working with Access 2002 under XP as well?
2nd :
my form OPENED is INVOICE from db INVOICING
the database I want to OPEN is "Mini_D_ASDEV.m bd and
the path is D:\1_Database_D evlt
the form in this db I want to open is 002_CREDIT
The fields I want to transfer from INVOICE form To 002_CREDIT form are
:
LASTNAME > CREDNAME
INVOICEDATE > DATCHECK
INVOICEID > SERVICE
CURRENCY > CURR
AMOUNT > CREDRQST_US
3rd : I would use a button click to transfer
4th : as transferred I would the field "Transferre d" from INVOICING db
set to Yes

What I should write as code for these informations ?
Where I should insert this code in the Dev Ashih application ?