Search results

Thanks for the responses both! I do have both Product ID and brand, so I'll have a play around with these and see what splitting the field apart gives me, linked into a lookup table. Thanks.

Hi, I'm a basic access user, and I have set-up a product management form, however I am stumped on the following section: I have (outputted from our main stock management system) a field displaying a product reference e.g.: CEBE KIDS 1772_0043 MATT BLACK CEBE KIDS 1747_0043 MATT BLACK KC...

Hi!, I think I've finally lost the plot, this probably has a really easy answer to it (I hope)! I've got all my users entering data via the a main form - this main form and many of my subforms have expressions on lots of field to automatically calculate data. The problem I have is that this...

Sorted It!! See I said I was close! I just set the combo box to unbound and used the combo box which was sourced from the table with the course names as records not field names. It works perfectly now!!! (HUGE SMILE)

Hi, I've been attempting this for about 1.5 weeks now and it's finally getting to me. What I'm trying to do: I'm trying to set up a form that shows a combo box (displaying course name) from which the user can select a course (as query criteria) and enter data for all students who are on this...

Cheers Adrianna I tried putting in the end if's but it still isn't working....however I have sorted out the problem in a different way... I put in two unbound text boxes which said (if grades over 50 then pass if not fail etc etc) and then in the controlbox I put an Iff statement - with...

yep.... I just copied and pasted your code in - and changed the [ControlBox] to the actual field name...and then I tried it as a straight copy and paste.....

It still isn't working Cheers for your help Adrianna, I tried putting this in but it keeps coming up with the following statement: Compile Error Else without If I think I'm going to have to go back to the drawing board and look at the structure of my database to see if there is another way to...

Thanks Fuga...but? Cheers for pointing me in that direction Fuga....I have attempted to put a Select Case Phrase in my coding under the text box, but it isn't working. This is the code which I have put in: Private Sub Final_Result_Awarded_All_Systems_BeforeUpdate(Cancel As Integer) Select...

Hi!, I have two different types of marking schemes for students in my database. However I want to show only 1 final mark field (Pass/Fail) for use in report pull ups and pie charts (showing % of fails and Passes) I have a combo box from which the user needs to select which marking scheme the...

Cheers Sebby!! Tha worked fantastic - thanks a lot!!!! :D

Cheers Guys - but still confused...... Wizcow, I don't think DLookup would work, unless I am mistaken - don't you usually use this when you want to specify a criteria to look up? I just want to show the value in the field at all times.....bit like a duplicate of the field - but as they are in...

Hi!, I want to create a report design for my database which prompts Users for [coursename]. I don't want to create a report for each of these courses as we have over 80 and we are also always adding new courses. Ideally what I'd like to do is to have the User press a command button on the...

Hi, I have a main form with a number of sub forms. In one subform I have a number of fields which display data on what day study sessions are on, i.e. Study Session 1, 2, 3 etc I then have on another subform a number of fields which show the hand in dates for assignments. I want to be able...

Many Thanks HTH Thankyou thankyou thankyou. That has worked fantastically......!!!! :D :D

Hi!, I've been trying for the past 3-4 days now to set up a form for data input of student records. I need to be able to 'blank out' some of the fields so that users can't input into them accidantally or until a specific entry has been made in a previous field. I have tried this 2 different...

Thankyou! Cheers for this, I'll give it a try out and let you know how I get on! and thankyou for the tip - I appreciate any advice! Cheers once again! :D

Can't see the stars for the clouds!! Hi John.Woody, I still can't see the stars for the clouds - probably staring at this screen for too damn long..... :) Am I grasping this theory right? that if my Main Form is originally called 'Main Form', my subform is called 'Grading' and the pop-up...

Thanks for this John.Woody, I'm a bit of newbie at some aspects of Access, and have set this command up via the wizard. If I go into the properties of the command button and then into the module info, should I put the info you provided in this section? or am I missing the plot completely...

Hi! I've designed a subform for my main form, with a series of command buttons to open pop-up forms for data entry purposes. The command buttons work fine when you purely open the subform as a form. However when I put the subform into the main form and try to work the command buttons from...