Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tma12000
  • Content: Threads
  • Order by date
  1. tma12000

    Opening a URL from A Macro

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

    Tough Query Question

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

    New SendObject Question

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

    /x macro function

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

    SendObject Function

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

    Date Format in a Query

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

Part and Inventory Search

Back
Top