Search results

Me.txtMessauftrag will also generate error msg. Wait I am confused. Do I have to use the name of the field from the table or the name of the text box on the form? For example, TableA IDfieldtable field1 field2 field3 ... 2017-0200 .. 2017-0201 .. 2017-0202 ...

Okay so I have removed the Form_Load record source but when I clicked on the button, the parameter value input window appear asking for the value txtMessauftrag. And when I entered the value for example 2017-0249, the new forms open with no data record on it.

Tried that too but still the first record appeared. not the current record. What does Column(0) means?

I have searched about this and founs many familiar thread but it does not help with my forms. So I have a form named frmTeilebeschaffung and it has a subform which displays some records and a button which will open a new form named frmDatumGueltigkeit. What I want to do with my form is that...

Thank you. I tried it too but the validation rule/text still does not appear. I think it is because the subform is uneditable. Do you know why it is uneditable? I have set it to allow addition and dynaset (inconsistent). The only thing that is editable is the Test 3 column that I just added.

Thank you arnelgp for your suggestion. I did what you told, except that it does not perform the validation rule and the validation text does not appear. On FormB, the subform that shows the dates is not editable and I don't know why. There is also a background colour that shows whether the...

I have 3 forms which displays the dates of the tests that we are doing. The dates of each following test must be on the same/later date as before. All dates are from the same table. For example, I have 5 Tests. Date of Test 1 Date of Test 2 must same or after Test 1 Date of Test 3 must same or...

I just figured a simpler way. I created a new form with an 'Add' button to and write CurrentDB.Execute INSERT INTO codes to save the new records. Thank you for your help.

I have found the solution. I just need to clarify which form is open at the time of execution. So I changed the codes.. Forms!frmRunde.requerySubforms Forms!frmRundeMUC.requerySubforms to If CurrentProject.AllForms("frmRunde").IsLoaded Then Forms!frmRunde.requerySubforms End If If...

I did the SELECT DISTINCTROW but also nothing changes. I will try DCount and see if it works.

I have done SELECT DISTINCT but nothing changes. And I don't think I can replace the Totals with DCount because I am not using the Totals query to count the records, but to filter out some records. See photo Query - MA_Status. I use this Query so that it will only show the Records with the...

Thank you for your reply. But I was wondering if the that you have writte is correct, because the 'Requery' at the end is doubled. Is that normal?

Arnelgp, how do I make Left Join for the query? I have attached the screenshots of the queries and form and below is the SQL SQL for Subform SELECT tblBelegung.indBemusterungsverantwortlicher, tblBelegung.indEMMessanlage, tblBelegung.indEMMesstechniker, tblStammdaten.*, * FROM (tblBelegung...

Okay the new query that I added is a Totals query. That's the culprit. Is there any idea to bypass this query? Because that query is added there only because I wanted to add a new row to my subform that will show the status of the record.

What should I be looking for? In the query there is also no * at the bottom.

I know this might sound simple but I am trying to enable the addition of new records through a subform on a form. Before this there is a * at the bottom of my subform to add new records. But since I added one query in my subform's record source, the * row disappear. I have tried setting the...

Hi, I have a form which looks like a weekly calendar (from Monday to Friday) and the Record is shown according to the date it was assigned. There is a function on that form where I can drag and drop the Record from one day to the other. The function works well with no error, but then I...

Thank you very much JHB! That is exactlx what I need. :)

I'm sorry JHB. I thought I had mention all the requirement, but I just realised the complication after seeing the result of the query using the CrossTab query. So, Method A is composed of MethodID 1 and 6 while Method B is composed of MethodID 2 and 7. Would it be easier if I just add a new...

Thank you JHB. That sql code works like a charm :) Just a question more. The values from the table is actually far more complicated than that. The MethodID actually have more than 2 type. Let's say.. MethodID xx xx yy yy aa bb The Methods xx and aa belongs to the same group and so do Methods...