-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Çàïðîñ áåç óêàçàíèÿ îòäåëüíûõ ïåðåìåííûõ

×åòâåðã, 01 Ôåâðàëÿ 2018 ã. 11:05 + â öèòàòíèê
Äåëàþ áàçó


Sub ÑîçäàíèåÒàáëèöû()
Dim connDB As Object
Set connDB = CreateObject("ADODB.Connection")
connDB.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; data source=" & "G:\3\A.accdb"
connDB.Open
connDB.Execute = "CREATE TABLE RRR " & "(ID  COUNTER, r DATETIME, m TEXT, n TEXT,o TEXT, k TINYINT, s TEXT);"
connDB.Close
Set connDB = Nothing
End Sub


È çàïîëíÿþ åå
Ïîòîì õî÷ó äîñòàòü èíôîðìàöèþ


Sub uu()
Dim tbl As Recordset
Dim dbs As DAO.Database
Set dbs = OpenDatabase("G:\3\A.accdb")
Range("F:L").ClearContents
SQLr = "SELECT ID, r, m, n,o,k,s FROM RRR WHERE o = '" & Sheets("Ëèñò1").Cells(1, 1).Value & "' AND  ID= " & Sheets("Ëèñò1").Cells(2, 1).Value & " "

Set tbl = dbs.OpenRecordset(SQLr)
Sheets("Ëèñò1").Select
Cells(2, 6).CopyFromRecordset tbl
tbl.Close
Set tbl = Nothing
dbs.Close
Set dbs = Nothing
End Sub



cells 1.1 ïîëó÷àåòñÿ òåêñòîâîå çíà÷åíèå
cells 2.1 öèôðîâîå


Êàê ïðîïèñàòü òàê, ÷òîáû åñëè âäðóã íå óêàçàâ öèôðîâîå çíà÷åíèå â cells 2.1, òåì íå ìåíåå êîä ñìîã âûïîëíèëñÿ òîëüêî èñïîëüçóÿ çíà÷åíèÿ cells 1.1

Âîïðîñ ñâÿçàí ñ òåì, ÷òî â ñàìîì çàïðîñå ( êàê ÿ âèæó ðåøåíèå) áóäåò ïðîñòî ïðîïèñàíî è 4 êðèòåðèÿ
À, ñêàæåì, íà ñàìîì ëèñòå ìîæåò áûòü óêàçàí òîëüêî 2 èç íèõ, îñòàëüíûå áóäóò îòñóòñòâîâàòü, îíè íå áóäóò óêàçàíû
Òî, åñòü ìîæíî ëè ñàì çàïðîñ ñäåëàòü ñòàòè÷íûì â òàêîé ñèòóàöèè?
Ïîòîìó ÷òî â ýòîì êîíêðåòíîì ïðèìåðå ÿ óâèäåë, ÷òî òàê Excel VBA êèäàåò îøèáêó...
Ïîäñêàæèòå, ïîæàëóéñòà, êàêèå âàðèàíòû ðåøåíèÿ âîîáùåì ìîãóò áûòü.

http://www.sql.ru/forum/1284108/zapros-bez-ukazaniya-otdelnyh-peremennyh


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó