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

    Convert Time to Text

    I have a field that is set as date type Date/Time with the format set as Short Time. I have it set this way because I need to use military time. Unfortunately I also need to export the date to another Access Data base that needs to see the time as text instead of Date/time but still needs to be...
  2. JRWPD

    Count Date from source

    I have a table that has a color field set as a number field, Long Integer. Display Control = Combo Box Row Source Type = Table/Query Row Source = Color In the Color Table Red =1, Blue = 2 and Green = 3. The report need to be set up to report the info on each record, but then I need to pull out...
  3. JRWPD

    Insert Value from Previous Record

    To Insert a value into a field from a Previous Record we can use CTRL + Apostrophe (') . I have a form with fifteen or so fields on it. I want to be able to fill in the form using the values from the previous record using eight or so fields, but not all of the fields from the previous form on...
  4. JRWPD

    Open For Maximized

    I have a form that I would like to have opened Maximized each time a user opens it. I must be missing this as I can't imagine it is a difficult thing. Thanks JR
  5. JRWPD

    Date of Birth and Year

    I am currently using the following expression which takes the entered date of Birth from the Date of Birth field and then populates the Age field with the persons age. Now I need to add the addition of populating a Year of Birth field with the year of birth. Your suggestions on the proper code...
  6. JRWPD

    Yesterday

    I need to generate a report that shows yesterday when run. What is the query parameter that will return yesterday in a date field
  7. JRWPD

    Counting

    I wish to generate a report that first counts and shows the count of a number of entries. Then I need to count how many of those entries contain the letter P and show that amount. I am new at this so please be kind. bill

Part and Inventory Search

Back
Top