User Profile

Collapse

Profile Sidebar

Collapse
aligoli
aligoli
Last Activity: Feb 17 '07, 08:52 AM
Joined: Feb 15 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • aligoli
    replied to print and use the fields of a temporary query in VBA
    in Visual Basic
    Hi , by this way I'm going to control and access the components of a SQL statement . For example checking the user_ID and enterance password of my program and also set them in the forms, as the caption of a lable .
    thank you...
    See more | Go to post

      Leave a comment:

    • aligoli
      started a topic print and use the fields of a temporary query in VBA
      in Visual Basic

      print and use the fields of a temporary query in VBA

      hi !
      I am a new programer by VBA and know I can't use the fields of a query . my codes are as below :

      Code:
      Dim mydb As Database
Dim str1 As String
Dim rsttemp As Recordset
Dim qdftemp As QueryDef

Private Sub Command1_Click()

            Set mydb = OpenDatabase("d:\pm_vb\main_db1.mdb")
       
                     str1 = "select * from users where per_code="
      ...
      See more | Go to post
      Last edited by willakawill; Feb 16 '07, 08:59 AM. Reason: please use code tags when posting code
      No activity results to display
      Show More
      Working...