Enter Parameter Value upon opening the database

Hello,
It as been several years since I completed this database. I am now in the process of enhancing it.

Currently, I am getting the error

Enter Parameter Value
QREVALUE.SortCompletion Date

I can clear this request and the database will give me 11 more before going away. I that I have the problem occuring 12 different times and I know that they are related to my "NAMC" that I have 12 of in the database. However, I can not find the reference to .SortComplettion Date.

This field was once used in my QREVALUE Table. However, now I can not find any reference to this item.

This appears on opening the database. How can I track this request down and remove it from the database?
ggodwinQuality EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbizupNerdCommented:
Try using Rick Fisher's Find and Replace tool to track down references to that field:

http://rickworld.com/
mbizupNerdCommented:
Also try searching on SortCompletion rather that "SortCompletion Date"
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Was [SortCompletion Date] removed from the  table QREVALUE?  If yes, you may wnat to add it back to see if the error go away. If yes, then you will need to track down all the places the field was used and update it to the new field or remove it.

TIP: Document your database.  



Where to find startup routines:

Do you have an AutoExec Macro? If yes look there.

Do you have a Start Form defined? Is yes, look in the Form's On Open, On Load, On Current  events.

TIP: Hold down the shift key while opening the database to bypass any start-up routines.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Dale FyeOwner, Dev-Soln LLCCommented:
It sounds like it is in a query that is being run by your startup form.

So I would start by opening your startup form in design view.  Check the RecordSource property for the form.  Then check the RowSource property of any combo or list boxes that are part of the form.

If you still cannot find it, try this.

Public Sub SearchQueries(SearchFor As String)

   Dim db As dao.Database
   Dim rs As dao.Recordset
   Dim strSQL As String

   strSQL = "SELECT [Name] as qryName FROM msysObjects WHERE Type = 5"
   Set db = CurrentDb()
   Set rs = CurrentDb.OpenRecordset(strSQL, , dbFailOnError)

   While Not rs.EOF
        If InStr(db.QueryDefs(rs![qryName]).SQL, SearchFor) > 1 Then
             Debug.Print rs![qryName], db.QueryDefs(rs![qryName]).SQL
        End If
        rs.MoveNext
   Wend

   rs.Close
   Set rs = Nothing
   Set db = Nothing

End Sub

Open in new window

Finally, if that doesn't work, go out and download Rick Fishers Find & Replace add-in.  I think you can download the trial for 30 days, but I think it is only
ggodwinQuality EngineerAuthor Commented:
It looks like I have two problems.
A.) The problem that this thread was started for.
B.) Trying to get the "http://rickworld.com/" Find and Replace tool installed.

Re: The tool installation, I am getting this error
"the Database is in an unrecognized format"
The database may have been created in a later version of Microsoft office than the one you are using.....Upgrade Blah, blah, blah

Now, I'm going to try to use some of the other options and start a new thread for the Find and Replace.
ggodwinQuality EngineerAuthor Commented:
Was [SortCompletion Date] removed from the  table QREVALUE?  If yes, you may wnat to add it back to see if the error go away. If yes, then you will need to track down all the places the field was used and update it to the new field or remove it.

I added this and the errors went away. However, I really want to track down all the links and remove them.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
I really want to track down all the links and remove them.

It can be done.  I have done it manually many time without the purchase of any tools. I also use this time to document the database.

I create a blank ne front end. I link all the tables. I  import one object at a time into the front end.  I start with the AutoExec macro or the start up form. I run it to see what is missing and the import it. I continue the cycle until I have the start up routine imported.  You will gain valuable knowledge about the database by doing this that you just can't get using any tool or documetor.
Dale FyeOwner, Dev-Soln LLCCommented:
did you try the code for looping through the queries and checking the SQL for each of the queries?

If it is not in one of the queries, it is probably in the RecordSource of one of your forms or in the RowSource of a combo or listbox.  The other place to check would be the Filter and OrderBy properties of forms.

If you were using that field in a filter or had ordered the form by that column, and then saved the form, those properties will retain those values.
ggodwinQuality EngineerAuthor Commented:
I've requested that this question be deleted for the following reason:

The database was missing many items. I found it easier to start over. When I did the problem in this question was resolved.
mbizupNerdCommented:
<<
I found it easier to start over. When I did the problem in this question was resolved.
>>

I'm glad that you were able to resolve it that way, but that doesn't invalidate the responses you received to your original question:

"How can I track this request down and remove it from the database?"


I understand you had issues with Find and Replace - which I believe could have been resolved (it is tried and true by many of the regulars here for exactly this sort of purpose), but you also received other solid responses to your question.

Rather than deleting the thread, I recommend accepting your own comment and awarding points to http:#a39758542 and http:#a39758987
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.