Search results

  1. J

    someone good at relationships

    My data base is for farm auditing, so going round and answering lots of questions about a farm. I want it so that i enter in the current customers name once at the start of the audit, then you can just click in and out of forms to complete the audit for that farm using the buttons I have made...
  2. J

    Check Box format

    Hi, Wondering does anyone know how to change the format of a chack box so that you can have different types of checkboxes to choose, image wise etc like the colour of ticks and size of the check boxes?
  3. J

    Hyperlink hand question

    Hi, Wondering if anyone knows if it is possible to have a word appear when the cursor hovers over a button. I know you are able to get a hyperlink hand to appear but I am wondering is it possible to get this and a word show up? Any help would be much appreciated :)
  4. J

    Total Row Properties

    Hey, does anyone know how to edit the properties of Total Rows or if it is possible??? Its not accounting for the format my data has been entered in. Any help would be much appreciated Joce
  5. J

    Totals bar problems

    Hi, I am using the totals button to calculate the avergaes of my many different columns. But my problem is, that each value that has been entered are like follows: 0.12%, 0.73%,1.23% etc etc but the end value I am getting in the totals field for these colums are coming out in the wrong...
  6. J

    Command Buttons

    Hi, Can anyone tell me if it is possible to change the shape (not size) of command buttons, i.e. is there a list of options anywhere which you can choose or change the shape or appearance of a command button, I dont just mean pputting a picture on it. Any help would be much appreciated. Joce
  7. J

    which dashboard programme to use

    Hi, I am going to be using dashboards in my database but dont know which programme I should purchase or get? Is there any which stand out that are very good, or what are peoples thoughts? Joce
  8. J

    Blank form at data entry

    Hi, Wondering if anyone can help. I have several forms incorporated into a tab control, the problem being is that when I go into it to enter new data into each form, the fields are filled with the data that had been entered the previous day. The only way to change this to a fresh blank form...
  9. J

    Gridlines option greyed out

    Hi, I have produced a report and I want to show the gridlines, but this option isn't available and appears to be greyed out, has anyone any ideas as to why this is or whow I can remedy this problem?? Any help would be appreciated Joce
  10. J

    Expression problems

    Hi I am trying to create an expression in a report which calculates the average of one of the fields I am showing in my report but it doesnt appear to be working. Body condition score average is the name of the field I want to get a total average of all the results over different dates. I also...
  11. J

    Data type mismatch in criteria expression

    I am creating a simple query in a farm audit database. In criteria of the customers field, i have entered "Farmer One" as this is the customers data which I want to retrieve and in the Totals section I have changed the setting to Where instead of group by, but I am still getting "Data type...
  12. J

    Please help!

    Hi, I am trying to incorporate dates into my database but it is driving me mad. I cant get anything to work. I am making a database that will be used for audits and what i want is to go in and enter in the customer name and the date once, at the top of the page then work my way through all...
  13. J

    Date problems

    Hi, I am trying to produce a database which will be used for auditing. I have a main form and several forms within a tab control on the main form. On the main form I am able to select which customer it is I am dealing with, and everything which is then filled in in the forms in the tab...
  14. J

    Best database setup?

    Hi, I am creating a farm audit database, and so that i can go through the whole audit for a single farm I am using tab control forms. (I hope this is the right thing to do) But i want it so that at the top of the page you enter the customers name and date, and then work your way through the...
  15. J

    Having the same date show up on each form

    Hi, I am designing a database for a farm audit. The idea is you will go on a farm and go through all the questions etc on the database, and perhaps go round and do this monthly on a several different farms. Is there a way in which I can enter the date on my first form of the database and...
  16. J

    Expression results not showing when Query is run

    Hi, I have made several calculations using expression builder in one of my forms, and now before i create my report I am trying to use the query wizard or builder to pull out the information which i want from my tables, but when I run the query, the results from the expressions/calculation...
  17. J

    Query and expression problem

    Hi, I have made several calculations using expression builder in one of my forms, and now before i create my report I am trying to use the query wizard or builder to pull out the information which i want from my tables, but when I run the query, the results from the expressions/calculation...
  18. J

    Preventing numbers from rounding up to the nearest whole number

    Hi, I have several fields with combo box answers each answer being 3 digits long e.g. 3.25 and 2.25. I have the field data type to text for all the fields. Will this have any effect when I am trying to carry out calculations. Currently my expressions i am using to total these figures up...
  19. J

    Calculating the average of 10 fields

    Hi, I am trying to calculate the average of 10 fields together but my expression doesnt seem to be working. I am enjw to this so any help would be really appreciated. The expression looks like folows at the minute, CowBCSAverage...
  20. J

    Expression builder problem when calculating a total of fields

    Hi, I have tried to enter a text box which will calculate the total of 7 different fields I have each containing a different quantity of animal field. So in my text box I want the total of all the quantities if feed combined together. The expression at the minute looks as follows ...
Top Bottom