Search results

I came across this problem, im only a newbie so I chickened out and made it into a single form. However for my purposes a continuous one would be better and avoid the confusion. If there is a way this can be accomplished, it would be nice to know - experts...?

OK as part of my combo box dilemma I want a message to pop up and say "are you sure you with so change the xxxx field". This is because it seems all to easy to accidentally use the scroll wheel without noticing and change someones course date in error! ( i keep doing it on my mock database) So...

Yup, that works fine. Not sure if thats the "official" way, or if I've now just concatenated the & symbol, but I dont care really :rolleyes: !!! Thanks mate!

Hi guys I want to put "E&OE" on the bottom of an invoice, which apparently means errors and ommissions excepted. However the report obviously is taking this as some kind of concatenation and is thus showing EOE! I know how to escape characters when Im doing stuff in PHP but not in access...

Right this is a fundamental issue for me here and I cant get my head around the problem!!! The database I am working on is a database which records the training courses (run by the NHS) which staff at GP surgeries in our area have attended and acts as a booking system for them. So we have the...

OK ive got the two boxes working perfectly, with the concatenated results being the only thing displayed in them, great thanks :)

OK the first error was that I had accidentally deleted the SALUTATION field in the query. However I still dont know how to make that part of the query show in the box... :(

How do I change the width of an individual field in the combo box? I havent done that yet, I set it up in the wizard... Ive attached a screenshot of what is happening

OK the syntax is working now, but... ive done that but now a new problem presents itself: Once you have selected a value in the first combo box (the GP surgery), a parameter box comes up asking for get_surgery_staff_details!Salutation

Cool idea thanks :) I understand what you mean there but dont quite know how to put it in and into what box though! I have the query in design view and have created the column. I tried: ="salutation" & " " & "first_name" & " " & "last_name" in most boxes and didnt work! :(

OK ive got my 2 vaguely working combos which select the surgery, and the staff. On the same form I want a couple of tickboxes which show for example, whether a person attended the course, if they had to pay etc (all yes/no answers). How do I get the tickbox to update? i have tried to requery...

I have set up a form which has 2 combos. Combo A pulls from a query which gets surgery address1, address2, and surgeryID. It displays only the first 2 fields. Combo B gets info from a query getting staff firstname, surname, title, staffID and surgeryID, and shows the first 3 fields. I have...

This works fine mate and I appreciate your help. However Ive noticed one little glitch and I cant work out how to fix it. When using the form it is always displaying multiple records one above each other. I have found that if one selects a course in box A - ALL the box B values change!!! So...

I think there is a purpose to all tables... The example I posted only has the offending tables and forms in it. The table "training record" is actually written to by the training record form as a subform which is within a form for staff details. So a member of staff can be added to the course...

aha i think it was in read only mode coz i was looking at zip file - i THINK thats it sorted.... thanks very much :)

I can see you have made alterations, IE added a query etc. However still I get incorrect dates in the form... also it wont let me change the value in the first form :S Sorry to keep coming back saying "duh, i cant do it" - sadly i am pretty new to this...

OK ive done that now - ie. put combo43.requery in the afterupdate property of the course_title_combo Its still not working, there are 2 probs with it... 1. It is still showing incorrect dates - if you look in the table, the dates are quite distinct for each course - but its showing the same...

Thanks for having a look :) Basically (not included) is a seperate form which writes to the training_courses table (ie. user inputs the title, cost etc) and there is a subform which the user can enter dates for the course. This is how the [Training Courses] and [tbl_course_dates] are populated...

Thanks for the reply... I swapped the query round but no difference. Re: 1st column - i think it is, yeah. But im pretty new to all this so unsure. how do i confirm this? http://www.access-programmers.co.uk/forums/showthread.php?t=94618 A version of the DB is there if you fancy a peek at it...

Ive posted similar in the forms section but it has gone unanswered so I've pulled out the offending query and hope someone here can offer insight into this frustrating problem. I have a form [Training Record] that has 2 combo boxes. Box A (course_title_combo) has the titles of the various...