Recent content by dragginthru

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

Is there any chance of you posting an example of the form? I can vaguely work VBA but am not clear where it would go etc... thanks!

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

Yes you did mate, I did reply to the post that I still didnt get it. I failed to adapt your code correctly :( Also this is a slightly different one. HOwever looking at the above example I see that there are .'s as well as !'s - i was only using the latter so thats probably the issue, just a...

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'm still stuck on this, so if anyone fancies helping out... ;)

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

OK I know what the subformcontrols are now, thanks :) I have checked on my forms and the subform controls all have the same names as the forms. So the final hurdle - how do I reference it correctly? The form works FINE as a standalone- its only when as a subform that the problem occurs. Heres...

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

I had a go but cant work out where to put the new bits: If course_title_combo <> "" Then MsgBox "You are about to change the course title. You will be required to select a new date also. Are you sure you want to do this?" End If End Sub SO i dunno where the Me!courseID.Undo should go, or...

So effectively the control is the combo box (in the form which the subform is nested in) that is the master link to the child one in the subform?

Getting there bud, I'm getting there...! So does that mean I can only get it to "undo" the change if I create temptables...? See, what I am essentially after is that a user changes combo A from eg "Course 1" to "Course 2" - if they click OK in the msg box then the change stays, if they click...

Thanks for that - if you could perhaps clarify the above then i will have a working solution! :D

Right, I have it as follows: Private Sub Combo39_Change() If course_title_combo <> "" Then MsgBox "You are about to change the course date. Are you sure you want to do this?" End If End Sub Which is fine and I understand, its saying if the value of combo 39 is not equal to "" then do the...

That kinda makes sense Ken and I appreciate your help... Im still confused... What is a subformcontrol? Is this a series of properties for the frame that the subform sits in? i really cant get my head around it :S