Search results

Thanks , there didn't appear to be any entry here but it now seems to be working ! Cheers Steve:)

I was wondering if anyone could throw some light on a problem I'm having. I have a straightforward report - record source is a query. The query has some selection criteria which requires input at run time. This works fine ! (Why change this you ask ? I'm beginning to ask myself the same...

Matt, Doing some more digging around, I think my best option is to get the button to create a form with the combo box on it and take it from there. Thanks for your suggestions. Cheers Steve

Thanks Hi Matt, I'm trying to keep a consistent look and feel to the switchboard - I have 9 buttons on there, several of which are used to request report previews. I wanted to retain this format if possible. Am I trying to do the impossible ? Cheers Steve

Can someone put me on the right track ? I have a command button on a switchboard , that runs a report from a query. When requested, a Msgbox appears allowing maual entry of a specific 'Request No' that the query uses to pull the relevant data from a table. So far,so good! I wish to change this...

Cheers Thanks guys. It's great for us newbies to know there is someone out there who's willing to take the time and trouble to help. Cheers

Found It! http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=41006&highlight=weekdays Malcy Had already spent some time going through previous threads. However, took your advice and looked again and lo' and behold , eventually found what I needed - see above. Thanks for...

Anyone help please ? I'm still fairly new to ACCESS so forgive me if I'm completely on the wrong track ! I wish to add a control button to a form that will prompt me to enter a date and then calculate and display a date nn (fixed) number of WORKING days in the future. I've seen some...

Hi Rich , Just realised why the RequestMonth expression is returning April to May ! Obviously correct 'cos the field is alpha ! Forgot to mention the reason that your suggestion wasn't working - message returned .....function containing the wrong number of arguments. Cheers Steve

Hi Rich, Thanks for the info. Having tried this I can get the code to work but ONLY without the "MM" part of the expression - why is this ? MyDate is in short date format. Other questions (if you have time ) :- 1) assuming I can get this to work, how can I display the literal for the month...

Anyone help please? I have a monthly summary report(from a query) for the year to date with one page per month and an overall summary page. How can I print the first and last months on the overall summary page showing months reported to date - e.g. Yearly Report 2006 January to May ? Please...

Sorted Sorted this myself by just deleting the control and re-adding text box. Don't know what I did differently this time but at least it now works !

Anyone throw some light on this ? It's probably quite simple but I just can't see it. I have a report showing many detailed records per page. I'm using a straighforward IIF - =IIf([Open]=0 And [Completed]=1,"No","Yes") However if the condition is True I get #ERROR in the report field...

Sorry for not responding !! Wazz - have used your suggestion successfully ! raskew - I'll store this one away for future ! Thanks to you both for your suggestions ! Steve

Wazz, Thanks for the response. I'm pretty new to access - what is the function / syntax of SELECT CASE and how would I apply this code in the expression ? Sorry for being clueless on this ! Cheers Steve

Help again please ! I'm trying to populate a "Quarterly" field ( as in yearly quarters , values 1 through 4 ) in a query. I'm using the following expression :- Qtr: IIf(Month([RequestDate])=1,1,0) Or IIf(Month([RequestDate])=2,1,0) Or IIf(Month([RequestDate])=3,1,0) Or...

of dubious integrity ,

Ken , Thanks for the response - will give it a try ! Cheers Steve

Help please , I have a calculated field in a report that works fine (most of the time) :- =(100/(Sum([Sum Of Count])-Sum([Expr1])))*Sum([Completed]) but I get a decimal divide (obviously) if dividing 100 by zero. What is the correct syntax for testing and bypassing this ? Suggestions (...

Rich , Sorry if this is a stupid question, but where do I set this ? It won't let me alter the Height in the Properties for the group footer ? Steve