Search results

I'm in the process on developing this database and am stuck at a certain point despite trying for a whole day. I'm very new to access and this is my first database. I have this form called frmPatient which is used to enter baseline data about patients and a form called frmVisit which is used to...

Thank you so much. Exactly what i wanted.

Hi, I have 2 textboxes on my form (Namefilter and BirthYear filter) and have set them up to filter the data entered in my tables as i type (real time search as I type). I need the 2nd filter (birthyear) to filter the results obtained by the first filter, but at the moment when I type in the...

Found the problem. The data entry property of the 2nd form was set to yes and setting this to no solved the issue. Thanks for the replies.

The visit ID which is the bound column in the combo box is unique for each patient+visit date combination. I need to be able to open the frmVisit form to the relevant patient+visit date combination (which is already saved in tblVisit) when I click on the relevant record on the combobox

Allow edits are set to yes in the form

Sorry to bring this up again. I thought it was working earlier but now it's not. I have a combobox (search visit dates) in frmPatient form which contains all visit dates for a particular patient. I want to be able to open up the frmVisit form for the relevant patient for the relevant visit date...

Thanks. Just what I wanted.

I've been trying to prevent dupicate entries into a linked form by using the above advice but without success. My form (frmVisit) is autopopulated by clicking a command button (New visit) on the main form (frmPatient). I want to show a message if a duplicate value for the combination of patient...

Thanks. This is just what i wanted. Much appreciated. Could the same be applied to realtime display of the result in a calculated field ? e.g. txtA = txtB*10 Is it possible to show the result in textbox A right after (or during) you type in the value in textbox B rather than have to click...

I ve tried that but that gives even more delay in the update - i have to first click outside the text box and then click back inside for the change to occur in this case. Thank you. Sorry but i'm very new to this and cannot understand how to go about setting up the SQL. If it is not too much...

Hi, I ve attached a small sample database below. In the frmCalcium form I need the Range box to be updated real time as i type in the values in the calcium field. I ve set up the vba code to the after update event of the calcium text box, but then i have to click on another field for the range...

Thank you for your comments. 1 & 2 - problem solved. Thanks 3. I am not planning to enter new records directly into investigation results subform. It is meant to be used only for the record indicated in the parent form 4. I actually do not want to analyse this data. I just need to keep record...

Thanks for your suggestion. I am creating my first database and your suggestions are extremely helpful. I changed the code i had set to execute on clicking tabcontrol as a Sub Form BeforeInsert event. But the primary problem of inability to enter data into the same visitID on the subform still...

I have attached my database below. The frmPatients for has a toggle which brings up frmVisit. This form had a subform under investigation results tab page. I have set the frmVisit to automatically create a new visitID when i type in details. When I enter data into the subform I need this to go...

You can add a navigation control within a tab page. Would this work for you?

Yes this solved the issue. Much appreciated.

Above solutions did not work for me. I know this does not feel like sound practice but I have met some people who know their age but cannot remember their birth year. I want to use this in this situation where I enter age into non-bound text box and it auto-populates the birth year for me which...

Hi, I have a form which contains the fields "first visit date" (contains today's date in date/time format), age and birth year (as number). I want to caculate the year of birth by filling the other 2 fields. I wrote the following code for this but it doesn't work. Private Sub...

Yes these are perfect now. Thank you so much.