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...
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...
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
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
Can I use the email address listed in a record as the "To" field in this function. If so, what would the format in the "To" field look like? The table name is "user_info" and the filed is labeled "user_email".
Thanks,
Tim
Hi there,
I am trying to create create a query that will automatically generate a service ticket# when certain fields on a form are entered. The date is a Now() function off the original table. For purposes of the ticket# I need to have only the "03" pulled off the end of the date...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.