Search results

I have set up a macro within Access 97 to run several queries and I would like to run this macro via Outlook tasks. The area that I am struggling with is the command in VB to run this macro at a specific time.. Can anyone help please?

Timed Queries Help Hi, I am looking to run a query to append to a table but wanting to do this at a specific time each day rather than manually or on an action. Is this possible?

This should be an easy one but can't get it to work.... I have a query that pulls the date from the form. Simple enough I have a 2nd query that I need to be a week prior to the "from" and "to" date on the form. I have set up these extra date fields on the form and have said in the control...

Hi, I have a query that performs a number of counts and then produces an expression that is a % of 2 other sum fields. What I am struggling to do is perform a count of the number of records in the expression that are <5 Any ideas please?

I am having a few problems displaying a msgbox based on a populated field. What I need is a bit of code that says on update of a combo box, if the word in this box = the same word in a specific field on a table then display a message Any ideas please?

I have an expression on a report that works out a percentage between 2 fields. The expression is just on the report and not on a query so is it possible to filter out information based on this % expression?

I have a bit of code set up that when running a report it creates a separate rft file for each area but if one area has no information if stops with a Run Time Error 2501. How do I get it that if an area returns no information it then doesn't produce a rft doc and carries on?