Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Same text comparison, two results
I have a form with an unbound control where the user can type a search criteria. Clicking a command button will refresh a combo box which is based on a query that uses the value from the control as search criteria. The search criteria looks like this, <.. where RefNum Like...- MortenB
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Passthrough query as rowsource
Hi, There is a nice feature in Oracle sql that elegantly performs a treewalk for you. I have prepared a passthrough query with such a syntax and put it as the rowsource of my form, and it works fine (read-only but that's no problem). Now I would like to parametrize my start criteria for the...- MortenB
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
-
Automatically save a new record
I have a form where a new record contains default values, default foreign keys, and auto-generated primary key. The user doesn't necessarily want to change any data before he clicks his way to the sub-form. If a new record is not changed changed manually by the user it will not be saved using...- MortenB
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
