Search results

Superb. That is exactly what i was after. I like the way you've built up a string for looking in the ID field OR used the txtSelect box. Thats very nifty. I'm sure i can incorporate this now into my db. I need to tweak the report output somewhat but the process of being able to print...

great, thanks mate. :)

I've attached the db, hope thats ok. The listbox is working ok if not multiselect. I'm after a multiselect where it prints a report for each item selected, showing only the tick boxes ticked. (Page break between each item selected too). Thanks again for looking at this for me. (The data...

Oh dear, things were going so well, now i've got things all knotted up !!! If i leave the listbox as NO multiselect, everything works, Because there is a filter in the query [forms]![frmSearchHistory]![txtSelect]. My string is built correctly, the report opens, the record source is updated and...

Brilliant !!! I took the Set rd = CurrentDb.OpenRecordset(sSql) out of it as it was giving me an error and BINGO.....my report just as i wanted it. Thanks for your help on this one, my learning curve in access just keeps going up. Now i need to work out how to turn my listbox into a...

it seems i understood pretty well. Thanks very much for that. A little tweaking adding ' around the a,b,c etc and i got the string working. My problem now is .....how on earth do i get the report to use this recordset. I've added do.cmd openreport but the reports record source seems to be using...

DCrake I keep reading over you reply to try to understand it. I may have got there !!! Am i right in saying....... Create and extra column in the union query for the 8 tables/queries. Place text "A", "B", "C" etc in each one. So that if the query was ran at that stage then the first batch of...

Hi I've attached the stripped down front end & the data seperate as it uses link tables. The data will need extracting to c:\ Would you be able to guide me a little more now at all ? Many thanks

DCrake Not sure that i understand how i'd implement that into my db but i understood 95% of what you wrote (code wise at least). Mike I'm not convinced my db is not normalised correctly, it has kind of evolved and developed over a long period of time and i have considered starting fresh a...

I have the correct number of fields and the history report works fine but i want to be able to chose which queries to include in the union query. ie sometimes i might want AI & Calving History, or AI & Bulling, or Footcare and Medicine etc etc. Is there a way, in the union query of only...

I have a problem that i don't know how to explain properly. I have a union query that pulls data from 8 other queries/tables to form a history of any given animal. I want to create a form with tick boxes to select which queries to include in the union query so that i can customise the output...

Great - thank you very much, this one is working fine - now onto the other.

Brilliant - thanks. Maybe you can help me on my next problem that i haven't started on yet !!! In the same db i am going to create a multi select listbox. I want to be able to select multiple record entries and print a report for each one. How would you suggest i do that. Thanks again

Hi all I am having trouble with some code for printing batch reports. I created a form with a load of tick boxes. There names are Report1, Report2 Report3 etc etc..... I have the following code to loop through which text boxes are ticked and to preview the necessary but one line is not doing...

ok m8 thanks anyway.......

Bob, I have been after something like this myself and stumbled across this thread. Great....but one question..... If i wanted the "End Date" to default to today then i put =Date() in the default value property, this works OK.... ..but if i wanted the "Beginning Date" to default to the...

you hit the nail on the head there mate......coincidently i figured that out about an hour ago before realising you posted. i noticed the query was unupdateable because of the animal register table and linked field in the qryAIRegister. but why would that make it unupdateable ? i am also...

I have a very strange problem that has appeared on 3 databases. Error 3027. Cannot update. Database or object is read-only. I have checked & changed nothing to do with folder persmissions etc. The 3 databases are independant but similar. All 3 use linked data tables. The error happens in...

hmmm good idea - that may help - thanks for that.

Is it possible for a cell to have a formula to calculate a default value based on other cells but for a user to be able to change this value WITHOUT losing the cells formula. ?