![]() |
|
|
#1
|
|||
|
|||
|
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], "")
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. |
|
| Bookmarks |
| Tags |
| enter, parameter |
| Thread Tools | |
| Display Modes | |
|
|
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 |