Advertisement
Guest User

Untitled

a guest
Aug 27th, 2015
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. SELECT [queryFormyTradycyjne].[Nr Maszyny], [queryFormyTradycyjne].[UID], [queryFormyTradycyjne].[Nazwa], [queryFormyTradycyjne].[UAP], [queryFormyTradycyjne].[Linia], [queryFormyTradycyjne].[GAP], [queryFormyTradycyjne].[Status] FROM queryFormyTradycyjne ORDER BY [Nr Maszyny];
  2.  
  3. SELECT Lista.[Nr Maszyny], Lista.[Nazwa], Lista.[UAP], Lista.[Linia], Lista.[GAP], Lista.[Status], Lista.[UID]
  4. FROM Lista
  5. WHERE Lista.isValid=False And Lista.UID Like 'FF*';
  6.  
  7. Public strSelectedItem As String
  8.  
  9. Private Sub List2_DblClick(Cancel As Integer)
  10. Dim varItem As Variant
  11.  
  12. With Me.List2
  13. For Each varItem In .ItemsSelected
  14. strSelectedItem = .ItemData(varItem)
  15. Next
  16. End With
  17.  
  18. DoCmd.OpenForm "AwariaZgloszenieNew"
  19.  
  20. [Forms]![AwariaZgloszenieNew].[txtNrMaszyny] = strSelectedItem
  21.  
  22. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement