Search results

does anyone have any clues?

sorry to bring an old thread back from the dead, but i've been trying for ages and i still can't get this work! any help?

still has the same error! :(

the way the status column works is that the badge can have a status of Earned or Received. When i add the badge to the cub, it gets the status Earned and then once given to them, i would change it to received. This then enables me to create reports detailing cubs that have earned but not...

i think i'm being really stupid! how would i go about doing this? is it like: INSERT INTO tblCubBadge (cubID, badgeID, status) VALUES (frmEditCub.cubID, 72, earned) WHERE frmEditCub.totalhikes >= 20 i semi-got this off a website..is it in the right direction?

you're a legend, i'm really rusty with database (did it last properly about 3 years ago, what i've done so far in several days you could probably do in about 2!) can you walk me through (in english, i'll try and translate it to sql) what exactly i need? where i need to specify etc. [i thought...

I appreciate that this is hard, and i am probably explaining it in a backwards way, let me take a couple of screenshots and walk you through waht i would be doing...thank you for your time! :D this isn't for every badge, only for the badges for how many nights they have spent away with us. For...

i have all that, all i was wondering was if there was an easier way. If i have 30 cubs that all spend 5 nights with us, it means i have to go through each record changing the amount of nights spent and then go to the sub form and add each badge to each child, i was merely wondering if this could...

i've got a many to many relationship set up with a table in the middle, all i want this code to do is create the record.

it wouldn't bee from nothing though, the cubs record would be open (which would contain the cub ID) and the badge has a constant ID (say, 25) so when the number goes over 5, i would like it to create a record with the current cubID and a predefined badgeID with a predefined status.

no the record does not yet exist, thanks, will have a play round with it and get back to you

anybody got any clues on this?

i have got the form to do that, but i would like it to do it automatically, so i don;t have to keep flicking between the two forms

Ok, how would it be done?

Hello I am currently constructing a database to keep track of my local cub scout groups badge achievements. There are badges available for how many nights away the cub has completed, these are staged in 1, 5, 10, 20, 50 etc. I have a box attached to each record that keeps track of how many...

works a treat! thank you!

looks exactly the same., but can't work out what i've done wrong! i've attached my databse - its the frmEditScout form i'm having trouble with, if you have a spare second could you please have a look? thank you kindly

i went to the form properties and did 'Order By' but it doesn't seem to work for the buttons

Me again! I have a combo box with a list of scout names, in alphabetical order, but i also have Next and Previous record buttons which cycle through the records in scoutID number, which i don;t want. How do i get them to go to the next record alphabetically?

ahh thank you very much - but i found an example database using Artists and Albums which helped greatly. Thank you Tiro, its much appreciated! Now [next problem!], i have a form and subform (very similar to the one that you supplied). I have over 125 badges in the database, and it could get...