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!

Register Log in
  • Congratulations gkittelson 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: *

  1. leaners

    Code for printing only one report based on customerID

    Is there any other method for previewing an invoice based on customerID?
  2. 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...
  3. 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...
  4. leaners

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

    The add button would be a nice addition
  5. leaners

    Help with referring to a textbox in a subform

    I have found the answer to my question already. The right code is: Me![Room subform].Form.Roomno = Me.List0
  6. 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...
  7. leaners

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

    Sorry to bother you it works fine now
  8. leaners

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

    Thanks, it works for one of the forms, but when i try use it on another of my forms there is an error. If i wanted to use the code in 2 of my forms what should i do?
  9. 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...
  10. leaners

    Displaying a calculation derived from two fields on a form

    thanks it works now
  11. leaners

    Displaying a calculation derived from two fields on a form

    I have no idea how to do that. To add a field I use field list. But field list only displays the fields from the booking table. Could you show me how to add the CostPerNight field?
  12. 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