Search results for query: *

I guess I didn't explain the problem well enough. It displays 20 rows at a time (what I set) and I am able to scroll down and see more, but sometimes it doesn't allow me to see all 120 items on the list. It is like I am forced to close the program and open it again (like a refresh) before it...

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...

Isn't this for just entering the information in one field. How does this enter information in other fields at the same time?

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...

Thanks, that's what I need. Is there just one combination of keys that can do both the date and time at one time?

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

Thnaks for the reply. You are correct, this was one of my problems. I have made some changes and testing them. I think I have it figured out.

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...

Thanks a lot. I tried the first solution and it worked well, so I didn't need to try the others. Thanks for your help.

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...

Thanks a lot - your suggestion worked. For future reference I checked a module and see that I have many available refrences but only a few boxes are checked and I didn't see any MISSING. Would a MISSING show up as a separate box checked/not checked?

Same problem usind Date and Now. It still says Enter Parameter Value. Any more suggestions?

Thnks for the quick response, but making the change your recommended gives me the following error Undefined function 'today' in expression. Could it be my TODAY function is somehow fouled up in ACCESS?

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])

Report Design View/ Add a text Box - in the control source enter [whatever instruction you want to give data entry person]. Note the brackets - this will cause a propmt for data entry when you first open the report.

Design View/Combo Box Properties/Row Source? and click on the elipses (spelling?) and it should give you a query design screen - from there put the field(s) you want to sort by and choose "ascending".

BINGO! You got it! Thanks a lot for all your help and PATIENCE. It is people like you that keep people like me from giving up in frustration. You are a great asset to Tek Tips! Thanks again

I am getting closer! Now the specific date works as it should, but leaving the parameter criteria blank gives me all records with no dates instead of records with no dates and "pre"=YES.

Below is the SQL view of the query I am running - specific date works OK - null gives me no records. SELECT PL_Items.Pre, PL_Items.Date_Cmpl, Loc2.Order2, PL_Items.S1, PL_Items.PL, PL_Items.Loc1, PL_Items.Item_no, PL_Items.Date_ent, PL_Items.Loc2, PL_Items.Ryan_Rmks, PL_Items.Spec...

Terry and Jim, I think your (Terry) 2nd paragraph answers my question, i.e., "The parametr can not be directly interpreted as if you type "Is Null" in the query critera..... When I use the variation that you two have suggested, it works fine for entering nothing in the parameter...