473,322 Members | 1,379 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

parameter errors after changing the table

When I change fields in a table then open a form, report or query it asks for the parameter. Why does it do this & how do I fix it?
I've had this problem when using 2003 & 2007.
Any help will be much appreciated!
Thanks!
Nov 6 '08 #1
3 1092
missinglinq
3,532 Expert 2GB
How did you "change fields" in your table? Did you add or delete fields? Did you change the names of fields? My guess would be that the misbehaving forms and reports are based on one or more queries and you have not updated your queries to include the changes.

Let's say your table has a field named "StTime" and you decide, in order to make it clearer what kind of data it holds, to change the name to "StartTime." You also have a query based on this table with the field included. When the query runs, it expects data from your table for a field named "StTime" but won't find it; the field with that name no longer exists. The same thing would occur if you deleted a field from your table.

You need to go to the Queries Tab and open your query in Design View, and then make the appropriate modifications. Change the names of fields, if they've changed. Delete fields from the query if they've been deleted from the underlying table.

Also, it you add fields to your table, remember to add these to the query if you'll need to access them from a form or report. Otherwise, they won't show up the the Field List on the form or report.

Welcome to Bytes!

Linq ;0)>
Nov 6 '08 #2
Thank you so much!! That completely answers my question.
I was adding fields, deleting them & changing names.
It never dawned on me to go back into design view in the queries, forms & reports. I think for some reason I thought it should do it automatically.
Thank you again!!!
Nov 6 '08 #3
missinglinq
3,532 Expert 2GB
Glad we could help!

Linq ;0)>
Nov 6 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Michelle Kinsey-Clinton | last post by:
Hello, I am writing an ASP app which is giving me some very frustrating errors. They appear intermittently, no real pattern to them, and often go away if you reload, or back up a few pages and...
4
by: Dan | last post by:
I've run into an interesting problem, and seemed to have stumped 3 newsgroups and 2 other forums. For some reason when I try to insert a record into a SQL table that has a Text column, the...
0
by: rodneybauer1 | last post by:
i tried explaining this yesterday...here's a better formed question. thanks using Northwind sql database, and an oledb connection to it a datalist is bound to the productID and ProductName of the...
23
by: John | last post by:
Last year, I remember finding a web page describing how to pass the name of a file to another web page, and have that web page load that image file. Now, I can't find my record of that (it was...
6
by: Andy | last post by:
Hello, I am having many problems with setting up a parameter query that searches by the criteria entered or returns all records if nothing is entered. I have designed an unbound form with 3...
8
by: Alec MacLean | last post by:
Hi, I'm using the DAAB Ent Lib (Jan 2006) for .NET 2.0, with VS 2005 Pro. My project is a Web app project (using the WAP add in). Background: I'm creating a survey system for our company, for...
0
by: ngoodearl | last post by:
Hi, I have upsized an access db to a sequel 2000 db. The db is used to perform a series of calculations to get a result. The user inputs the required parameters into a form and the data entered is...
10
by: SQL Server | last post by:
I am writing a function which will take two parameters. One the field to be returned from a table and second parameter is the ID of the record to be returned. Problem is it's not returning the...
13
by: frakie | last post by:
Hi 'body, I'm experiencing difficulties on parameter passing. I wrote a library in last months, and now it crashes few times in a month because of errors in parameter passing: using gdb on the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.