Search results

Hi Rickster, Thanks for replying. Yes, there are multiple users and they all have there own front ends. When I'm working on the ongoing design of the database I use a copy which is not networked and I get the same problem. John

Sub-forms and "unrecognized database format" message Hi All, This one's driving me crazy, can someone help before I pull all my hair out!!! I have a split database which holds information on clients receiving care from a Health service team. The database has a form "New Client Details" which...

Hi All, I'm sure this must be fairly straight forward but I've been going around in circles trying to solve it in VBA without success. I want the value of a field (Field C) on a form to be automatically entered depending on the value of two other fields (Fields A & B). e.g. If Field A is Null...

RG, Outstanding!!! That's exactly what I needed!! Many, Many thanks for all your great help and advice. Merry Christmas John

Thanks RG, That did make a difference, however it's not quite happening at this end. What's occuring now is that when I double click on the listbox the correct client details are displayed but I always get his first "episode of care" and not the one I select. e.g. it seems to be always stopping...

Hi RG, Sorry to keep pestering you. Oddly when I double click on the subform I get the same record displayed (Where EpisodeofCareID = 1) regardless of my selection. I'm puzzled as to why it works at your end but not at mine??? John

Thanks RG Your right, I do have a way to go but I'm enjoying the journey!! I tried your alterations but I get an error message... "Syntax error (missing operator) in query expression '[ClientID] ='." I'm using access 2003 with windows XP, does that make any difference? John

RG, Thanks for perservering. Most of the data in the Episode of Care table is just experimental. At one point I was having trouble synchronising all the subforms together, at that time a lot of trial and error learning was occurring which, I think, meant data wasn't always being entered into...

Thanks for sticking with me RG. I've tried to sort out a cut down version of the Database, please forgive various things not working, it's all draft stage stuff. Hopefully the attached will shed some light on my problem. John

Apologies RG, This is all new territory for me and I'm kind of thumbling through at the moment. The form "New Client details" is bound to the table "Client Details". The form is made up of a number of Tab pages some of which have subforms on them. The subform "Episode of Care subform1" is on...

I only want one record to be displayed. The trouble is that when I make a selection from the listbox (which contains the result of my search) the wrong record is sometimes displayed. If the search finds clients all of whom have only one episode of care (e.g. every find on the list has a...

Thanks for getting back RG, The Form "New Client Details" is bound to Table "Client Details". The [ClientID] field is the primary key for that table so is unique numeric. The subform "Episode of Care Subform1" is bound to the Table "Episode of Care". The [EpisodeofCareID] field is the primary...

Hi RG, I'm afraid I'm not knowledgeable enough to know the why's and wherefore's. The code was copied from this site (I'm trying to find the reference again without much luck at the moment). I've tried using only one openform command and end up with just a blank form without any record shown...

Hi all, First timer here, so please forgive any daftness on my part. I'm a novice to access setting up my first database. This forun has been brilliant and helped me a great deal. However despite lots of searching I've not been able to sort out this problem. I have a Form (New Client Details)...