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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|