Re: Running select and append queries to find data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm not sure how you expect users to select/filter records and why they
would append and keep duplicates.

Your questions are really vague so it is difficult to provide any
assistance.

--
Duane Hookom
MS Access MVP
--

"bamf" <bamf@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6498C0A0-CCF0-47B9-9C4A-18B609264043@xxxxxxxxxxxxxxxx
>i am quite confident (i think) about writing the append tabel, to run from
> the select query that hopefully will run earlier in the macro. It is the
> selct query i am unsure of as the criteria for selection will be entered
> manually when a record is being located. does this sound sensible?
>
> "Duane Hookom" wrote:
>
>> How far have you progressed? Do you have an append query created? Do you
>> know how to add criteria to a query so that only specific records/rows
>> are
>> returned from the query?
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>>
>> "bamf" <bamf@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:720256D5-FFAC-4EB0-93FF-0401C102A7D8@xxxxxxxxxxxxxxxx
>> >I want to be able to run a macro from a command button that allows for a
>> > specific data set to be found and then appended to a seperate table. I
>> > have
>> > a central table that holds all info, and i want to ne able to type in
>> > 'surname' for example and access the relevant data set which wold then
>> > be
>> > appended into a subsiduary table. Any help would be great!!!
>>
>>
>>


.

Quantcast