A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Enter Parameter Value on open table in FE



 
 
Thread Tools Display Modes
  #1  
Old February 3rd, 2009, 07:20 PM posted to microsoft.public.access.tablesdbdesign
M Skabialka
external usenet poster
 
Posts: 570
Default Enter Parameter Value on open table in FE

I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields until
it looked right. Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end. I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE. Where is this nag coming from
so I can get rid of it?


  #2  
Old February 3rd, 2009, 08:00 PM posted to microsoft.public.access.tablesdbdesign
Piet Linden[_2_]
external usenet poster
 
Posts: 280
Default Enter Parameter Value on open table in FE

On Feb 3, 12:20*pm, "M Skabialka" wrote:
I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields until
it looked right. *Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end. *I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE. *Where is this nag coming from
so I can get rid of it?


Delete the linked table in the front end and recreate it.
  #3  
Old February 3rd, 2009, 11:08 PM posted to microsoft.public.access.tablesdbdesign
M Skabialka
external usenet poster
 
Posts: 570
Default Enter Parameter Value on open table in FE

This worked - thanks.
Mich

"Piet Linden" wrote in message
...
On Feb 3, 12:20 pm, "M Skabialka" wrote:
I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields
until
it looked right. Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end. I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE. Where is this nag coming from
so I can get rid of it?


Delete the linked table in the front end and recreate it.


  #4  
Old February 4th, 2009, 04:47 PM posted to microsoft.public.access.tablesdbdesign
M Skabialka
external usenet poster
 
Posts: 570
Default Enter Parameter Value on open table in FE

I thought it was fixed but after closing the database and reopening it, the
form the table is used on still gets the Enter Parameter Value window for
that deleted field.

So relinking has NOT fixed the problem.
Where else could it be hiding? I don't want to leave an unused field in the
table just to get rid of the prompt.


"Piet Linden" wrote in message
...
On Feb 3, 12:20 pm, "M Skabialka" wrote:
I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields
until
it looked right. Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end. I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE. Where is this nag coming from
so I can get rid of it?


Delete the linked table in the front end and recreate it.


  #5  
Old February 5th, 2009, 10:30 PM posted to microsoft.public.access.tablesdbdesign
Joan Wild
external usenet poster
 
Posts: 642
Default Enter Parameter Value on open table in FE

Check all the controls on your form to ensure none of them are referring
to the deleted field (perhaps in a calculation)

Check the code behind the form to see if there is any reference to the
missing field.

Check the recordsource for the form (perhaps it's a SQL statement or a
saved query rather than your table).

Joan Wild
MS Access MVP


M Skabialka wrote:
I thought it was fixed but after closing the database and reopening it, the
form the table is used on still gets the Enter Parameter Value window for
that deleted field.

So relinking has NOT fixed the problem.
Where else could it be hiding? I don't want to leave an unused field in the
table just to get rid of the prompt.


"Piet Linden" wrote in message
...
On Feb 3, 12:20 pm, "M Skabialka" wrote:
I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields
until
it looked right. Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end. I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE. Where is this nag coming from
so I can get rid of it?


Delete the linked table in the front end and recreate it.


  #6  
Old February 6th, 2009, 08:14 PM posted to microsoft.public.access.tablesdbdesign
M Skabialka
external usenet poster
 
Posts: 570
Default Enter Parameter Value on open table in FE

It also happens if I open the table from the FE with no form involved at
all.

"Joan Wild" wrote in message
...
Check all the controls on your form to ensure none of them are referring
to the deleted field (perhaps in a calculation)

Check the code behind the form to see if there is any reference to the
missing field.

Check the recordsource for the form (perhaps it's a SQL statement or a
saved query rather than your table).

Joan Wild
MS Access MVP


M Skabialka wrote:
I thought it was fixed but after closing the database and reopening it,
the form the table is used on still gets the Enter Parameter Value window
for that deleted field.

So relinking has NOT fixed the problem.
Where else could it be hiding? I don't want to leave an unused field in
the table just to get rid of the prompt.


"Piet Linden" wrote in message
...
On Feb 3, 12:20 pm, "M Skabialka" wrote:
I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields
until
it looked right. Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end. I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE. Where is this nag coming
from
so I can get rid of it?


Delete the linked table in the front end and recreate it.



  #7  
Old February 7th, 2009, 10:01 PM posted to microsoft.public.access.tablesdbdesign
Joan Wild
external usenet poster
 
Posts: 642
Default Enter Parameter Value on open table in FE

Check all the properties of the table (in design view, choose
properties) - not just the filter property, but also the sort order.

Check all the properties of each field in the table (perhaps a
validation rule, possibly lookup properties?)

Check the indexes you have defined for the table.

Joan Wild
MS Access MVP


M Skabialka wrote:
It also happens if I open the table from the FE with no form involved at
all.

"Joan Wild" wrote in message
...
Check all the controls on your form to ensure none of them are referring
to the deleted field (perhaps in a calculation)

Check the code behind the form to see if there is any reference to the
missing field.

Check the recordsource for the form (perhaps it's a SQL statement or a
saved query rather than your table).

Joan Wild
MS Access MVP


M Skabialka wrote:
I thought it was fixed but after closing the database and reopening it,
the form the table is used on still gets the Enter Parameter Value window
for that deleted field.

So relinking has NOT fixed the problem.
Where else could it be hiding? I don't want to leave an unused field in
the table just to get rid of the prompt.


"Piet Linden" wrote in message
...
On Feb 3, 12:20 pm, "M Skabialka" wrote:
I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields
until
it looked right. Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end. I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE. Where is this nag coming
from
so I can get rid of it?
Delete the linked table in the front end and recreate it.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:35 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.