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

    how to export binary data as image files

    Thanks - I did try this method, and it doesn't work. The OLE field already exists ("Photo"). If I add Photo to a form, either as a bound object control or from the field list, it displays nothing. I have checked all the properties for something that would change the display, but to to...
  2. caitlin

    how to export binary data as image files

    Hi folks - I've done a search on "long binary" on this site, but found mostly VBA suggestions for my problem, and honestly I don't know how to do anything in VBA. Here's the situation - my employer has an ID-card-making database through which digital photos are added to student...
  3. caitlin

    Speed up a union query?

    Hi folks - Just wanted to update you on this. Union vs Union All didn't make much difference. I combined the two tables into one table, and it did help speed things up a bit, but it turns out the union query wasn't really the crux of the problem. The union query was based on two queries that...
  4. caitlin

    Speed up a union query?

    Is a union query typically going to perform much slower than requesting data directly from a table? I have 2 tables, each with 60,000+ records, that represent enrollment of a district's students for this year and last year. I could combine them into one huge table of 120,000+, but then I worry...
  5. caitlin

    Speed up a union query?

    Here's the SQL: SELECT * From qryStudents0203 UNION SELECT * FROM qryStudents0304; The webpage only pulls records for the selected student using an ASP query string (students.asp?Matric=123456), but the user can select any matric number from the list, so they all need to be available. I'll...
  6. caitlin

    Speed up a union query?

    Hello all - I have a huge union query that serves as the basis of several pages of a web application. It combines the fields of two tables that each have about 66,000 records. It works fine, but it is dog slow. I need all the fields, so I can't remove any. The numeric fields are indexed. Any...
  7. caitlin

    How to edit a query without regenerating the table

    I manage several sites that rely heavily on tables containing database results regions drawn from Access. The tables are all formatted a specific way (colors/size/fonts/etc), and if I need to add a field, change a field name, or otherwise tweak the query, using the Database Results Wizard...
  8. caitlin

    Front page 2003 ? questions

    One thing to consider - I got the beta version of FP 2003, and although it does have many cool features, they only run on Windows Server 2003. So if you're not planning to upgrade your server, most of the benefits are lost. There are no server extensions, for example ... it's a whole different...
  9. caitlin

    Randomizing a list of items

    Recently I had to create an online quiz, and we needed the answers to each question to appear in random order. I found that it's very easy to do in Javascript. Here's an example of a randomized list of choices: 1. First, create an array and name it ("choices") 2. Then list the items in the...
  10. caitlin

    How to use ASP variables in Response.Redirect statement

    Thank you, bahakh! The syntax rule appears to be: 1) use & in front of the variable, and 2) keep the variable outside of the quotes. <%Response.Redirect &quot;teacherclass.asp?TeacherID=&quot; & variable %> This works! Thanks very much - Caitlin
  11. caitlin

    How to use ASP variables in Response.Redirect statement

    Hi folks - I'm drawing a complete blank - how do I use an ASP variable inside an ASP statement? I've forgotten the correct syntax and can't find it in my books. Here's what I want to do: <%Response.Redirect(&quot;teacher_classlist.asp?<%=varTeacherID%>&quot;)%> varTeacherID is my...
  12. caitlin

    Control table formatting with CSS instead of HTML?

    Hi everyone, I have a site that generates 25+ tables on different pages using ASP. I want to format them all the same using CSS instead of going in and manually changing the tables in HTML (especially since I often have to regenerate the table, which erases the formatting). I'm not having any...
  13. caitlin

    Database query w drop-down - how to keep chosen value selected?

    Hi all - I'm using the FrontPage Database Wizard to create simple ASP pages that query an Access database. The query is done with a drop-down list. However, once the user chooses a value and the page updates, the drop-down is empty. Is there a (hopefully simple) way to make the drop-down...
  14. caitlin

    Database query w drop-down - how to keep chosen value selected?

    Hi all - I'm using the Database Wizard to create simple ASP pages that query an Access database. The query is done with a drop-down list. However, once the user chooses a value and the page updates, the drop-down is empty. Is there a way to make the drop-down maintain the user's choice when...
  15. caitlin

    How to make chart include all categories even if empty?

    Hi folks - I've created a report that consists mostly of charts depicting test scores based on subgroups. Each chart includes a category for that subgroup and a category for &quot;everyone else&quot;. The fields I am drawing the charts from show a 1 if the person is in that subgroup, or a 0 if...
  16. caitlin

    Documenter: only list table field names &amp; descriptions??

    Thanks! I tried the EZ documenter (freeware) and it provides just what I'm looking for -- a simple overview of the fields in my tables, including descriptions and index info. The program creates output for all tables in the database, rather than just the one I need -- and some of them are...
  17. caitlin

    Documenter: only list table field names &amp; descriptions??

    Hi everyone -- The Database Documenter seems to give you all or nothing ... for each of my tables, I'd like to print a list with only the field names, data type and description (basically a printout of the design view screen). But in order to get the description property in the Documenter, you...

Part and Inventory Search

Back
Top