Search results

The code to determine if a control has focus is along the lines of: If Me.ActiveControl.Name = "CommandButtonName" Then End If Hope this helps ^_^

Are you putting the 'Between x AND y' part in the criteria row? Is it possible to get either a screenshot or a copy of the query's SQL?

Assuming you want standard parameter popups each time the query is run, put "Between [Minimum Age:] AND [Maximum Age:]" in the 'Criteria' row of your field.

I'm not certain this will work, but try replacing Like "*" & [Forms]![mainmenu].[searchCombo1] with: IIf([Forms]![mainmenu].[searchCombo1]="",Like "*",[Forms]![mainmenu].[searchCombo1]) This *should*, if I understand your method correctly, provide you with all results when the combo box is...

Not a problem, glad it worked.

I have found a workaround for this that works, but it's....messy. Still, if no one can find better, this works. Rather than editing/creating new entries directly with the form, I have used an append query, run with a button on the form, to take the values from fields in the form and insert them...

This probably isn't the cleanest way to do this, but it works. In the conditional formatting for your Date Field, have three conditions. The first should be Expression is: [chkGrey]=Yes, with font colour set to grey (where 'chkGrey' is the name of your checkbox). The second should be Expression...

For lack of a better option, I have decided to use a dummy table as the target of my data export, then append this data into the main data table in order to reduce the quantity of data that will be lost in the event of an accidental over-write. While this is workable, if anyone does happen to...

An append query will work fine once the data is in Access, but what do you propose for exporting the data from ROO to the database safely? If I were able to ensure that each time a new survey were scanned the user opened the database, ran the append query, cleared the source table and...

I have just finished blundering my way through creating a database for processing survey data into a report format. We receive these reports as paper copies, which are then scanned in using Remark Office OMR. This results in a table of data, which is intended to be appended to the existing table...