If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Append Query
Hello, I have Adcess2002, when I tried to make an append queiry, I do not see
in the wizzard neither in the ready desingn view, the way to make the append query. Anyone can help us. -- H. Frank Situmorang |
#2
|
|||
|
|||
Append Query
Create the select query.
In query design view, choose Append on the Query menu. Access will ask which table you want to append to. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Frank Situmorang" wrote in message news Hello, I have Adcess2002, when I tried to make an append queiry, I do not see in the wizzard neither in the ready desingn view, the way to make the append query. Anyone can help us. -- H. Frank Situmorang |
#3
|
|||
|
|||
Append Query
Thanks Allen for your explanation. Since the user normally, do not want to go
so many steps. Do you have the sample with VBA that guide user to do it with menu?. Thanks for your help -- H. Frank Situmorang "Allen Browne" wrote: Create the select query. In query design view, choose Append on the Query menu. Access will ask which table you want to append to. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Frank Situmorang" wrote in message news Hello, I have Adcess2002, when I tried to make an append queiry, I do not see in the wizzard neither in the ready desingn view, the way to make the append query. Anyone can help us. -- H. Frank Situmorang |
#4
|
|||
|
|||
Append Query
No. I never ask a user to create an append query, Frank.
What I tend to do is create a form where the user can enter the values (or criteria or whatever) for the query, and then create the SQL statement in code and Execute it. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Frank Situmorang" wrote in message ... Thanks Allen for your explanation. Since the user normally, do not want to go so many steps. Do you have the sample with VBA that guide user to do it with menu?. Thanks for your help -- H. Frank Situmorang "Allen Browne" wrote: Create the select query. In query design view, choose Append on the Query menu. Access will ask which table you want to append to. "Frank Situmorang" wrote in message news Hello, I have Adcess2002, when I tried to make an append queiry, I do not see in the wizzard neither in the ready desingn view, the way to make the append query. Anyone can help us. |
Thread Tools | |
Display Modes | |
|
|