Search results

Oooh, it just occurred to me that it may not be possible to index memo fields the way you can with other data types. Then again, it would be the primary key that is indexed, and not the memo field, so maybe this wouldn't be a problem. Also, obviously, the combobox thing isn't going to work...

I think I need to better understand how the recommendations are related to the scores. It sounds like there is only one recommendation associated with each score. Is this correct? (That is, a score of 1 always gets recommendation X, while 2 always gets recommendation Y, etc.) If so, I would...

Hmmm, is there a reason why you're using three separate fields for Recommendations rather than one lookup field, like your [Score] combo?

similar solution - check for dups before appending records I was struggling with a similar problem, and thanks to this thread and the others it refers to, I was able to devise a solution. Since my code works slightly differently, I thought I would post it in case someone else can benefit from...

I’ve noticed that something similar occasionally happens to me, and I believe the problem occurs when I use an unbound main form to pass parameters to the query that underlies my wizard-created subform. The query works fine, but the subform displays nothing – whether viewed independently, or...

Super Bob Saves the Day! Works like a charm! Thanks so much for a VBA-free solution, and for allowing me to sleep a little better at night. ;)

I have a report (based on a query) that analyzes student progress on the GED test. Although the report functions perfectly most of the time, there is a rare exception that causes a calculated field in my query to be divided by zero, resulting in the display of #Error in a textbox on my report...

Thanks, Pat, for your reply. Door #2 is definitely what I’m after, I just can’t seem to figure out how to get there. When I base my form on the attendance table, I have a lot of trouble populating student names by class, among other issues. I’ve tried basing my Student Name controls on a...

Well, the plan was to use the form data in an append query that will store new attendance records in the Attendance table. I just can't seem to hammer out the whole [Contact Hours] thing. I would like for my attendance form to display a list of all the students in a selected class. Next to...

I apologize for yet another thread on tracking student attendance, but I’ve been struggling with this data entry form for longer than I care to admit. What I’ve been able to piece together so far seems to work (under limited circumstances and with a lot of assuaging), but there are several...

Heya, I've been working with Rod's lovely tutorial, but I'm running into a problem: Access is not allowing me to use an append query as the recordsource for my Attendance Subform. I've tried doing it several different ways. The only way I can get my attendance form to work is to base the...

Alas, this isn’t the first time Wikipedia has proven me wrong. (Damn you, Wikipedia!) It turns out the Neil is right and that I had a very foggy understanding of the difference between “normalized” and “relational.” I guess I’m too dumb for my Dummies book.:o On that note, I probably...

I’m no Access expert, but I might be able to take a stab at your questions. Neileg could very well be right. It sounds like you’ve got many patients, and each patient can be diagnosed with more than one illness. Conversely, each illness can correspond to more than one patient. Normalized...

My Hero!!! Thanks so much, Paul! You saved my day! I guess I'd gotten so accustomed to seeing (and ignoring) that security warning, I never put two and two together. Who knows how many current and potential problems you've just solved! I'm going to go outside and do some cartwheels now...

For some reason, I get that security message every single time I open Access. That's been happening ever since I got Vista, but I'm not sure why. I just choose Enable Content and keep going. Do you think I've got a bigger issue here?

Thanks, Bob. The form I'm working with is called Update Student Data. As a warning, when the form is opened, the unbound combo boxes that I'm working with are not immediately visible. For some reason, I have to scroll up to the top of the form in order to find them. (I'm not sure why this...

no dice Thank you, gentlemen, for your kind and expedient replies. Paul: The Bound Column property for Combo1 is set to 1, but I must admit that I am a bit confused as to how Access displays/stores foreign keys. I believe that Combo1 is referring to the primary key of a table called Classes...

Ah, I appreciate your kind suggestion, but I'm still not having any luck. I've tried requerying the form After Update and On Current. I tried typing this into Combo1 After Update event: Me.Combo2.RowSource = "SELECT [Student ID], [Last Name], [First Name] FROM" & _ " Students WHERE [Class...

I'm working on a form with two unbound, cascading combo boxes that work perfectly well when the form is first opened. However, if the first combo box is changed, the items in the second combo box are not refreshed unless I close and reopen the form. As per the generous advice found in this...