Search results

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...

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...

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.

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

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.

Hi all. I have 2 strings: strSQL1 = SELECT FieldA FROM table WHERE FieldA = xxx strSQL2 = SELECT FieldB FROM table WHERE FieldB = xxx I need unit this two strings to third string strSQL3. I must have result StrSQL3 = SELECT FieldA, FieldB FROM table WHERE FieldA = xxx and FieldB = xxx Is it...

Hi! I use MS Graph and need show 2 data types: 1. Invoice Value, EUR 2. Date Date axis group records by month, for Example Period from 2005.01.01 And 2006.01.01 has 12 positions in Date Axis. Her I have problem: I need show sum of Values for every month. For example in Period from 2005.01.01...

Hi all. I have database in Access. In one table I have 2000 record with autonumbers (ID) from 1 to 2000. My Database was broken and after repairing my autonumber go from 7669500: 1999 2000 7669500 7669501 7669502 ........... Database work normally, bu I cant upsize it to MSSQL. Maybe this is...

Hi all, I have textbox in form with expression =sum(DCount()). In Access its works good, but in ADP project I recieve Error. Please, help. Thank You in advance. Edwik

Hi, In ADP project I want declare ckeckbox data: dim strDec as String strDec = 1 ' if True strDec = 0 ' if False How can I show all records: strDec = ? ' Show all recrords (true and false) ?

Hi, I have 2 strings: str1 = SELECT Field1, Field2, Field3, Field4 WHERE (Criteria1) str2 = SELECT Field1, Field2, Field3, Field5 WHERE (Criteria2) I want to show in listbox only "Field1" from str1 and str2. How unit 2 strings? Thank You in advance.

Hi, I have 2 tables with relationship one to many. I made form and subform. In form I have listbox, in subform checkboxes- for each checkbox toggle button. I need: when I press toggle (in subform), listbox (in form) must show records where chebox has value "true". Thank You for help in advance.

Hi, I have 2 forms, based on same table. First form only for viewing, second for input of new record. After input of new record in second form and pressing "close" button, i need to open first form with this new record. how can i do that? Thank You for answers in advance.

Hi ! I have in Form textBox and toggle button. How could i Filter Form by Value in TextBox? (when toggle button is pressed, Form show records filtered by texbox, when unpressed - shows all records.) Thank You in advance!

Hi All. I have 3 tables in Access: tblCurrency (Fields: IDCurrency, CDate, CRate) tblOrder (Fields: IDOrder, OName, ODate) tblCalculation (Fields: IDCal, Rate1, Rate2, Rate3, COrder) IDOrder is related to COrder with "One to Many" connection. I have Form frmOrder, based on tblOrder. For...

Hello. Please help. In form I want to see picture from another table and In form On Current i put sub: Dim picPhotoString As Variant Dim str1 As String picPhotoString = Me!txtBox.value sstr1= DLookup("[Field] ", "table", "[ID]= ' " & picPhotoString & " ' ") Me!ObjectBoundFrame.value = str1...

Hi all, In form I have listbox. I need show in listbox only filtered records. For example, I have 20 records in form, listbox shows 20. I make some filter in Form, Form shows 10 records - 10 records must show listbox too. How can I make it? Thank You in advance for answers.

Hi, I have converted my Access database to ADP project. And I have problem: does not work DLookUp function (for Example Dsum works). Anu Ideas? Thank You in advance for answers.