User Profile

Collapse

Profile Sidebar

Collapse
Teddie
Teddie
Last Activity: Nov 17 '08, 08:06 PM
Joined: Jul 29 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Teddie
    replied to VBA forms/parameters No Errors; No Results
    Thank you PianoMan. I used your code and am getting a "Compile error: Method or data memeber not found" on the line
    Set Me.custResults. Recordset = db.OpenRecordse t(LSQL, dbOpenSnapshot)
    Any idea how to fix this?

    Okay, after googling the above error I changed Me.custResults. Recordset to Me!custResults. Recordset and am now getting a Run-Time error '3061' Too few parameters. Expected 1.

    Also,...
    See more | Go to post

    Leave a comment:


  • Teddie
    started a topic VBA forms/parameters No Errors; No Results

    VBA forms/parameters No Errors; No Results

    Hello, I am trying to create a form that has multiple parameters. A user needs to enter a parameter but if one is left blank that is okay.
    Code:
    Private Sub DomesticQueryRun2_Click()
    
        Dim db As Database
        Dim Lrs As DAO.Recordset
        Dim LSQL As String
        Dim LTrackNum
     
        'Open connection to current Access database
       Set db = CurrentDb()
    
    If Len(Forms![test]![TrkNbr])
    ...
    See more | Go to post
    Last edited by NeoPa; Aug 5 '08, 01:21 AM. Reason: Please use the [CODE] tags provided
No activity results to display
Show More
Working...