Recent content by tma12000

Hi there, I've been trying to figure out how to open predetermined url from a macro, but the only thing I come up with is the OpenURL option which asks for the URL you want to open. Is there a command set as a macro that will allow me to tell it what the URL is up front so that every time the...

Thanks so much, that did it!

To add...the expense date format is dd/mm/yy... Is there an easy way to remove the day from that format. This is the crux of my problem.

Heh heh thanks Chaz, I thought about that.Unfortuanley I am looking at expense line item data so I have several lines per person per month. When I put the date filter on (to just look at Jan for instance) it outputs every expense list for that month and thus gives me an avg per line item. So I...

I am trying to create a output field in a query that takes the sume of a field called "spend" and divides it by the count that same field, thus giving me an average. Here is the code Ive tried that has not worked: Avg Monthly Spend: (Sum([Expense Amount]))\(Count([Expense Amount])) I...

Pat, thanks for the suggestion. I would consider, but I have no vb experience at all and would have no idea how to get it done. Thanks, Tim

I am trying to send the output of a query to a set email address in excel format. Will the macro still run if there is no output from the query? I would prefer that it didn't, but no where in the macro does it allow for such an option... any thoughts? Thanks, Tim

It appears it did... thank you guys so much for your help! Tim

The command line is D:\path\dbname.mdb /x macroname The macro is pulling data from a db that exists over a network.

The macro sends information over a network to another db. I have users who log into the db remotely that do not have access to the destination directory, so if it is in Autoexec, the macro fails. Thanks, Tim

I should add... I do have things running in AutoExec... would that interfere with it?

I am looking to run a macro from a command line. But whenever it runs, it opens the db and simply highlights the macro I want to run, without actually running it. WHat am I doing wrong? D:\path\dbname.mdb /x macroname Thanks, Tim

Glen,can the following line... &quot;WHERE ([ExpDate] = #&quot; & Date & &quot;#);&quot; Read as &quot;WHERE ([ExpDate] <= NOW I need for this to work when the date has hit or passed. Is the NOW function valid in VB? If not, how do you think it should look? Thanks SOOOOO much for your...

Glen thanks so much. You will have to forgive me... at best I am a decent Access user... My last quest is... where do I plop this code? In a module which would then be run out of autoexec? Thanks again, Tim

Ginger, yes, the email addresses are stored in a table. I have a query that looks at service ticket#'s and their expiration date. When the exp date hits, I want to send a note to the email address stored in that particular record to the person who is responsible for the ticket. That means...