 |  |  |  |  |  |  |  |
how to get value from an access querry in a variabe?
Please support our VB.NET advertiser: Intel Parallel Studio Home
 |
:-)
hi!
can somebody help me, pls;
i have an acces database, and a querry "Q1" that counts some records, depending on the value of one combo on the form. This is sql view of the querry:
"SELECT Count(tblZARAZNABOLEST.idZarazna) AS CountOfidZarazna
FROM tblGRADOPCINA INNER JOIN (tblNASELJE INNER JOIN tblZARAZNABOLEST ON tblNASELJE.idNaselje = tblZARAZNABOLEST.idNaselje) ON tblGRADOPCINA.idGradOpcina = tblNASELJE.idGradOpcina
GROUP BY tblGRADOPCINA.idGradOpcina
HAVING (((tblGRADOPCINA.idGradOpcina)=[Forms]![Prijava oboljenja-smrti od zarazne bolesti]![Combo34]));"
lets say that querry counts 30 records,now i want to display that number in a text box on the form....how to do that?????
pls help
tnx
btw, all of the application is written in access, forms, and code, and all
hi!
can somebody help me, pls;
i have an acces database, and a querry "Q1" that counts some records, depending on the value of one combo on the form. This is sql view of the querry:
"SELECT Count(tblZARAZNABOLEST.idZarazna) AS CountOfidZarazna
FROM tblGRADOPCINA INNER JOIN (tblNASELJE INNER JOIN tblZARAZNABOLEST ON tblNASELJE.idNaselje = tblZARAZNABOLEST.idNaselje) ON tblGRADOPCINA.idGradOpcina = tblNASELJE.idGradOpcina
GROUP BY tblGRADOPCINA.idGradOpcina
HAVING (((tblGRADOPCINA.idGradOpcina)=[Forms]![Prijava oboljenja-smrti od zarazne bolesti]![Combo34]));"
lets say that querry counts 30 records,now i want to display that number in a text box on the form....how to do that?????
pls help
tnx
btw, all of the application is written in access, forms, and code, and all
|
Similar Threads
- VB: Connect to Access database via ODBC datasource name (Visual Basic 4 / 5 / 6)
- Writing to an Access Database (Visual Basic 4 / 5 / 6)
- Writing to an Access Database using Java... (Java)
Other Threads in the VB.NET Forum
- Previous Thread: outlook export code help
- Next Thread: I need to trace or view that the stored proc is saving the data.
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
"crystal .net .net2005 30minutes 2008 access add application arithmetic array assignment basic binary box button buttons center click code combo combobox component connectionstring convert cpu data database databasesearch datagrid datagridview design dissertation dissertations dissertationthesis dosconsolevb.net editvb.net employees excel exists firewall folder image images isnumericfuntioncall login math memory mobile module ms msaccess mssqlbackend mysql navigate net opacity pan peertopeervideostreaming picturebox picturebox1 port print printpreview problemwithinstallation project record regex reports" reuse right-to-left save savedialog search serial sorting sqldatbase storedprocedure string temp textbox timer txttoxmlconverter updown useraccounts usercontol usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vbnet view vista visual visualbasic visualbasic.net visualstudio web wpf xml
