Search results for query: *

I have a combo box with about 120 items on the list. Sometimes when I click on it it only allows me to see some, maybe 30 of the items on the list. If I remember and type in an item on the list, but not shown, it does pop in autofill. Is there anyway I can prevent only the partial list from...

I have a table with 3 fields: ContName, ContNo and CM. On a form, from a Combo Box, I would like to choose the ContNo which fills in the ContNo field and also automatically fills in the ContName and CM in the ContName and CM fields on the form. I did this a few years ago, but I forgot how to...

I thought I read somewhere that you insert the current date/time into a field on a form by choosing a function key, but I can't find a reference to this anymore. Can someone tell me if this can be done. I am not interested in the default current date/time property. No code please. Thanks

I would like my report to print “Overdue” only when nothing has been received from A, i.e., the “Date from A” is Null AND the Days Held exceeds the “DaysR”. Below are the expressions I am using. The problem – I am getting “Overdue” for items that have not yet been returned (but don’t exceed...

I need an IF statement that I can use in a Query that will provide an "OVERDUE" if both of two conditions are met. I thought there was a way that you can combine two IF statements to do this. When I enter the below in my Query, I get an error "Undefined function 'IF' in...

Please tell me why, when I enter the expression below, I get an error and dialog box which says Enter Parameter Value for today(). I have also tried Date() and Now(). DaysHeldDWT: IIf([Date_from_DWT] Is Null,[today()]-[Date_to_DWT],[Date_from_DWT]-[Date_to_DWT])

I have a date field in my query and I want to use a parameter criteria. When I enter [ ] and run the query, it works fine when I enter an actual date. But if I try to enter "Is Null" or "Is Not Null", it doesn't return any records. Without the parameter in criteria, if I...

I have a date field in my query and I want to use a parameter criteria. When I enter [ ] and run the query, it works fine when I enter an actual date. But if I try to enter "Is Null" or "Is Not Null", it doesn't return any records. Without the parameter in criteria, if I...