Search results for query: *

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

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

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

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.

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?

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

THanks so much that worked very well.

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

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.

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

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