Search results

  1. 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...
  2. 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:
  3. 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] & "'"...
  4. 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...
Back
Top Bottom