Recent content by Edwik

What You mean second layer of Query?

Hi all. I have chart in ADP project/MS SQL Express and I want to see in chart table (date Field, data field) grouped by year and month: 2005.01, 2005.02, 2005.03.... I try this str = DATENAME(yyyy,date)+ DATENAME(m,date), SUM(data) FROM table GROUP BY DATENAME(yyyy,date)+ DATENAME(m,date) ORDER...

Than You Exotericist, Bat17! I will try to learn normalization!

4\001-9 +1? = 4\001-10

Hi all. I have text field with mask: X\XXXX-X (x are digits), for example - 4\001-1, 4\001-2... I need find field with text beginning 4\001 and max of last symbol. Last symbol +1, then again convert to text field. For example: for example 4\001-1, 4\001-2,4\001-3 - must find 4\001-3 , then...

Than You! its works!

Dsum its ok, bu I have more difficult situation (dont know is possibble to use Dsum Function?) I Have 4 Tables: TABLE1 with Columns (ID1, Col1) TABLE2 with Columns (ID2, Col2A,col2B) TABLE3 with Columns (ID3, Col3) TABLE4 with Columns (ID4, Col4) Col1 have relationship (one to many) with ID2...

Hi, all. I have string: strSQL = SELECT SUM column FROM table I need compare it with constant number, for Example: If strSQL > 50000 Then .... its not working, any Ideas? Thank You in advance

Hi all, I have form containing subform. In form I have txtbox1. In subform txtbox2, txtbox3. I need after pressing button have txtbox3 = txtbox1 + txtbox2 How can I do that? Than You in advance.

Thanx, but I recieve Windows username, I need Username, with them I login into SQL Database!

Hi, I have ADP project + SQL Server Express. I need display in Form textbox User Name (with then I log into SQL Database). Thank You in advance for answers.

Hi, I have string SELECT Field from Table: A1 A2 A3 .... I need to see records in textbox: A1, A2, A3.. Thank You in Advance

Thank You, must be "D:\Pictures\"

Hi all. I have ADP Project in my computer and MS SQL 2005 Express in second computer. In ADP Project I need to write Path for Pictures: Dim Path As String Path = ????? ' Her I need D:\Pictures Thank You in advance.

When I write: strSql3 = strSQL1 & strSQL2 I recieve same resultat as strSql3 = strSQL1