Search results

My users are complaining about the database taking an extremely long time when doing searches on my form. What they do is click on the field that they want to search and then click on the binoculars (which is just the built in search), and it seems to take forever. It's a network database so...

Rich--Thanks for the info, I did a little test on that, and your exactly right. I'll work on some kind of a workaround. Thanks -db

I'm almost done with my dataentry form, however it looks pretty bad. What I'm trying to do is to size a continous form dynamically. So if on a continous form I have a question and an answer, is there someway to size the detail section depending upon how large the question is? If it's a really...

Excellent, Thanks very much!

yes, that's exactly what I want to do, I would like to see how you setup the form, so that your can see multiple questions at once. -db

I've setup a survey database with about 50 questions. I'm curious as to how I can create a form that will work with my database. I have 3 tables, 1 employee table with a primary key as an employee id. 2nd table is just a lookup table with all the questions in it (so just 2 columns), then a...

I have 2 tables that I need to report on, one table has a bunch of student_id's which is my primary key, the second table has 2 fields one is a status, and one is a date. During the lifetime of the database it's going to have 2 status choices for each student, one is a "recieved", and one is a...

I have 2 tables that I need to report on, one table has a bunch of student_id's which is my primary key, the second table has 2 fields one is a status, and one is a date. During the lifetime of the database it's going to have 2 status choices for each student, one is a "recieved", and one is a...

I've read that if you use grouping within DAP's then you automatically create a read only page. I know that with access there's almost always a work around for everything. If there is some kind of vbscript I could use I would greatly appreciate it. Thanks so much. -db

I have a form that has a query subform inside of it. Most of the people who will be using this database won't know how to right click on the column headers and choose to sort accending or whatever. So my goal is to have a command button under the query that says something like "Sort by...

I figured it out, sorry I didn't give you enough information. What the problem was is that it wasn't bound to the correct column, it was bound to the index, instead of the name. (I have a table for each of the combo boxes I've created, and that table has an index, and a name). Thanks for all...

I might be missing something, but I won't know what the column number is since, depending on what color they choose it will change from 0 to 1 to 2. Thanks for the quick response.

I'm referencing a value in a combo box on an open form for a text box in my report. Instead of getting the value I get the location on the list. For instance My combo box could have red, green, and blue. If I highlight Blue and run my report (I have a text box that says...

Thanks Chris I'll give that a try, now if I could just get this form to work for my reporting criteria I could use that correct?

I know I need a form to create some criteria for inputting date ranges, ID's, ext. (I'll try looking through previous topics). However I'm having trouble finding a simple way of reporting on this criteria. I have a simple survey database in which users in *ONE* record will have to answer...