Recent content by taranto

All thanks for looking, I suddenly had a Eurika moment and have solved it Cheers

Hi I think my question is similar to those previously asked, but differs as it does not contain 2 selection dates in the selection field, but only 1. I have a form for when a person is on duty- so it has name, dateon and dateoff. Each day at 23:59 a daily report is produced which amongst...

Hi I think my question is the same as above, but I am looking for help. I have a form for when a person is on duty- so it has name, dateon and dateoff. Each day at 23:59 a daily report is produced which amongst other things that have happened during the past 24 hours, shows the person on...

Re: Performing a spell check on the contents of a userform field Thanks for your time David, I couldn't see the wood for the trees !

Re: Performing a spell check on the contents of a userform field I really love this spell check feature and have introduced it sucessfully using the code shown earlier in this thread. Thanks for that. The only thing is that if I use lower case in the text field or an upper case as the first...

Absolutely brilliant, works a dream Thanks for all your help and patience

Thanks for that . I had wrongly assumed that the "me" was referring to my Db name. The code was written in the main form properties under the "Event" "On open" which automatically has inserted : Option Compare Database Private Sub Report_Open(Cancel As Integer) End Sub before I type in...

Many thanks, I feel that I am on the way now. I have shown below just 3 lines for subreports as an example (as you say there are a lot). The name of my Db is "PoS Db". I am still getting a compile error "Expected end of statement". Can you see what my error is please ? Thanks Option Compare...

I'm sorry for the long delay in responding. I do still have this question and have attached a screen shot for clarification. The shot shows a daily report which is made up of sub reports. Some days I don't want all the subs included and so have to go down the list and change visible from yes...

As an example I have a table for: 2 hourly weather observations, 6 hourly weather forecasts, daily incidents, diving operations and dredging operations. A query is run on each of these tables daily to produce a "daily report" which is made up of all the above reports as subreports. I also have...

I have numerous reports that are created from seperate queries all of which are filtered on "between dates". I want to have a master report that on some occaisions will contain some of these reports as subreports and on others a different combination of subreports. Can I somehow create a...