J
Joergen Bondesen
Hi NG.
I have a:
Table_1
Query_1
Query_2
Report_1
Form_1
Module_1 with 1 macro.
In my Formula_1 I have a ButtonA to activate Module_1 where I Delete all
records in Table_1 and import a txt-file to Table_1.
With ButtonB I can activate Report_1. Next to this Button I want count from
Query_2.
Query_2 (Count records in Table_1 (by using Query_1) and is also for Excel):
SELECT Count(Ellos_SE_Alm_Q.Postby) AS SE_Alm
FROM Ellos_SE_Alm_Q;
I have Query_2 as a SUBform in Form_1.
My problem is that I must close/open Form_1 for update and that is annoying.
I do hope for a SQL in my Module_1.
Perhaps the Sub form is not necessary?
Can someone help me?
I have a:
Table_1
Query_1
Query_2
Report_1
Form_1
Module_1 with 1 macro.
In my Formula_1 I have a ButtonA to activate Module_1 where I Delete all
records in Table_1 and import a txt-file to Table_1.
With ButtonB I can activate Report_1. Next to this Button I want count from
Query_2.
Query_2 (Count records in Table_1 (by using Query_1) and is also for Excel):
SELECT Count(Ellos_SE_Alm_Q.Postby) AS SE_Alm
FROM Ellos_SE_Alm_Q;
I have Query_2 as a SUBform in Form_1.
My problem is that I must close/open Form_1 for update and that is annoying.
I do hope for a SQL in my Module_1.
Perhaps the Sub form is not necessary?
Can someone help me?