Search results

Hi Thanks for that, i'm almost done. I have managed to get the sibling count outside of the subreport, but get an error when it = 0 also i cant generate the grand total for the sibling count in the report footer. I have attached where i'm up to so far rptPatient2 is the report that i'm...

Thanks Bob, I think subreport for the siblings is way to go, i was just trying to be lazy by using groupings. As for carers, a patient can only have 1 or 2 carers to the party, (not 0, they must be accompanied, and not more than 2) which is why I put them in the table as I did. I wouldn't...

Hi I have a couple of minor problems in a report. I have 2 fields for carers (PrimaryCarer and SecondCarer) I want an unbound field to say how many carers there are per patient (there is only ever one or two) I have used this expression =IIf(Len([SecondCarerName]=0),1,2) I have also...

Thats great Paul, works fine now. Thanks to you both

I have a search form and the user has to select a case ref before clicking an action. if they don't select a case it throws up an error so i'm trying to put in some error handling. this is what i have, but it deosnt seem to be doing the job, please can someone let me know where im going...

Thats working much smoother now Thank you very much, There's the difference between 'knowing what to' do and 'knowing what you're doing'

Hi I have a form that I need to update whenever a value is changed but i seem to be getting some errors. the 2 problems are the dsum at the bottom do not seem to work consistently. Also if the user clicks the pcm box after putting an amount in but prior to selecteing a frequency, an error...

wow, lots of responces, you are all on form today, thanks! data type is an autonumber field, I think this may be the problem, but I need to filter to the number im passing through. me.ID=me.openargs gives the error can't assign a value to this object too :( i thought strOpenArgs is a...

Hi I get 'you cant assign a vlaue to this object' if i try that.

Hi I've never used openargs before, but think i need to finally get to grips with it. I have this code now on my search page dblclick: Dim stDocName As String 'Dim stLinkCriteria As String Dim strOpenArgs As String stDocName = "frmAllContactsSummary" strOpenArgs = "[ID]"...

Hi I have an 'add new' button on a form that opens a defferent form and passes through the ID value using the openargs, here is the code: Dim stDocName As String Dim strOpenArgs As String stDocName = "frmRIAProcessAdd" strOpenArgs = Me.ID DoCmd.OpenForm stDocName, , , ...

Hi thanks I agree, however they were originally seperate databases that have been brought together into one, (a couple still exist as seperate databases and are still used, I just link to the tables as they are maintained by someone else) hense the proceedure for compiling them... I still...

I agree with above, Male/Female shoudl be a field in your main table and you should use queries to filter them, however to work with what you have you can set up a form with all 3 buttons, use the on load event to change the visible property of the 2 hidden buttons to False. Then in your onclick...

Hi I was not around yesterday but just seen your response. Thank you for your help, looking at the tables has helped identify the problem, but unfortuantely I dont know the answer... The table that the search works from is created as the form opens, compiling data from 4 other tables...

Hi thanks for your quick response. The data entry property is set to No on the form. I have checked the tbl behind and there are values in every ContactID record. they start at about 509000 (due to it being a table created every time the DB is run appending 3 other tables). any other...

This is something i have done many times before, but today for some reason it wont work. I have a search form with a list box which shows the results. i have this code on the double click event: Dim stDocName As String Dim stLinkCriteria As String stDocName =...

boblarson you are a legend, i would have never been able to do that without your help!!! Thanks :D

Ok, here is a mock up of what im trying to do. I've used the same form names and field names where possible. I want to be able to double click on StandardLetterID on frmRIASelectApplication and have it open frmRIAProcess filtered with just the StandardLetterID record. I have put in the code I...

I'm afraid i'm not entirely understanding that link Ive put a control on the main form and it gives me this syntax when i add in the controlsource [sfrmRIASelectApplication].Form![StandardLetterID] this is the subform I am double clicking on (so i am subsituting in me.) the syntax for...

this code works fine to give me the correct record within the parent form, however multiple records show up in the subform (as expected with this code) Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmRIAProcess" stLinkCriteria = "[PersonID]=" &...