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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: leaners
  • Content: Threads
  • Order by date
  1. leaners

    Code for printing only one report based on customerID

    what am I doing wrong? My report is called Booking and my primary ID is called CustomerID. The report is meant to print an invoice specific to the customerID i.e. for the current booking. The report displays every booking instead of the one specific top the customer. The code is attatched to a...
  2. leaners

    Combining data in 2 fields to create a new field

    Hi, I have two fields. One is called firstname the other is called surname. I want to take the first 3 letters of the surname and the first 3 letters of the firstname and combine them to create the primary key (called CustomerID). So basically, the user enters his firstname and surname, then...
  3. leaners

    Help with referring to a textbox in a subform

    I have a main form (called Rooms Available) with a listbox (called list0) in it. There is a subform(called Room subform) in the main form. The subform has a textbox (called roomno) in it. The listbox displays a query. The code needs to copy the selected data in the listbox when the user clicks...
  4. leaners

    Hiding a 'next record' button when at the end of the records

    I have a button which takes you to the next record. I want it to disappear when the user looks at the last record. But I also want the last record to not be a blank record, so that the user is forced to use my other button which adds a new record. I also have a button which takes you to the...
  5. leaners

    Displaying a calculation derived from two fields on a form

    I have 2 tables Booking BookingID (Primary Key) StartDate EndDate Rooomno (Foreign Key) Room Roomno (Primary Key) CostPerNight I made a form using the booking table. I need to display the total cost of the booking in a textbox on the form...

Part and Inventory Search

Back
Top