Search results for query: *

Thanks again Rick. I guess I should have known that already. It worked like a charm. Now the users can click little buttons with the letters of the alphabet on them and zoom to the first list item starting with that letter. The list usually has around 2200 items and this trick will speed-up...

Thanks Rick, I'll give it a try and repost the results.

I have a combobox with several columns and lots of records. I want to be able to cause the combobox to scroll down to a specified record in VBA code. I have looked throught postings and some come close to being like what I want but none directly address this trick. Can anybody help me? Please...

I have a form that is opened as modal and a button on that form that opens a report. The problem is that report shows up behind the form. How can I get around that? I don't want the users to have to close the form or to change the form so that it is not Modal. Any suggestions will be greatly...

Here is one possible way. In a blank column in the query grid put: Intermediate1: iif(isnull([MonthA]),0,[MonthA]) + iif(isnull([MonthB]),0,[MonthB]) + iif(isnull([MonthC]),0,[MonthC]) + iif(isnull([MonthD]),0,[MonthD]) + iif(isnull([MonthE]),0,[MonthE]) in another blank column put...

Select the comboBox on the form, open the properties dialog (View, Properties), click the Data tab, delete the field name value from Control Source property (first property on the Data tab). At that point it is no longer bound to any field yet it will still do the lookup and put the value in the...

It sounds like you have the comboBox bound to a field in the same table that is the rowsource. When a comboBox control is bound to a field and you click one of the items in the list it will update that field in the current row of the form. If you just want to lookup a name but not have it update...

Does anybody know why an Access 2K form would display field contents in bold and the background of button captions as white. It alternates between a normal looking form and that while navigating from record to record. And then when I leave the form I get the error "There isn't enough free...