Search results

Sorry to keep bumping this one, I wondered if anyone could pleeeeeeeeeeeeeeeeeeease help me coz this is a major hurdle that I need to get past to carry on :(

My combo box problem is still at large! I've tried every way i can, and i cant get the rowsource query right. If someone could look at this and post a fix, so that when one uses the "training record" form it allows you only to select course dates that are already in the tbl_course_dates table...

Anyone help? Ive tried to build the SQL myself but i just get blank form fields so it must be wrong :( SELECT tbl_course_dates.course_date FROM tbl_course_dates WHERE tbl_course_dates.courseID=Forms![Training Record]!course_title_combo ORDER BY tbl_course_dates.course_date

Hi Thanks for the reply - could you point me in the direction of it? I have looked through and couldnt find it, i guess it may have a name Im not looking for! G

Pretty simple i hope: I have a few "next record" kind of buttons and when you reach the last, or you are on a subform where there is only 1 matching record to the parent, instead of this un-user friendly message, I would like it to say for example: "No more surgeries to display for this...

OK ive spent half the day on this now and am none the wiser. In an earlier thread i was shown how to make a 2nd combo box use the value selected in the first to narrow down a range of dates for courses. The example works fine and I understand it with the following two select queries: tables...

This is my lame attempt so far... the table/field names may differ slightly from my earlier list but i dont think that is the cause as they are correct in terms of the db although not standardised... SELECT [Training Courses].course_title, tbl_course_dates.course_date FROM tbl_course_dates...

Right, I thought I had this nailed but my SQL syntax is not good enough! I understand the principles here but can't put it into code. tbl_training_courses: courseID(pk), course_title tbl_course_dates: courseID, course_date, coursedateID(pk) The example Zip file above works fine, but i cant...

Brilliant, that makes perfect sense with your example :) Thanks very much! Gazz

further question: Using 2 combo boxes - 2nd one list depending on selection in first (pls see end of thread for further clarification) Hi I am trying to achieve the following using 2 combo boxes Box "a" is a list of courses from tbl_training_courses. The user selects the appropriate course...

sorry to repost - anyone got any ideas on this?

Isnt there also another format access can save in, not an mdb, which allows users still to enter data etc but wont let them play with design view, tables etc...?

would you mind sharing what you did? I came up with one way of making data "editable" ie just have it in labels on form A (read only, effectively) and then form B is virtually the same but uses text boxes. If theres another way i'd be interested!!!

There are two main methods of navigating around the top-level form on the database I am currently working on. One is by a drop down menu listing GP practice names - so you can scroll down to "Dr Watson" for example and then all the subforms display the correct info. The second way is by...

OK i think that makes sense. So the & character is concatenation? I've done this in PHP before but not in Access. That all sounds good so i shall try it, thanks again.

Hi Im trying to deal with this exact problem now! Where would this above code go (in the underlying query?)... and also could someone just explain what it is doing? I THINK its saying that if a null value is found in field Address1, then just print a blank character essentially, but I dont...

OK cool ill try that in a mo! PS didnt mean to double post - got a "page cannot be displayed", but i always copy posts to clipboard in case i lose it, so when it did that i just did a new thread coz when i went back in browser, the text was gone! and hence the slightly different title!

OK I have a query which selects training courses attended, between user specified start and finish dates. The query works fine, and the report displays just fine - What I would like to do is to put those dates at the top of the report ie the title of the report: TRAINING SPEND SUMMARY FROM...

awesome i have it working now :D I found the button (Sorting & Grouping on the report design toolbar) Thanks a lot!

Sorry to sound like im useless but how do i insert one? I cant find a button or menu option that does it!