Recent content by caitlin

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

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

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

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

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

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

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

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

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

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

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

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

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