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

Recent content by salisha

  1. salisha

    Subform/Unbound Control Question - MS Access 97

    Hey everyone, I am creating this Expense Log Form for entering all expenses for vehicles that is owned by my company. I have an unbound combo box, which pulls the vin # from the tblVehicleInfo, and when a particular vin # is selected, it populates a list box with a history of expenses on that...
  2. salisha

    Date Format Problem - MS Access 97

    Actually, let me see if i have this correct. I can make my date field a Text Data Type, and in the format property for the field I am going to enter YYYYMM? Is that how it is going to work? But if i make it a text field, I am going to have to put in some sort of validation for the month?????
  3. salisha

    Date Format Problem - MS Access 97

    Thank you guys very much for your help. Now that I know this, it seems simple enough. Salisha
  4. salisha

    Date Format Problem - MS Access 97

    Hey all, I have this date field and I need to put an input mask on it in the format of YYYYMM. I do not need the day part of the date. > >My question is, in the design view for the table for the data type can I still use date/time as the datatype even though I am not using the format of short...
  5. salisha

    Nz/IIF Problem - Ms Access 97

    hey foolio12, thank you so much for your help!
  6. salisha

    Nz operator/IIF Question - Ms Access 97

    Hey Nick, You are a Lifesaver!!!!!!!!!!! Thank you so much... It worked like a charm. Thank you, thank you,thank you! salisha
  7. salisha

    Nz/IIF Problem - Ms Access 97

    I am creating this Parameter query and I need a little help. I have a couple fields such as lastname, firstname, address etc. In the query design mode, I am setting the criteria where the user will be prompted for a first name and last name and get that particular name. For the lastname field...
  8. salisha

    Nz operator/IIF Question - Ms Access 97

    I am creating this Parameter query and I need a little help. I have a couple fields such as lastname, firstname, address etc. In the query design mode, I am setting the criteria where the user will be prompted for a first name and last name and get that particular name. For the lastname field...
  9. salisha

    Looping Through Records in a Table - MS Access 97

    UNIFEX,,,,,,, thank you so much....you are the best. it worked!!!!! that's exactly what I was looking for. thanks. i appreciate it greatly...
  10. salisha

    Looping Through Records in a Table - MS Access 97

    ..
  11. salisha

    Looping Through Records in a Table - MS Access 97

    actually, can I add some sort of code in there where the msgbox will not pop up for a customer that has never been entered in the database before. so like when I am entering a new person and then i TAB over to the next field, I will get no msgbox. I only get the msgbox why someone is in the...
  12. salisha

    Looping Through Records in a Table - MS Access 97

    hey unifex, THANK YOU SO MUCH!!!!!!! IT TOTALLY WORKED. YOU ARE A LIFE SAVER. THANKS! I TOTALLY APPRECIATE IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  13. salisha

    Looping Through Records in a Table - MS Access 97

    PLEASE HELP!!!!!!!!!!!!!!!!!!!!
  14. salisha

    Looping Through Records in a Table - MS Access 97

    I am entering data into a database concerning complaints, and I need to use some sort of "red flag" or "early warning signal", to identify if this person has submitted complaints before.. This is the code, I have so far. It only works by identifying the first record in the...
  15. salisha

    Working with Combo Boxes - MS ACCESS 97

    thank you elisabeth. It worked. Thank You So mUch!
See more

Part and Inventory Search

Back
Top