Search results

Is it ok to have 2 copies of the Customer form, i.e. one that could be used for new customers and one that sits in the tabs subform aswell for current customers to look back at their information? Or is this a pointless idea?

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

Could I email it to you

No idea how to sorry

Its 5.11 MB, its too big still when zipped

I tried to upload it but seems to be taking forever. With regards to putting several forms on one page, they wont all fit. I tried creating a relationship between a date field in one table and in another, but that hasnt seemed to work either.

It would be good if I could do the whole farm audit on one page, like one form but I dont know how to do that or if it is even possible as I am only new to all this. I would be happy to upload a copy of it for you to see, but how do i go about doing that??

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

I have tried that but I am not sure that I am doing it correctly. I thought if i just selected the field with the expression in it, in the query wizard it would just work, but it doesnt.

Yes it is.

No they are numbers.

The expression is just placed in the main body of the form. The expression is as follows.... = ([Cow 1 BCS] + [Cow 2 BCS] +[Cow 3 BCS]+[Cow 4 BCS]+[Cow 5 BCS]+[Cow 6 BCS]+[Cow 7 BCS] + [Cow 8 BCS]+[Cow 9 BCS]+[Cow 10 BCS]) / 10

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

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

But when i change my datatype to currency, i end up with currency signs e.g.£ but I dont want these because ti isnt currency I am working with?

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

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

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

I have a query for totaling several fields together. I am pretty certain the expression has been written correctly but it will not generate a total at all for me. Each field is a quantity of feed fed to an animal. I am trying to achieve the total quantity of all the different feeds combined...

Quantity 1 Quantity 2 Quantity 3 Quantity 4 Quantity 5 Quantity 6 Quantity 7 Total quantity fed to group Not sure If i need the "total quantity fed to group" one Thank you for helping btw