Search results

I am trying to make a contacts telephone database. Staff(TelephoneNumber, Name, Team) Assistant(TelephoneNumber, AssistantNumber) A staff member my have several assistants or people who work closely with then in the same team. So if the person I was trying to call is not available i can try an...

I have a sub-form on one form which I want to copy data from onto another sub-form on another form. I have a button on the form which loads the second form and creates a new record at which point I want to copy the relevant data from the first sub-form to the second one. How is this possible...

Can some genius please tell me if my database is in 3rd normal form? Relationship diagram Thanks for the help Martin.

Relationships and tables! Take a look at my new relationship diagram please. I am trying to make a stock control system for a small shop that takes order as well as "normal" transactions. Have i made the correct relationships between them? I have several tables all connecting to the same field...

For a report i have two fields. If these two fields are equal then i want them omitted and another one in there place. How would i go about doing this? Thanks for the help Martin.

Select * from tblGradeBoundaries Where SubjectReference = " & Me.Subject_Reference & "; This is the code that is attached to the on update event. I am trying to select a record from a given value from a drop down box. I just can not seem to get it to work. Any ideas would be much appreciated...

Select Case [tblScript].[OriginalMark] Case Is < [tblGradeBoundaries].[E] [OriginalGrade] = "U" Case Is < [tblGradeBoundaries].[D] [OriginalGrade] = "E" Case Is < [tblGradeBoundaries].[C] [Original Grade] = "D" Case Is < [tblGradeBoundaries].[B]...

I have two table: GradeBoundaries(Subject, A, B, C, D, E, U) Script(CandidateteName, Subject, Mark, Grade) Each subject has different grade boundaries. I want grade to automatically update. How would this be possible. I am new to access and would really appreciate the help even if you don't...

At the moment I have two tables: SUBJECT GRADE BOUNDARIES(*Subject referance, A, B, C, D, E, U) RE-MARK SCRIPT(*Candidate number, *Centre number, Title, Surname, Fore Name, Original Mark, Original Grade,Re-mark Mark, Re-mark Grade, Return Script, Date Submitted, Subject Referance, Re-marked...