Search results

Hi DCrake, thanks for that it now recognises it. However it still picks up the quarters frm other projects. The code doesnt reset when you go to another project. here is the code for it: Private Sub Command5_Click() If DCount("Quarter", "Test", "[Quarter] = '" & Me.Quarter & "' And...

Following code does not pick up "Quarter", i am not sure why Private Sub Command5_Click() If DCount("Quarter", "Test", "[Quarter] = '" & Me.Quarter & "' And [ProjectId]= " & Me.ProjectId) > 0 Then MsgBox "Sorry sir....this quarter has already been entered previously. try again!" End If...

hi there i have tried entering in the code however it still seems doesnt to work. It still brings up the error message of "quarter used". It still picks them up in other projects here is the code that i put in: Private Sub Command5_Click() If DCount("Quarter", "Test", "[Quarter] = '" &...

Hi Scooterbug, is the following code the right place to put the requery in: Private Sub Command5_Click() If DCount("Quarter", "Test", "[Quarter] = '" & Me.Quarter & "'") > 0 Then MsgBox "Sorry sir....this quarter has already been entered previously. try again!" End If DoCmd.GoToRecord , ...

Right following code works, however when i try and enter in a quarter for a sperate project it picks up the quarters from the previous project. Is there a way to reset the code for individual projects?? If DCount("Quarter", "Test", "[Quarter] = '" & Me.Quarter & "'") > 0 Then MsgBox "Sorry...

Hi there i have now tried that and it still comes up with error message even when i enter in a different quarter. Here is my code: Private Sub Quarter_Period_AfterUpdate() If DCount("Quarter_Period", "Claims", "[Quarter_Period] = '" & Me.Quarter_period & "'") > 0 Then MsgBox "Sorry sir....this...

any ideas??

I put the code in the after update function in the quarter period box. if that helps?? thanks

Hi, i tried the code you gave me however it is not working for some reason. this is what i entered in Private Sub Quarter_Period_AfterUpdate() If DCount("Quarter_Period", "Claims", "[Quarter_Period] = '" & Me.ControlName & "'") > 0 Then MsgBox "Sorry sir....this quarter has already been...

hi i am trying to come up with a way to check previous records. so when users enter in a quarterm period eg . q1 2009 and then want to add another quarter, is there code where acess will check the previous quarter entered and make sure its not entered in again?? thanks

Hi Neil thanks, how do i go about creating that?? Do i go on the Emries target tables?? If so i have gone onto the indexes icon and project ID and Target ID are both on there....... thanks Paresh

hi, i am trying to prevent duplicate data. i have a field called Targets and have 12 targets that any project can have. However i am trying to avoid end users to input the same target more than once for a particular project. Each target has a P.K and have set it to no duplicates, however it does...

Hi i have created a table with some targets that projects can have. i have created a form based on this table and it displays all the targets that can be chosen by using the selceted tick box field. Now when i link this to the project form the targets disappear. I think this is because the...

Hi i am trying to make the field project reference unique, so that users do not enter in twice. Now it is not the primary key so any ideas as to how?? i have tried to change the settings on the index. Index(Ok No duplicates) but it doesnt allow me to. I have checked that there isnt any...

Ah excellent thank you Atomic Shrimo, however i think my code is similar to yours but still asks me for a figure. Here is my code: SELECT Projects.[Project Reference], Sum(Claims.[Actual Claim Amount]) AS [SumOfActual Claim Amount], Projects.[Project Name], Projects.[Total Grant], [Total...

Hi, yer i did enter in [Total grant]-[Sum of total claims] and it is picking up the total grant but not the claims. DO you think this happeneing because i have had to enter in some sql code to add up the claims to display the "Sum of Total claims?? If someone can try creating a query and minus...

Hi, i am trying to minus to figures in a query but it is asking me to enter in the figures when they are allready available. Here is and example: in the query section added in fields X and Y tht have Number values in. so i have done the following Total grant Sum of total claims...

Apologies again, the letters are meant to be under AuthorityName

Sorry the first bit did go on. If i had the follwing table AuthorityID AuthorityName 1 a 2 b 3 c etc..... And then i created a form with 3 dropdownlists looking up the...

Dim row1 As String Dim row2 As String row1 = Form_Authorities.Authority_1 row2 = Form_Authorities.Authority_2 Name of dropdown lists If Form_Authorities.Authority_3 = row1 Then Form_Authorities.Authority_3 = False MsgBox ("The Authority has already been chosen") End If If...