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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. DemBones79

    Enumerate (count) records in groups

    I think I figured it out: select t1.district, t1.order_no, t1.tr_date, sum(case when t2.tr_date <= t1.tr_date then 1 else 0 end) as tr_seq from tbl_example t1 inner join (select district, order_no, tr_date from...
  2. DemBones79

    Enumerate (count) records in groups

    I have a table that stores (among other things) district number and order number. Each order can have multiple transaction dates (each time it has been touched). What I need is a SELECT statement that can give me an ascending sequence for each record grouped by district and order. So if the...
  3. DemBones79

    Cancel button not working

    Thanks again for your help, but unfortunately it didn't work. I was no longer getting a syntax error, but the dialog still wouldn't close. I played around with a few things and what I finally came up with was this: Function dlgFNRFunc(identifier$, action, suppvalue) dlgFNRFunc = True...
  4. DemBones79

    Cancel button not working

    Thanks for the reply, but I had tried something similar before and just tried your code as well, but I get a compile error "Syntax Error" on the CancelButton 67, 88, 50, 14 .BtnCNCL line. Is there something else I need to do? Syntax Error is awfully unhelpful, but since the only thing that...
  5. DemBones79

    Cancel button not working

    I have inherited several macros from my predecessors. One in particular is giving me a hard time. It never had a cancel button before, only an OK. I've tried coding one in and it appears just fine, but it doesn't actually do anything. I'm afraid I don't understand the rest of the code well...
  6. DemBones79

    From Attachmate to SQL

    I know that VBScript can communicate directly to a database through ADO connections and SQL. Is there anyway to get the VB-like macro language of Attachmate to do the same? Alternatively, is there a way to pass variables from the macro script to a .VBS file if you can't connect to a database...
  7. DemBones79

    Message tracking

    We have field users who send messages to us through Attachmate, and message center personnel who receive and respond to those messages, also through Attachmate. We've been using a macro bound to the "Enter" key to record messages and replies. The macro uses GetString to grab information from...

Part and Inventory Search

Back
Top