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 Chriss Miller 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: salisha
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. salisha

    Working with Combo Boxes - MS ACCESS 97

    I have two combo boxes. Depending on the Value I chose in Combo1, I need it to populate Combo2. This is how my code looks, but i keep getting a "Data Type Mismatch in Criteria Expression" when I click on combo2. What am i doing wrong???? Private Sub cboIssuance_AfterUpdate() Dim dbs...
  7. salisha

    Calendar Control Problem - MS ACCESS 2000

    I need to add a calendar control to a MS ACCESS 2000 Form. I need to be able to click on a button and the calendar will pop up. After I click on the date I wanted from teh calendar, I need to add that date tothe date field. How would I do that?
  8. salisha

    Placing A Search/Find Button on a Form

    I am placing a Find command Button on a Form to allow users to Search Any Field in the DAtabase that they would like to. The code I have used behind the button is (Name of Button is cmdFind) Private Sub cmdFind_Click() DoCmd.RunCommand (acCmdFind) End Sub This code works fine in MS ACCess...
  9. salisha

    Checking To Make Sure Date Falls On Weekday

    I have a problem with checking for weekdays. I am working in MS Access 2000. I have a combo field called cboCAlendar that has numbers to pick from. On the After Update Event for this field I want to place some code that will add this number to another field called "Assigned Date&quot...
  10. salisha

    Automatic Increment/Logging of a Number

    I hope somone out there can help me with this problem. I have this field called CaseNo and this number looks something like this YY-9999. The YY is the last two digits of the year and the 9999 is four digits, starting with 0001. I am trying to find a way to increment this number by one, each...

Part and Inventory Search

Back
Top