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

    Access Query performance help

    >Are you saying that the query always takes awhile to load >when you first open the form or have you tried opening the >form using both queries and get quicker results with the >2nd query? Yes, quicker results with the 2nd query and network traffic is less then 500k. When using the "where 1 =...
  2. dojones

    Access Query performance help

    Using Access 2003: The db is split between a front end/back end and in this case is querying one table called students with about 10k records When the form is first loaded a subform in gridsheet view executes a query. SELECT Students.State, Students.Zip, Students.ID FROM Students WHERE 1=2...
  3. dojones

    Table AutoIncrement Problems

    I have inherited a paradox 5.0 database from 1995. One table called PerfM has a structure of: [Perf#] [smallint], [Perf_date] [smalldatetime], [Perf_time] [nvarchar] (10), [Perf_comms] [nvarchar] (25), [AB] [nvarchar] (1), [C] [nvarchar] (1), [History] [nvarchar] (1), [HistDate]...
  4. dojones

    Please help me denormalize this result set.

    Could live without it as it is more of a display preference. Curiously it handled all of the seat concatenation in numerical order on the actual table this is being ran against. I figured this was due to the physical order of the data inserted into the #temp table.
  5. dojones

    Please help me denormalize this result set.

    Wow Karl, that was fantastic. And no cursor. THanks so much!! This works perfectly. One question, since my seat_num is actually a char datatype will the ordering of the comma separated list be determined by the physical ordering of the insert to the #sample table?
  6. dojones

    Please help me denormalize this result set.

    THis is a once a year data extract that I need to send out. I am trying to consolidate seat information on a per customer basis if their order consists of seats in the same row. If the seat_row is different then output two records for the customer. I am willing to use cursor if necessary...
  7. dojones

    Performance help...Subform retreiving all records from table

    THanks so much that worked very well.
  8. dojones

    Performance help...Subform retreiving all records from table

    I have inherited an Access 97 application. As table sizes have grown and users now access the application thru WAN, performance bottlenecks have appeared. After first splitting the database, I'm now trying to redesign a Search form which contains a subform that when first loaded currently...
  9. dojones

    Error 721 but only from the office wireless

    Yes, this issue has been resolved. It seemed to be a flakey wireless aceees point that needs to be reset more often then I'd like but at least it always fixes my connection issue. FYI it is a Microsoft Access Point.
  10. dojones

    Error 721 but only from the office wireless

    Thanks for replying. 1. I'm using XP built in client, I don't what they are using on their side 2. The vpn connection works when I'm at home on the same laptop using the same shortcut that I am unable to connect to when at work. BOth work and and home connect to the internet via a wireless...
  11. dojones

    Error 721 but only from the office wireless

    VPN connections from my home wireless ip of 192.168.29.11 goes great. I'm authenticated immediately and up and running. At the company I work for I am physically located where there are no ethernet connections. However there is a wireless access point, which grants me an IP outside of their...

Part and Inventory Search

Back
Top