Search results

Never mind. I have fixed the problem Thanks very much for your help.

Thanks for the file Brian for some reason my query still asks the user to input a colour, i even copied and pasted yours across and substituted your assessor field/table1 for my own and it gives the same response. Not sure why its doing that?

Many Thanks Brian, i feel like im getting somewhere now. I have entered your formulae and selected groupby SUM, and i have also done this for green and amber, although now when i run the query it asks me to enter a colour code to search by. So for example, if i search amber, it puts the number...

I've now got the expression down to the following: Sum(IIf("ColourCode"="Red",1,0)) And Sum(IIf("ColourCode"="Amber",1,0)) And Sum(IIf("ColourCode"="Green",1,0)) However it says the expression is too complex to be evaluated. When i had 3 instances of the colour code field in my query, i...

In the criteria box, which im guessing is probably wrong, but then again its a long time since i've used access in depth, rather than just for data storage Im using 3 seperate instances of the same field, one for red, one for amber, one for green

Hi I have a further developments with the RunMacro Action was Cancelled prompt. I have discovered that not all computers on our network display the message. I have set trusted locations on EVERY machine i have tested it on, and they seem to pick and choose as to whether they will display the...

Never mind i didnt realise excel uses xlsx as its file extension not xls. my bad thanks again

I have now managed to get excel to open, but not the specific file (i copied your code from the other post you linked me to...

Thanks for your reply. I've entered T:\IV NVQ Files\Assessor Monitoring Spreadsheet.xls on the command line but i get an error message saying the path to the application is invalid. It shouldn't be though so im a bit confused as to why

Hi, I have no real knowledge of VB. I was hoping to open a specific excel file from an access form. Access 2007 doesn't have the RunApp macro like previous versions did, and i was wondering how to write some VB to open the file i need I would pull the file into access, but for this project...

Many thanks for your reply Brian, I have copied your code and altered it as necessary, but it says "The expression you entered has an invalid . (dot) or ! operator or invalid parentheses. You may have entered an invalid identifier or typed parentheses following a null constant" Not quite...

Hope i can make this clear enough, I have a database which is used to monitor the development of people doing qualifications. Each learner is assigned to an assessor. The learner is also assigned a colour code (red, amber, green) based on their level of dependancy for extra support. I would...

Ok thanks very much

No problem. I have attached it now, this version has never been on 2007 (not sure if that matters though) Thanks for your help

I have managed to add it to trusted locations but I am still now getting the "Run Macro Action Cancelled" message

Hi, Thanks for the reply. I have tried to add the location to the trust centre, however i get the error message "The remote or network path you have entered is not allowed under your current security settings" I am trying a copy in My Documents, and one on a remote server. Neither are...

Hi, I've made a database on access 2003 because i hate access 2007. I've put it onto our company server, and on an individual C:\drive on 1 pc to see if it s a server security message but it isnt. Every time i run a macro, whether it be to move records or generate reports i get the message...

thanks for the quick answer

Hi, I have an input mask which forces upper case for the first letter of a name field, and then lower case for any subsequent letters (e.g. >L<L?????????????????). If i enter data in a table it works fine, but in a form it does not work. However, if i put data into a form and then view it in...

Thanks for the suggestion. I did set up a relationship between the query and the assessor lookup in the learner table in relationship view. Im guessing this was the wrong way to do it as it didnt work. Forgive me as im probably asking a daft question but where/how should i make a link for...