Search results

I am making a database to coordinate the activities of my band (how rock and roll!)... Is there a way I can somehow host the file remotely, and have users (4 total) access that file through their own computer using access, so they can write, edit, delete records? We have a db at my work that...

Im trying to add a keyword search to my page - I've added a button and it works fine in bringing up the "find" dialogue box. However this defaults always to the "whole field" option, whereas what I want is it to default to "any part of field". Can this be achieved, if not, is there another way...

Hey everyone This issue is holding me back now on 2 areas of my project :( I need to know correctly how to reference a subform in a query. Can someone please give me a working example for this: main form: training courses sub form control: course_dates subform control sub form: course_dates...

I have a query which returns charge_cost (based on course cost, whether it went ahead, if hospitals are eligible for charging etc) which is then used in an existing report. I want to make another report which simply is: Total training spend for 2004-2005: £1276.04 And i just want that to be...

Hi I have been asked to do a report which for each training course provided, shows how many staff from each profession has attended (GPs, nurses, admin etc). The idea is that the trainers can then see if groups are getting enough training etc. I have made the following query (this is the SQL...

Heya Ive got my combos working fine now (thanks to all you kind folk on this forum!) but now that I have opened the main form (in which the combo box form is nested), once I have selected an item in the first one, and then click on the 2nd combo, a parameter box comes up saying "Forms!Training...

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

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

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

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

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

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

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

Im totally new to using reports so sorry if this is obvious! I have a multi table parameter query that selects the course cost, attendees etc and sorts by GP code (to become an invoice basically) that the user then enters the start/end date of the invoicing period. My report SHOULD like this...

Hi Im working on an Access Database at work. It records the training undertaken by NHS clinical, managerial and admin staff in Brighton. It is used also to generate invoices etc. I have a better knowledge of access than anyone else here (outside of IT department obviously) so I have been...