Search results for query: *

Actually, picking the field from a table of fields would work very well. E.g. a table with a record for each field name I want to select.

Yes. Often I want to append data from many columns in one table to one column in another...like a reverse cross-tab query.

Yes. For example, I'm often appending data from several fields into a table of few fields. A lot like a reverse cross-tab query. So, I would like to be prompted for the field to append in a dynamic fashion rather than manually changing the field each time. Also, I wonder if I can relatively...

Access 97: is there a way to dynamically reference fields in queries/reports using controls? That is, if I want a field in a query to be "Amt 1" this time and "Amt 2" or 3 or whatever after this, can I have a control prompt me for the field name and give me the field...

You can either import the id field into the autonumber, or, you may need to import 1 record with the ID number you wish to start with and it will then increment from there. I've found ways around this issue in the past and there was something in the Access help file. Ken

Answered my own question. Find the "junk senders.txt" and copy to appropriate directory on second computer. I did have to make sure it went into the correct profile, as I did not have Windows hardware profiles set up on the original laptop. Ken

Yesterday I suddenly started receiving the message "There is no object in this control" when the export table to text wizard starts. This is in Access 97. Anyone run across this and have suggestions for a fix? Ken (kvw@bossnet.com)

I'm using Outlook 98 on 2 different laptops. I've exprted and imported rules, but can't seem to find a way to succesfully migrate my junk senders (which keeps growing and growing and growing....). Any ideas how I can migrate, without retyping, my list of junk senders from one cmputer to the...