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?

Just about thank you, The format is coming out like this as my date format includes the time 26/01/20 04:** Should be 26/01/04 00:00 What do I need to add for this please?

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...

Thanks for your reply, I habe managed to sort it

I must be doing something wrong, sorry if this sounds stupid but I placed the "yourfield" with the field name of the expressions i.e. expr1 and now do I enter this in a new field or in the criteria of the expression? I tried both but got an error "The expression entered contains an invalid...

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?

Thanks, I have tried the Dlookup ("myquery") >0 Then Mrkmsg = msgbox("message", VBokonly) But I get a message saying Compile error: Argument not optional Any idea's 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?

Thanks, that worked a treat

Yes, that would certainly help

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?

It's okay thanks, sorted I entered a error skip and then a resume to bypass this Thanks for your help!

Thanks for that. The criteria on the qry is set to >0 and the report is running like a macro where it goes through and creates a doc for each person. I have got it to stop creating the error by putting in an error skip but now can't get it to resume for the next peson on the list. Any idea's?

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?