Search results

  1. C

    Duplicate Records Search

    Duplicate/Similar Records Search What I need to create is a query that will find duplicates with a bit of a twist. The field to search on is a string field, so one record may say: "A Science Journal" and a second "Science Journal" a third "An Science Journal" or "The Science Journal". I'd...
  2. C

    Trim() and "On Not in List" Event Procedure

    I've defined the following function as an event procedure in the On Not in List: Private Sub cboLastname_NotInList(NewData As String, Response As Integer) Dim rs As Recordset Dim db As Database If MsgBox(UCase(NewData) & " is not in the list of Authors." & vbNewLine & "Enter it as new Author?"...
  3. C

    SQL delete syntax

    I wrote the following in queries: DELETE * FROM tblCitationAuthor WHERE (((tblCitationAuthor.CitationAuthorID) Not In (SELECT CitationAuthorLastName from tblCitations))); The field and table names are correct but it doesn't delete the records, I get no errors either. Am I doing something wrong?
  4. C

    Sorting in 2003 and 2007

    I’m having a bit of trouble with sorting records in descending order. In the “Row Source” of the properties of the form field I have: SELECT tblDisserationToCitationJoin.JoinID, tblDisserationToCitationJoin.CitationID FROM tblDisserationToCitationJoin ORDER BY [JoinID] DESC; This works...
    • chelm
    • Thread
    • Replies: 17
    • Forum: Forms
  5. C

    confirm insert on _Click()

    I'm new to access and VBA but I've managed to get some functions up and running for the most part. I need a bit of help/advice as to how to create a confirm insert after the button is clicked. Private Sub cmdAddCitation_Click() Dim rsCT As Recordset Dim db As Database Dim newCID As Long Dim...
  6. C

    Redundancy issue

    I’ll apologize up front; I’m not quite sure where to put this. It is an issue I’m having with a form, but it involves SQL and VBA… I need some help with an access 2007 project I’ve been working on. I’m new to access, SQL and VBA so I’m not really sure how to make it work correctly. Here is...
  7. C

    OpenReport where clause

    I’m not quite sure where to post this because it is a query of table that is being used to generate a report, but is being opened with a the OpenReport macro. In the where condition I have this: Year([ActualDropOffDate])=Year(Now()) And DatePart("q",Date())=DatePart("q", Now()) But I must...
  8. C

    MYSQL -> Access (update query)

    I'm new to access and I'm trying to learn the functionality by creating a relational DB for US zip codes from an excel document. I've imported everything and I have the tables setup. Is there a way to run a MYSQL query like this: UPDATE tbllocation, tblzipcode SET tbllocation.ZipID =...
Back
Top Bottom