Re: Parameter dialog box pops up

Please ask this as a new question (if you have not already done so.)

Databases are very different to spreadsheets. Lots of tables with the same
structure is not the way to design a database.

--
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.

"Clement" <Clement@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C5E88810-13F8-4C43-AF3B-99351ED1B50E@xxxxxxxxxxxxxxxx
>I got the tables fixed somehow; I deleted those Append queries and removed
> the subdatasheets in the Tables. (im thinking removing those queries
> resolved
> the problem of my pop up dialog box ...and yes I was equally perplexed to
> see
> a Parameter dialog box upon opening a Table. For a query yes it makes
> sense).
>
> Anyway I still need to solve my main problem. Here it is:
> I need to update my Access database from an Excel list. (The fields in the
> DB and Excel are identical....I am creating the DB from the list). Now I
> will
> be recieving a list from time to time and I need to transfer this new
> infor
> into the Access DB.
>
> I suppose I should export the Excel list into a new TableN in my Access DB
> and work from there. The question is how do I append each field from
> TableN
> into their respective tables? (The only solution I have so far is create
> an
> append query for each table from my TableN and run them separately).
> How can I make this process (updating my tables from the List) better??
> --
> Clement E
>
>
> "Allen Browne" wrote:
>
>> Parameters relate only to queries, not to tables.
>>
>> When you view the data in the table, do you have any fields that show as
>> combo boxes? If so, the combo could have a query statement as its
>> RowSource
>> property, and the parameter could be coming from there.
>>
>> It that is the case, you could fix the RowSource statement, or you might
>> prefer to switch the DisplayControl back to a text box. See:
>> The Evils of Lookup Fields in Tables
>> at:
>> http://www.mvps.org/access/lookupfields.htm
>>
>> --
>> 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.
>>
>> "Clement" <Clement@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:A4A12005-D516-4596-AC58-2CFDB58CD738@xxxxxxxxxxxxxxxx
>> > Whenever I open the "Members" Table, Access prompts me for a parameter
>> > value;
>> > a dialog box pops up that says "Enter Parameter Value". I dont recall
>> > creating any parameters for the Table. Its doing the same with my
>> > Append
>> > Query; whenever I try to run the Append Query, Access asks for a
>> > parameter
>> > value. I simply want to run the Append Query to copy the fields
>> > (according
>> > to
>> > the SQL in my query box) into the Members Table.
>> > How do I prevent the Parameter box from popping up?
>> > --
>> > Clement E
>>
>>
>>


.