Search results

  1. C

    Using DCount To Find Statistics

    Sorry, I should say the record source is [Feedback]
  2. C

    Using DCount To Find Statistics

    I am trying to count the occurences of [Pharmacy NPI Number] in the main table that relate to what record the form I am on. The form's control source table is [Feedback]
  3. C

    Using DCount To Find Statistics

    I am getting the same error #Name? =DCount("ClaimCount","Feedback","[NPI_Number] = " & Chr(34) & [Pharmacy NPI Number] & Chr(34))
  4. C

    Using DCount To Find Statistics

    The [NPI_Number] belongs to the Feedback table and is a text field. The [Pharmacy NPI Number] belongs to the main table and is a text field.
  5. C

    Using DCount To Find Statistics

    =DCount("ClaimCount","Feedback","[NPI_Number] = " & [Pharmacy NPI Number])
  6. C

    Using DCount To Find Statistics

    Now I am getting a #Name? error in the text box
  7. C

    Using DCount To Find Statistics

    I have 1 Text Box on a Form called Pharmacy Info. I am trying to count how many occurances of a field in a table called [Main] and a column called [Pharmacy NPI Number] that match what record the form is currently on. The field on the form that I am trying to match is in a table called...
  8. C

    Adding Items To a ListBox

    Thanks. I ended up just using lstZipCollection.RowSource = "" The .Requery looks like it is not needed. Is it just good practice to put it in, or is it needed?
  9. C

    Adding Items To a ListBox

    Thank you very much. any suggestions on how I would go about clearing the list with another button?
  10. C

    Adding Items To a ListBox

    row source is blank and row source type is value list
  11. C

    Adding Items To a ListBox

    I'm not sure what you are asking.
  12. C

    Adding Items To a ListBox

    As my question stated before. I would like VBA code please. It is based upon what a user types into the list box.
  13. C

    Adding Items To a ListBox

    Using VBA, how do I add items to a listbox named lstZipCollection from a text box called txtZipCode2 using a button named btnEnter? Help Please.:eek:
  14. C

    Can't Navigate Records On Linked Form

    Thank you. That worked :)
  15. C

    Can't Navigate Records On Linked Form

    It is a form to a form that has a subform.
  16. C

    Can't Navigate Records On Linked Form

    I cannot navigate through records once I link one form to another. Any help would be great. Thank you! Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmMember" stLinkCriteria = "[FirstOfPatient ID Carrier]=" & "'" & Me![Patient ID Carrier] & "'"...
  17. C

    Help Calculating Distance

    I am trying to code an access database that will allow a user to input two zip codes and return the distance in miles between the two. I have a table that lists the zip codes with the latitudes and longitudes. Below is the code that I have so far. Any help would be great. DB= zipcodes Table...
Top Bottom