Search results

I want to create a view that shows all items created in the current month. This is the datasource for a related items control. I'm able to achieve this by using date functions in the where clause, but this doesn't perform very well. My guess is that it is evaluating this formula for every...

OK - I figured it out. The Primary Display Column is based on the display field you select when you set up the lookup column. It seems strange that you are given a drop down to choose the primary display column, I guess sometimes you might want to set it to "not specified" so that you show the...

What do you need to do to make a field available as the Primary Display Field in an Autocomplete control? The table in the Autocomplete control's Row Source has a number of short text columns, but only one of them is available in the drop down list for Primary Display Field.

Thanks Jeff, I suspected that might be the situation, but its good to have it clarified. Great book BTW

My Access Web App includes an Employee table. I have a OnStartup macro that looks up the current user's e-mail address in the Employee table and stores the results in a variable. I use a messagebox to verify that the variable is set to a valid value. I want to use this variable as a default...

Is it possible to use the RequeryRecords action during the OnLoad event for a summary form? I'm having problems with specifying the "Where" clause. No matter what syntax I used, I get the message "Invalid Field". The data source for the form is a view of a single table. I've been able...