Search results

Hi i have a database with different primary keys for example ANUK1234 2mb ANUK456 2mb ANUK789 4mb SHUK8797 SHU7854 Now they all have different bandwith. Now i was wondering what code i need to input in order to get it to show me this: ANUK = 2 at 2mb ANUK =...

Hi there i have created a button which takes me to the relevant data of a specific ID. However when it takes me to the other form it only displays the data that is to do with the certain ID. Is there a way of a button taking me to the specific data that is relevant to the ID and allow me to view...

Hi, When i get the results from a query i want them to be numbered i.e 1,2,3etc. Is there a way of doing this??

Hi i want to create a searching fucntion in my form. I want the end user to be able to enter in the circuit reference and the form to show the details of that circuit. Any idea? Thanks

Hi i am trying to figure how to open a form showing no data in the fields. I have a new circuit button and what i want is when users click this button the form is blank ready for them to add a new circuit. Is their a way?? Thanks

Hi, i am trying to create forms and graphs based on some questionnaires i have. Now normally i would use excel, however i have been told to use Access. Now i have tried to enter in the questions into the field name however it only allows a certain number of characters. Is there a way of...

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

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

hi, i am trying to program the save button where On_click if a certain field is left blank then for a message to appear for them to not progress forward until the field is complete. any ideas??

hi guys im trying to create a loop where it goes through the authority fields without entering in each field. If it is the same then it should come up with a message. At the moment it works as the following: Dim row1 As String Dim row2 As String Dim row3 As String Dim row4 As String row1 =...

hi guys i am trying to open a report based on a certain field. So i what i am trying to do is when you press the open form button it automatically looks at the certain field the project reference field and opens up the report for that project reference. any ideas how to do this??

Hi, i am trying to find a method where if a authortiy has been chosen from a lookup box and users try to entert it in again in the same form a message will come up saying that "the authortiy has allready been selected". thanks

Dim newrec As Integer DoCmd.GoToRecord , , acLast newrec = Form_ChangeControl.Number.Value DoCmd.GoToRecord , , acLast Form_ChangeControl.Number.Value = newrec + 1 Exit_Command29_Click: trying to have a field in a form to update the number by 1 in access in the button next...

hi, i am trying to create a rule where is say staff fill in a new members form and forget to put in the name and leave it blank a meassage will appear stating that it needs to be filled in to progress. is there a validation rule for this in Access??

hey guys, im trying to create an IF statement. I want the if statement to say if a certain field is either jan,feb,march,april then make another field say Quarter 1. If the certain field says may june july aug then quater 2. Im trying to create this in access but am not having any luck. Any...