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 TouchToneTommy 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: mrfilez
  • Content: Threads
  • Order by date
  1. mrfilez

    Setting focus to a field, on a form in Access 97

    I am setting certain fields as being required. I would like for the cursor to automatically go to the field that is required, but not filled in. This is what I have so far. Private Sub txtFirstName_BeforeUpdate(Cancel As Integer) If IsNull(txtFirstName) Then 'Checks to see if Information has...
  2. mrfilez

    Required fields in Form and its Subforms

    Access 97 I have a form with 3 subforms. I want all of the fields in the form(frmName), one field in the 1st subfrm(subfrmSeat), both fields in 2nsubform(subfrmComp), and 5 fields in 3rd subform(subfrmProb) to be required. This form is a data entry form. I have a button that will add the record...
  3. mrfilez

    Forms, Subforms, Tabing from Form to Subform

    I have a Form(frmName). This form has 3 subforms. subfrmSeat, subfrmComp, subfrmProb subfrmSeat has 2 fields (podnum, posnum) subfrmComp has 2 fields (sernum, modnum) subfrmProb has 11 fields unless you want to know them I wont type them :-) I can tab through the fields in frmName and into...
  4. mrfilez

    Opening form to new record

    Hello all, I am trying to get a form to open to a new record. I would also like for the form to automatically move to a new record when the last field is filled in. All fields will be required. I know that this is done in VB and I am still trying to learn this also. I have books and have been...
  5. mrfilez

    MTX Virus

    I have a question about this virus. I was just reading a post on it from back in December. I am using Win95 OSR2 at work, cause they make me.%-( I have to run McAffee AV, prefer Norton's.:-( I did a search for *mtx*.* and came back with several files. But they seem to all relate to Visual...
  6. mrfilez

    Showing 2 fields in one box on a form

    I want to display LastName and FirstName from a query or table, in a combo box on a form. I want them to show up as LastName, FirstName. I have seen something somewhere about how to do this in the RowSource for the Combo box. For the life of me, I can not remember where I saw it or how to do it...
  7. mrfilez

    Relationships between tables

    I am having to learn Access without training. So, at this point I feel really stupid, but here goes. This is for a Help Desk DB that I have to create. I have finally gotten all of my info grouped the way I think it should go. I have the following tables. tblName: UserID,First, Last tblInfo...

Part and Inventory Search

Back
Top