Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Forms

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-25-2009, 03:26 AM
Novice
 
Join Date: Mar 2009
Location: Prague, CZ
Posts: 1
wiggles is on a distinguished road
Default Advanced "How to get rid of Enter Parameter Value"

Hi,
I have a form to display a table T in a neat manner in a database. The form is also intended to be exported into (and used in) other databases which have almost identical structure. The only difference is that some fields in T are not present in the other databases. So, naturally, Access annoys users with "Enter Parameter Value" dialog box each time the exported F is updated.
Now, I do not want users to be bothered with the dialog box and I don't want them to modify the form. The goal is to make things work so that users only need to export the form into another database and simply use it without obstacles.

I tried putting
Code:
=Iif( FieldExists("fld","T"), [fld], "")
into the FLD textbox. However, this does not solve the problem when F is used as a subform (which it is, I must confess). Each time another record has to be displayed, the Enter Parameter Value pops up (one for each missing field of course).
Isn't there a way to supress them... once and for all?

Any opinions welcome (constructive even more)

wiggles

PS: That "FieldExists" is a VBA function I found on the net.
Reply With Quote
Reply

Bookmarks

Tags
enter, parameter

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Relate an "If Other Please List" Memo/Text box to a Combo Box skyrise Programming 0 02-24-2009 09:37 AM
Access 2007 application continuous "Calculating..." in status. High CPU usage. pbyrum Access 0 09-25-2008 10:19 AM
Export to .rtf of "104-" converts to "-655&qu Sherri726 Import/Export Data 0 12-19-2006 12:16 PM
Counting "true" checkboxes and ignoring "fals hraup Reports 2 08-31-2006 10:19 AM
"Count" and "Countif" in Reports JMantei Reports 1 06-20-2006 12:20 PM


All times are GMT -8. The time now is 02:50 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.