Search results

  1. R

    Need to enter only unique values between two tables

    Hi, I am running a SQL Server 2008 database with an Access 2010 .adp frontend and have two tables: Table 1: TravelerToDrawing with columns: Traveler, DrawingNumber Table 2: Drawings with columns: DrawingNumber, Description The column DrawingNumber is the data that links the Traveler column...
  2. R

    Query with VBA Public function as parameter

    Hi, I have a query that I'm working on through Access 2010's design view. I'd like to add a criteria to the query where it only shows results with the employee name column matching a global variable I created that stores the name of the currently logged in employee. Here's my vba code that...
  3. R

    docmd.openform where condition does not update

    Hi, I am running an .adp accessing data on SQL Server 2008. I'm trying to take a value from a field and use it to show only records that match that value in a continuous form. I programmed a button to run: Dim whereString As String whereString = "[Employee First]='" & Me.txtTest.Value & "'"...
Back
Top Bottom