Search results

This is perfect, thanks so very much......amazing

Is it possible to automate this more so that it detects what currencies are in use in the filtered form and adds them up accordingly? Such as a query would do. At the moment I have 5 currencies but this may increase.

OK fantastic, thanks very much for this, much appreciated. I'll do that later this evening, thanks again

I would like to say that I'm all good now however I just came across another problem....more than likely easy to fix with VBA? In the DB you sent me back I have added the local cost and currency, I'd like to have these total up and show in the form header, I've done this with the home currency...

Very sorry for the delayed response here, has been a hectic week. This is amazing, thanks so much, this is exactly what I needed. Never ceases to amaze me how good you guys are at doing this. Much appreciated.

Haha! Ah this is for an invoice report that I send weekly for payments, any new suppliers I need to provide contact details for so that the office can verbally confirm wire instructions, I only need to send this contact information once when I enter a new supplier, I have put this as a...

Hi All, I have the below code in the 'on format' event of a report footer, idea is to hide a subreport should nrecords>0, it works fine when I open the report and does everything expected, however when I print preview the report the subreport is missing when it should be there and it shows in...

🤦‍♂️ my bad, sorry, totally rooky mistake....all good

Yes that is correct, sorry should have made that more clear Think that is why it is not working

I tried this but it didn't work? Not sure why but was guessing it was because it was a data entry form?

Hi All, Is there anyway to make a report based on a new record just entered into a data entry form? FYI The data entry form also has a subform with the child table in Cheers

Hi Strive4peace, Attached is stripped down copy of db. Basically the ExpenseSearchF runs a great filter (from MajP :) ) then I have a button to open the related child information in a form. When the filters are applied to ExpenseSearchF I want to be able to run a report from this form that...

Sorry no, I mean my report is based on the results of a filtered form, however the form is a parent of a child form, but as it is a continuous form I cannot have the child records in the same form. I'd like my report to be based on the filtered form (parent) but then also to show the child...

Thanks very much for these, much appreciated. A grouped report from what I can see is all based on a query, is it possible to make a grouped report based on a filtered form? The filtered form that MajP uses worked great but as it is filtered I don't have a query to grab data for a report, I...

Hi Arnelgp, This is great however I'm struggling to understand the code, any advise greatly appreciated. I'm using a very simple table (attached) that I'd like the exchange rates updating every 10 min using a hidden form as you mentioned in an earlier post. If I add more exchange rates then...

@strive4peace thanks for that, I made a report last night and it works all good, just need to tidy it up now. I don't know why Access doesn't allow forms like this but it can make reports like this, maybe a new update for MS :cool:

Thanks guys, I've just gone for the subtable in a form footer as seemed the cleanest way, just need to scroll through the main form records, not the end of the world, I will need to make the report more like the attached picture I did, just need to figure out how to make a grouped...

Hi All, As I understand I cannot put a continuous form within another continuous form.....is there anyway around it to display it as per the attached so it shows multiple parent and associated child records in a continuous form or report? In a perfect world I'd like it like this in both a form...

Perfect, thank you very much....everydays a school day....especially with Access lol

Cheers Gasman