Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access courses - Multi user database

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access courses - Multi user database

Resolved · Low Priority · Version Standard

Reply Wed 13 Jun 2007, 09:54Delegate Ricardo said...

Ricardo has attended:
Access VBA course
Access Advanced course

Multi user database

Can multiple IIF statements in a form significantly slow the form down?

Thanks

Ricardo

For upcoming training course dates see: Pricing & availability

Reply Thu 14 Jun 2007, 16:31Trainer Carlos said...

RE: Multi user database

The simple answer is No.

Regards

Carlos

Reply Tue 19 Jun 2007, 12:45Delegate Ricardo said...

RE: Multi user database

Thanks Carlos. I ask as I have a database split into fe/be and I found that the forms on the front end with the IIF statements were very slow, but when they were taken out the form was much faster, also during the pause the form says "calculating..." in the status bar.

Would IIF statements on a form cause a slowdown effect in such a case where they look up information in a back end database of roughly 5Mb)?

Thanks again

Ricardo

Access articles

· So what's new in Access 2007?
· How To Use Calculation Fields In Microsoft Access
· How To Use Concatenation In Access To Create A Custom Lookup
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· An Essential Guide To Using The Northwind Database In Access 2010

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips