Search results

  1. G

    Record Number

    What is the function(?) for A row number. By this I mean you can do DCount("*", "Owner") to get the number of records for a table, but I need to find out what number row I am at in a table. The table has 25k records and I do a find and am now in the 3300 row. In my private sub how do I...
  2. G

    Passing a variable to a saved query.

    Ok, I've tried looking and doing searches for the answer to this question but I have not yet found the solution: This sub is tied to a button on a form. Private Sub Command26_Click() Dim lLocalVariable As String lLocalVariable = "Brandi" docmd.OpenQuery "First_Name" End Sub I want to...
  3. G

    Question Query Question

    From sql I want to access a saved query and use a variable within that query. I have a button on a form that pulls an [Event Procedure]. In that event procedure (private sub) I want to declare a variable and run a saved query using that variable. Normally I'd have the name, lets...
  4. G

    Question SQL help

    I know this is a basic question but I cannot get anywhere with it: I'm trying to use a defined variable in a docmd.sql statement, but when I run it I get no results: Here is the code: Private Sub Command22_Click() Dim varX As Variant varX = "Brandi" DoCmd.RunSQL "SELECT...
Back
Top Bottom