Rabu, 13 Januari 2016

Re: [MS_AccessPros] Can't find the parameter

 

Bill

There is a free add-in called V-Tools that can do a deep search for just about anything: fields, controls, code, etc. You can download it at http://www.skrol29.com/us/vtools.php 

Regards,
Bill Mosca

From: "'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, January 13, 2016 7:28:39 AM
Subject: RE: [MS_AccessPros] Can't find the parameter

 

I found it, just poking around due to desperation.  It was part of a query behind a combo box.

 

Thanks for the tip.

 

Bill

Minnesota

  

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, January 12, 2016 1:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Can't find the parameter

 

 

Bill-

 

Try opening the form in Design view, changing the Record Source to something else (doesn't matter what), then changing it back.  That will refresh the form field properties.

 

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

(Paris, France)

 

 

 

On Jan 12, 2016, at 8:39 PM, 'Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

I have Access 2013 database that tracks customers and creates invoices.  The person I am designing this database for wants the State information in the address to be a combo box.  So I have been converting the forms.  Now I have a problem.   When I open one of my forms I get a box that asks for the parameter for   t_Organizations.orgSt   .  This is the old State field prior to converting it to a combo box.

 

In the table  t_organizations  I have deleted the field called   orgSt.

 

In the query for the form there is no such field.

 

I can't figure out where the form is calling for    t_Organizations.orgSt

 

Is there any way to do a database search for an item like this?

 

Thanks for all your help.

 

Bill

Minnesota   -13 degrees this moring.  

 

 



__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar