Recent content by sdjames1979

Yup, it works fine until I close the database down and reopen!

Hi there Need your help... :) I've used a Combo Box Wizard to help 'Find a Record on my form based on the value I selected in the Combo Box' (i've named it ClientNameSearchDD) It was working fine for months, now I get the 'Return without GoSub' and it doesn't work full stop. Any ideas?

That would be great, but unfortunately i'm a bit of a beginner.

If only I knew what you were talking about! lol

The previous thread was for 1st of the month (September) dates. This question is for any date within September. If run in October, November, December - it should only show ALL dates in September for the current year. I will need to create 12 queries for each month, but once I know how to do...

Hi there I have a form in which I want to put a dropdown list of reports available, however, I only want the dropdown to show reports starting with 'SWP'. I have created various SWP reports: SWP-January SWP-February SWP-March SWP-Invoicing Thanks S

Hi I need the criteria to show any dates within September of the current year, i.e. today should show all September dates in 2015, when I run the query in 5 years time, it should show all September 2020 dates. Thanks S

(sorry) lol

YOU ARE A STAR! I love you. x

Hi, thanks for that. However, the first day of the current month is not what i'm looking for, I need a specific day/month but of the current year only. In five years time, it should bring up 1st September 2020, whether i run the report in January or December 2020. Thanks

Hi All I need the criteria to show dates on 1st September of the current year only. Today, it should show 1st September 2015, this time next year 1st September 2016. Thanks S

You're a star!

Hi guys I have 'Next Service' dates in a table, I need to run a query showing all 'Next Service' dates that have expired (overdue), but not dates in the current month. i,.e. If I run the report today, I only want to see August and before dates - even if there are some dates in September...

Hi I have three tables: Clients (list of) Items (electrical items within Clients building) ServiceHistory (Service history dates, etc for each item) When I go into the Clients table (under Datasheet view), the Items that belong to the Client are shown in the subdata sheet. The Items Table...

Hi there I have a report and i'm trying to set up the conditional format to highlight any dates within January red. Thanks S