Search results

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

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

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

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

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

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

Hi! I'm trying to create an IIf statement which will produce a yes or no answer, what I want to say is: =IIf(([Case Study Actual Grade]=”A”,[Audit Actual Grade]=”A”,[Exam Actual Grade]=”A”,[Project Actual Grade]=”A”),”Yes”,”No”) but it keeps coming up with #name? Can anyone assist me on this...

Hi! I'm currently transferring a load of data from an excel file to Access 2000 as part of designing our new database. I need to recreate the following Excel formula so that it works in Access: =IF(AND(G16>=15,M16>=15,Q16>=15,W16>=15),(G16*0.15+M16*0.15+Q16*0.3+W16*0.4),"") With G16=[Case...

Hi! I have a problem with a combo box in my form, which when having specific data selected from it (e.g. in this case "Distance Delivery") displays a pop-up form to request information from the user. Unfortuantely I can't seem to make the pop-up form display only the current record (rather...