The code 'stop' is called a breakpoint. It is a debugging tool in the VBA Editor. Refer to link at bottom of my post.
The code 'stop' is called a breakpoint. It is a debugging tool in the VBA Editor. Refer to link at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
rasto
Earlier you said "you know this" in answer to a previous post.
However none of us are clear about what you really do know
The issue appears to be that you do not understand the basic principles of working with databases
That's not a criticism - all of us were beginners at some point.
However I do strongly recommend that you learn the basics before proceeding
There are some excellent videos on You Tube which you could watch - those by Steve Bishop or Richard Rost are both excellent
Coming back to the append queries
In your 2 screenshots there is a View button - single click a query to select it then click View - Design view.
This is an example from one of my databases
Look at the query design carefully. It shows the table(s) involved & fields that will be appended to
Click the append button in the ribbon to see the name to the table that will have new records appended
For example:
You can also click on View ...Datasheet view to see the records that will be appended - remember the number it shows
If you want to proceed, click Run
As you have seen, Access will ask you to confirm that you want to run the append query.
If you choose Yes, it will then tell you how many records will be appended - same number as you saw in the datasheet view
If you choose Yes it will go ahead and append them.
It doesn't show you those records after they have been appended - most users would find that very annoying
BTW - you can click No to either dialog box to cancel the append query
HTH
The easiest way to work out what a query is doing is to look at the sql. To open the sql window, in the query designer see the sql option under the far left button on the ribbon - or there is a sql option bottom right of the acces window
the construction of sql code follows a set pattern. A basic select query (one to view and used to populate forms and reports) has these sections
SELECT these fields
FROM this table/these tables joined on these field
WHERE some criteria to limit what will be returned
a group by query is an extension of this to sum/count/etc values
SELECT these fields and sum these other fields
FROM this table/these tables joined on these fields
WHERE some criteria to limit what will be returned
GROUP BY these fields
HAVING some criteria based on the summed/counted fields
then you have action queries to append, update or delete
append is constructed
INSERT INTO this this table and to these fields
These fields FROM this/these tables
WHERE some criteria to limit what will be appended
etc - I'll leave you to research the other types
There are some shortcuts the * means all fields for example
the queries can be more complex in terms of the criteria, but the basic structure remains the same.
Access does not lay out the sql, but it becomes clearer if you do so e.g.
Code:SELECT Field1, Field2, FROM mytable WHERE field3=somevalue