Rabu, 13 Januari 2016

Re: [MS_AccessPros] Can't find the parameter



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 

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.






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





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.



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:

Posting Komentar