ACC2000: ?????? ??? ?????? 511 ????? ?????????

?????? ????????? ?????? ?????????
???? ???????: 239565 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

??? ????? ??? ?????? ??? ??? ????? ?????? Microsoft Access (.mdb).

????? ???? | ?? ????

?? ??? ??????

???????

?? ??????? Microsoft Access 2000 ??? ?????? ????? ????????? ?? ???? ????? ????????? ?? ???? ????? ????? ???????:
????? ??????? ???? ?????? ??? ?? ??? (]) ?? ??????? ?????? (|).
????? ?? ??? ?? ?????? ????? ?? critera.

??? ??? ????????? ? ?? ???? ????? ????? ???????:
?????) ?] ?? ???? ?? ????? ??????? '<expression>'.

?????

????? ?? ?????? ?? ????????? ????? ?? ???? 511 ????? ?? ?????. ??? ????? ?? ????? ??????? Access 2000 ?? ???? ?? ??????? ????? ?????? ?? ?? 1024 ????? ? ????? ????? ????????? Access 2000 ?????? ??? ???? ?????? ???? 511. ?? ???? ??? ??????? ?? ????????? ??????? ?? Microsoft Access.

????

??? ??? ???????? ??? ?????? ??? Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

?????? ??? SR-1/SR-1a ? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
245025OFF2000: ????? ?????? ??? ??????? ?????? ?????? ?? Microsoft Office 2000 1/1a (SR-1/SR-1a)
????? ?????? ????????? ??? ??? ??????? ?? ????? ????? ????? ??????? ????? ?? ????? ????? "?????" ??? ??? ????? SQL 511 ???? ?? ??????.
??? ??? ???? ?? ????? ??????? ???????? ????? ????? 511 ????? ??????? ??????? CreateQueryDef ?? Visual Basic ????????? ???????. ???? ?????? ?????? ????? ?????? ???? ?? ?????? ?? ????? ??? ????? ????? ????? "?????":
  1. ???? ????? ????? ???????? Northwind.mdb.
  2. ???? ??? ????? ????? ???? ?????? ?? ???? ??? ????.
  3. ???? ???????? ???????? ??????? ?? ?????? ??????? ????:
    Option Compare Database
    
    Sub CreateLongQuery()
    
       Dim db1 As DAO.Database
       Dim qdfNew As DAO.QueryDef
    
       Set db1 = CurrentDb
    
       With db1
          Set qdfNew = .CreateQueryDef("LongExpQuery", _
             "SELECT Employees.EmployeeID, [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] & [Employees]![Lastname] & " _
             & "[Employees]![Lastname] AS Expr1 FROM Employees;")
          .Close
       End With
    
       Application.RefreshDatabaseWindow
    
    End Sub
    					
  4. ?? ?????? ?????? ???? ????? ?????? ?? ???? ????? ??????? ENTER:
    CreateLongQuery
    					
???? ??????? ???? ???? LongExpQuery ?? Access.

????? ????????? ???? ??? ??????? ?? ??? ?????? ???? ?? ???? ????? ??????? ????? ?? ??? ??????? ??? ?? ??? 511 ???? ?? ??????. ???? ????????? ???? ????? ????? ???? ?? ?????? 511 ?????? ??????? ???? ?? ????????? ???????? ??????? CreateLongQuery ??? ????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????. ?? ????? ??? ??????? ?? Microsoft Office 2000 SR-1/SR-1a.

??????? ????

??? ?? ??????? ????????? ?? ??????? ?? ????? ???? ?? Access ? ?????? ???? ?? ????? ?????? ?? ????? ????? "?????".

????? ????? ????? ???????

  1. ???? ????? ????? ???????? Northwind.mdb.
  2. ?? ?????? ??????? ???? ?? ????? ????? ??????:
       Field: EmployeeID
       Table: Employees
    					
  3. ?? ????? ??? ?? ?????? ?????? ???? ??????? ??????:
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname] & 
       [Employees]![Lastname] & [Employees]![Lastname]
    					
  4. ?? ??????? ??????? ???? ??? ?????.

    ???? ???? ????? ????? ???????:
    ?????) ?] ?? ???? ?? ????? ??????? '<expression>'.

???????

???? ???????: 239565 - ????? ??? ??????: 07/???? ??????/1435 - ??????: 1.0
????? ???
  • Microsoft Access 2000 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbbug kberrmsg kbpending KB239565 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????239565

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com