Search results

ok i am not too sure on where to put these pieces of code. In the query i have circuit reference which hasd all the ANUKS456 MXLFX897 etc and the circuit banwith field. Where do i put the left(Circuitreference,4)?? and the count function?? thanks

no i have quite alot of ANUKS so i want to show how many ANUKS there are that have 2mb connection. SOmething along this.

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

right ok - it is needed for when staff analyse it. Can it not be done on a report either?? when i create the query into a report is there no way of displaying the results with a sequential number??

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 am already using the combo box method. However there will be 300+ circuits so i want users to be able to put in the specific circuit code, and allow them to manipulate the data that appears. thanks

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

I dont understand what your trying to say. Could poss give me an example of what the code should look like?

See i dont want to use that. As the new circuit button is located on the welcome page i want users to click on that button and allow them to enter in data straight away without having to press a new record button.

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 DCrake, that sounds like a good idea. i am having trouble putting the data in access as the way i am thinking of structuring the data is by putting the questions in the field name then have a dropdown list with the optional answers. However i cant get the whole question in the field name as...

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 Dcrake, thanks for your help, i finally managed to fix. Thanks for your input.

Gone through the code and cannot see why it is not working?? Any ideas?? Thanks

Any ideas??

The problem that i am still getting with the code is that it still picks up the quarters entered in other projects, so it wont allow me to add in the same quarter for a different project. Thanks

Hi Dcrake sorry it doesnt work still. Here is what i am entering in: Private Sub Command5_Click() If DCount("Quarter", "Test", "[Quarter] = '" & Me.Quarter & "' And [Project_Reference]= " & Me.Project_Reference) > 0 Then MsgBox "Sorry sir....this quarter has already been entered previously...

Hi DCrake, finally works now!! Thank you for your help!!

Hi, tried that however it says i need an end if before the end sub......