Search results

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

I recieve compile error, when i write: strDec >=0 strDec=0 or =1

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) ?

I have founded - its INTERSECT, thak yOu anyway for help!

When I use UNION statement, returns records with Criteria1 OR Criteria2. I need Criteria1 AND Criteria2. ?

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.

Thank You, it works: me.Filter = Me!textbox me.FilterOn = True

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!

I have solve a problem using NZ and Dlookup functions! Thank You for help.

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

Thank You a lot! Its realy works!

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

THank Yuo, its realy good!!!

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.

Hi to all. In Access form I have Bound Object Frame, where I put fotos. BMP files show normally, but JPG files show only Icon. Why? Thank You for Answers in advance.

Hi, How can I make Records numbers in Continous form? For Example, in Continous Form I have 10 records, the numbers are from 1 to 10. Then I make filter and see only 4 records. I need to see from 1 to 4. Any ideas? Thank You in advance.