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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to put a message in record navigation bar at bottom of form
I have a form with a subform and a subform in the first subform. I have 3 record navigation bars showing at the bottom of my form and I would like to put a message in each bar so user can determine which bar is for what. Does this make sense? Also if I disable the record navigation bars, is...- PMrider
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Here is how to filter a subform and still have the record on main form
In GENERAL code behind form put Private Sub AddToWhere(FieldValue As Variant, FieldName As String, MyCriteria As String, ArgCount As Integer) ' Create criteria for WHERE clause. If FieldValue <> "" Then ' Add "and" if other criterion exists. If...- PMrider
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
-
How to use Multiple select list box for reports
I'm trying to print in a report only the records that I selected from a multiple select list box. I got it to work if the list box has the multiple select set to none. But its not working if its set to SIMPLE or EXTENDED Here is the query i'm wanting to use SELECT T_Name.NameID, T_Name.Name...- PMrider
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
-
Calculating #days between 2 records 1 field
ok, Here is my problem. I want to be able to calculate the number of days between deliveries on my subform. The fields are: InvoiceID, Winter/Summer, DateOfDelivery, GallonsDelivered, PriceperGallon, RateStatus, Driver, Remarks. The final result i'm trying to achieve is to...- PMrider
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
