Search results

  1. A

    Excuse me for this but I am tired =p

    I got it working, your sql was fine I just needed to add in an 's' for the alias on the table and it worked: SELECT s.Softwarenaam, Count(*) as Licenties from Software s Where Licentie = True Group By s.Softwarenaam Thankyou =)
  2. A

    Report issues

    Ah I forgot the join, works now, my fault, normally I would of noticed that- thankyou!
  3. A

    Report issues

    I have used a query to generate the report (I simply want to show a list of all computers which store a certain piece of software; which I have done). Anyways, the report shows these details 3 times for some unknown reason? i.e. if there are 3 records it will show them nine times on the...
  4. A

    Excuse me for this but I am tired =p

    Nope that doesn't seem to work either =(
  5. A

    Excuse me for this but I am tired =p

    Hey everybody, I know I can do this and I know it is something simple but I have been coding websites and such since 7am this morning and when I came to do this my mind went blank. I am wanting to count how many licenses (the format is tick boxes hence the WHERE licentie=true) there are...
  6. A

    VBA code and command buttons

    Hey everybody, I have the working code (well it seems to work, debugged fine etc). However, I have to make a command button on a form with plant details (which I did) and in the event properties I selected 'on click' and went to the code builder and put in the code. However, when I click...
  7. A

    Writing a function that controls the contents of a text box

    Thankyou! it works perfectly! Yeah I could of done this in a table quite easily, but alas I have to use VBA and thankyou so much for taking the time to help me out =)
  8. A

    Writing a function that controls the contents of a text box

    I have created a database with tables, all related etc (which was required) and created a few forms. I am using the form 'Plants' and I have created a new textbox on this form with the label 'advice'. I am supposed to write in the class module of this form a function that will give advice...
  9. A

    Writing a function that controls the contents of a text box

    Thanks, I must however do it all in VBA since it is part of a course I am doing. I am self studying this since the university I am attending this year teaches most of their classes in a language foreign to my own (sucks I know). So I don't have many places to turn for help! I am actually...
  10. A

    Writing a function that controls the contents of a text box

    Yes I do, although I will probably mess up the syntax somewhere along the way :P
  11. A

    Writing a function that controls the contents of a text box

    Hi everyone, Firstly excuse my awful vba knowledge and I am learning (slowly) but I am wanting to create a function ( I think a str). I have created a form which displays species of plants (the database is for a gardening centre). I have created a separate textbox called 'advice'. Now I...
  12. A

    Writing a function and using it in a query.

    Thanks to you both I will attempt the other couple of vba functions I have to make and hopefully they will work :D
  13. A

    Writing a function and using it in a query.

    Thanks, I will try a few of my own and hopefully they will work.
  14. A

    Writing a function and using it in a query.

    My first function :( If I had this function as an example I could proceed with the rest- I can usually figure it all out and understand it better with an example geared toward what I am wanting to do :)
  15. A

    Writing a function and using it in a query.

    Hello everybody, I am taking a module called 'Database and SQL' which was compulsory. I have had no problems up to now, sql was fine etc. However, I have never done visual basic of any description and so I have come unstuck. I have read manuals and this forum but cannot find anything...
Back
Top Bottom