Search results

Ok, part of that makes some sense to me - however I still need to be able to produce a report showing someone's airlining, hotel, and rental car all on one sheet in an organized letter type format so that I am able to send that to them with all of their travel information for only that...

Thanks for the link! :) The section on Input mask helped me reformat part of my form! However... the way I organized my data actually really works for me. I am always careful I put the right number but, really with the data I am working with its not like I cannot repeat, since having 6...

Actually there is an error. I went back into the print view and noticed that both of my date fields, =Now(), were showing as Name errors. In design view they took on the coding of some of the other formulas, and when I tried to change it back to =Now() Access gives me the error: "There was an...

:confused: Ok - this is what I have tried so far just for the AirTravel section and it is not working at all... there is no code error, no pop up message, but the boxes do no disappear. Option Compare Database Private Sub Check1_Click() If Len([Airline1] & "") = 0 Then Airline1.Visible = True...

This would be done using Visual Basic right? Bassically and If THEN statement... so, after the IF (oh my there will be lots of them...) what should I do for the the then. I don't know what the coding is for making items invisible.

How would I do that... I have some basic knowledge of Access but I don't know what you are talking about. Can you give a few more details? Thanks! :D

I forgot to add: The names of the text boxes and labels are (in order) DateLabel TripRequestLine DearLine InformationLine FlightLabel Flight1 Flight2 Flight3 Flight4 Flight5 Flight6 HotelLabel<<<<<<<<<<< HotelTextBox ----------Both of these were just added RentalCarLabel...

I made a form to record information on employee travel. Each record has a request number, six (6) flight information sections (ariline, flight number, confirmation number, depart location, depart time, arrive location, arrive time), one hotel (hotel name, hotel confirmation, check in time...