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!

Search results for query: *

  1. BDLand

    Multiple Unmatched values Query??

    Leslie, Thanks I think your code will work, but I am evidently leaving something out. Could you take a look and let me know if you see anything? SELECT DISTINCT Q891666.PART_NUMBE, Q891666.DESCRIPTIO, Q891666.QTY, Q891666.OP, Q891666.WORK, Q891666.CENTER, Q891666.BASE AS [Old Base]...
  2. BDLand

    Multiple Unmatched values Query??

    I have a need to find only the records were either of 2 + 2 fields don't match. Example: Record1, field1 and field2 values don't match OR field3 and field4 values don't match then show record. This query is only pulling from 2 tables. the fields 1 & 3 are from one table and fields 2 & 4 are from...
  3. BDLand

    Form Updates Table when it shouldn't

    I looked at this and the combo Box control source is a table while the subform is based from a query. It sounds like you can help me, if only I can explain it well enough for you to understand. (I am fairly new at Access so please overlook my lack of understanding) Everything work exactly as I...
  4. BDLand

    Form Updates Table when it shouldn't

    I have a form that looks up records on a subform. The problem I am having is if I have used the Combo Box to filter the records multiple times on the Subform and then close the Form it changes the record that had focus on the table to be the value now selected in the combo box.
  5. BDLand

    Show only Earliest Date in a Query

    Thanks Remou, That has gotten me a lot closer, but I am still returning "some" multiple results on some part numbers. I posted my code below, if you could provide a little more help it would be appreciatted. SELECT DISTINCT ORtg.[Part Number], Prmspm.Description, Min(MRP.[Due Date]) AS...
  6. BDLand

    Show only Earliest Date in a Query

    I have a simple query that now shows part number and each day it is required. I would like to only show the earliest date that each part number is required (filtering out all later dates) (should result in only unique part number and the earliest date required). I am new at Access so it is...
  7. BDLand

    Record Selection for Pop up Form

    I have a continuous form with a pop up form with a calendar when the Field is selected. For some reason it always focuses on the first record in the field no matter which record in the field is selected. I need it to focus on the record I select.
  8. BDLand

    Pop up Calendar in Subform (Datasheet view)

    I have a Pop up Calendar that works great in Form View on my form but I need it to work in datasheet view. How can I get the Calendar to work in datasheet view? If it makes a difference this is on a subform.

Part and Inventory Search

Back
Top