Prev: Checking for Overlapping Events in access 2007
Next: Tables in Access Queries overwritten??? :(
From: Frank Situmorang on 14 Jan 2010 04:23
Hello,

I want a text boxt pop up in order to pass the information . The pop up
will say : Notes taken by:

I want it to do in one go

This is my update query:
INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN, WKTCATAT, Subject, Notes )
SELECT a.NO_URTANGT, a.TGLCATATAN, a.WKTCATAT, a.Subject, a.Notes
FROM [C:\Churchdata\Churchdataconso\BkEnd\Hahomion_be.mdb].Catatan AS a;


Thanks for any help.
--
Frank Situmorang
From: John Spencer on 14 Jan 2010 09:32
Separate field for NotesBy:
INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN, WKTCATAT, Subject, Notes, NotesBy )
SELECT a.NO_URTANGT, a.TGLCATATAN, a.WKTCATAT, a.Subject, a.Notes, [Notes by]
FROM [C:\Churchdata\Churchdataconso\BkEnd\Hahomion_be.mdb].Catatan AS a;

Append to end of Notes field:
INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN, WKTCATAT, Subject, Notes )
SELECT a.NO_URTANGT, a.TGLCATATAN, a.WKTCATAT, a.Subject, a.Notes & [Notes by]
FROM [C:\Churchdata\Churchdataconso\BkEnd\Hahomion_be.mdb].Catatan AS a;


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Frank Situmorang wrote:
> Hello,
>
> I want a text boxt pop up in order to pass the information . The pop up
> will say : Notes taken by:
>
> I want it to do in one go
>
> This is my update query:
> INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN, WKTCATAT, Subject, Notes )
> SELECT a.NO_URTANGT, a.TGLCATATAN, a.WKTCATAT, a.Subject, a.Notes
> FROM [C:\Churchdata\Churchdataconso\BkEnd\Hahomion_be.mdb].Catatan AS a;
>
>
> Thanks for any help.
 | 
Pages: 1
Prev: Checking for Overlapping Events in access 2007
Next: Tables in Access Queries overwritten??? :(