Search results

Thanks. It indeed workes. The final line of code is following: Forms!MainForm!SubForm.Form.Recordset.FindFirst "ID = " & intRecordID I had an additional issue with the name of my forms which was not correct (beginner's mistakes, sorry...). Thanks all for your time and support.

Thanks for the little pictures: very helpful indeed. You're right for most of the situation. Using your picture: on 3, I have a button "save". When I click on save, I want to see 2 updated (without closing 3) and the focus being on the record 380. I tried ebs17's solution but it doesn't work...

no worries I need long explanations to understand quickly ;) The filter runs well on the continuous form. yes. Most of the time. And indeed, if not, there was no need for my question. The filters applied shall not change after the update of a specific record. But after scrolling to a specific...

That's correct. But as stated in the other answer, the user can filter on Field1 and have multiple records and edit one particular record. Thus the question. It will also avoid the need to scroll back again to the current record to continue their editing. That's correct. The subform LogHeader...

Hi, Thanks for trying to help. I’ll rephrase: Main form: loglist. Has filters. It is used as a sort of header for the continuous form. subform: logheader. Is a continuous form. as you said, Thanks for your answer. My problem is 1/ the need to show the updated record on the continuous form and...

Hello, I have a continuous form on which the user can navigate through record. When found, the user can click on a record to view or edit it (nothing new here). The continuous form (let’s call it LogHeader) is a subform of a form (LogList) and on the form there is a header than contains...

Thanks all for your answers and the discussion. I used a query and based both my reports on it. I put the conditions/criteria of the query in the vba code and used Select/Case to get the different situation.

Ok.

When executing line by line, in a module as a public function, vba doesn’t like the very first line (docmd.OpenReport “reportMain”). It pops an error message run-time error 2212.

That another option which looks easier. I’ll try as well (or maybe at first). I can see what I was missing at first is that the filter should be in the onload event of the subreport and not in the opening event of the main report. Which I didn’t mention in my question. i guess that using...

Good idea. I’ll try and let you know. I’ll post a sample in the mean time.

Hello, I have a report (ReportMain) with two unbound subreport (Sub1 and Sub2). I would like to create the report through VBA so that the user can input custom date (field Date/Time of the table Log). when using the VBA code docmd Openreport, I can pass the condition to the whereCondition. It...

I found the issue… I was using the field the attachment field instead of using the .filedata subfield. This works. Indeed, when using the attachment type in a table, Access creates “sub fields” .filedata, .filename, .filetype. If one uses the main field, it doesn’t discriminate the attachment...

The second subreport (the one with the pictures) has its datfrom a query that selects only records with attachments. I’ll have to check if there are links as you say. The first subreport has its data from the [log] table. That table also contains all the data including the attachment. but based...

Hei Pat, Thanks for the explanation. It is indeed clearer. about the images, I also tried the print preview. If you look in detail, you’ll see that for the same record number (on top of the page) there is the same picture twice although there are two different in the database.

Hello Pat, Thanks for the help. I am confused because I tried the to use the group header as shown on my post from Wednesday. I found this trick on several forum: creating a group with an expression "=1", but it didn't work. Why yours worked? Additionally, would you happen to know why only one...

Hei. Here is a lite version of my db. It is actually my test version. It is only partly translated but I don't think it'll matter a lot. The report causing me the most trouble is the report "ReportWAt". The others are quite ok for me (for now). Any comments for improvements are welcome.

Yes.

Yes.

Hei. do you mean the page header of the main report or the page header of the subreport? in case I put the column header in the main report page header, it will appear on the pages with the pictures (which would look strange). If I put the column header in the page header of the subreport, it...