Search results

I have a report that prints address labels for contacts in a database. It works ok for printing individually but i want to 'batch print' some labels (xmas envelopes!). I have a form with a multi select listbox setup with the filtered contacts i want to print. I also have a button for 'Print...

Strange - i deleted the subform and added it again and that didn't get rid of it. Never thought to delete just the TAG field ! Even more strangely the 1148 just dissappered at some point and i can't remember what i did - it just went !!! Oh well - thanks to you all for looking. At least i...

The only thing it can be is an ID from 1 particular cow but the record entry is not in either table. !!!:eek: :D

I have just created a form with a subform. The subform is linked to the main form via a field 'TAG'. The main form has a listbox of cows available for being AI'd or Bulled. When a cow is selected in the listbox it brings up its own history in the subform. BUT..... The TAG field on the...

What i meant was, when the form & subform are first loaded (or reloaded after) it adds the new record and fills in the boxes without failing. What it is doing is not adding a new record next time the listbox is double clicked. The add new record command is generating the error 2105.!! I...

hmmm i found the problem that was causing it but i don't understand why really ! the name of some of the fields in the subform i must have forgot to change after pasting the tbl, qry and frms to the mineral 'version'. i understand the problem but why would the error happen the line before...

I have a strange problem. I am trying to add a new record to a subform but i keep getting the "Error 2105 - You can't go to the specified record". I have to main forms (frmFeedOrder and frmMineralOrder), each form has a subform & a products listbox. When a product is selected in the list box...

thanks all for your help - i think its working now

OK i have managed to get it working in a fashion. But i still can't get a new record line to appear in the subform. frmFeedOrder is the main form for adding feed purchases. Could anyone tell me why it won't add products to the subform ? Thanks in advance. (New DB attached).

Hi I already have a table storing the farms details. 'tblFarm' - i did consider briefly doing it this way but this database is going to be developed to include a lot more than just the feed purchased. It will also record minerals, field crops etc and eventually will get incorporated into my...

OK guys i'm struggling. I would class myself as somewhere between rookie and amateur at doing access databases but this current task i have set myself is making me wonder whether i'm more the former !!:( I'm trying to setup a database that tracks the purchase of animal feeds for a farm. The...

Thanks Khawar i think you've just got me back on track. A little fine tuning to the query and i believe its sorted. I've changed the SQL now to:- SELECT AnimalRegister.AR_ID, AnimalRegister.TAG, AnimalRegister.Brand, AnimalRegister.Sex, AnimalRegister.Breed, AnimalRegister.DOB...

Hi all - i need some help creating a query and think i've got my knickers in a twist. Basically the attached form has a list box of all animals on a farm, including the Date Of Birth, Date Purchased and Date Moved Off. I only want the list box to be populated if the "Admin Date" falls between...

Brilliant, thats just what i was looking for mate - thanks very much for your help. Another little step on the learning curve ;)

I must be missing something here mate i'm sorry. This is my query in SQL that works but duplicates entries with more than one date:- SELECT qryAIRegister.TAG,qryAIRegister.DueDate FROM AnimalRegister INNER JOIN qryAIRegister ON AnimalRegister.TAG = qryAIRegister.TAG WHERE...

i'll go try it again, sorry bout that, guess i misunderstood - i thought it would filter to just 1 record ! am i right in saying it would list all the TAG's but with just the latest date. and would it matter that the DueDate is a calculated field in the query i am taking it from ? thanks for...

I got a similar question. I have a query that lists multiple records and dates. How do i get it to show just the last date for each record. My query has: TAG (unique ID for each cow) DryingOffDate (a date) An example of the output so far is: UK162574100278 03/02/2009 UK162574100278...

thanks for the reply - it gives me something to search on. thanks again

Hi all Is there a way to run a 'check' on all tables, queries, forms and reports in a database to find out whether they are actually being called somewhere either via a Record Source or as part of a VB Event Procedure etc etc. ? I have a db i've been working on on and off, and you know how...

I am trying to work out how to batch enter some info into a table or query. Sample attached. Basically this sample db is part of a bigger db i'm working on. It tracks the administration of medicine on animals. Using the "Individual Medicine Admin" button on the sample db it is simple to select...