Search results

essentially the users want a search function where they can search patient by surname, and I really can't figure how to get it to work. thanks

I've a form that uses a combo box to find a record by the primary key (ID number), and then to load all associated records (clinic appointments). I'd like however to use a combo box to search for a record in the table not by the primary key, but by the patient surname, and then by using the...

Is that for entering new records or modifying current records or both?

That's me rumbled as a rubbish coder then ;) Thanks for the tips, I'll try these out and see if it improves the situation. One thing to ask though, when closing acForm, the form in question doesn't appear in the list... is there a reason why this is preferred to a simple DoCmd.Close ? Thanks

Getting the above error very intermittently from users. Occuring when users click 'Save and Close', there is also no save close button. I'm unable to replicate the error on my end. :confused: Private Sub cmdClose_Click() Dim Response As Integer Response = MsgBox(Prompt:="Do you want to save...

works a treat, thanks very much

Yes, each person on the database has a unique ID which is how all the tables are linked.

Thanks, I can see how that would be helpful showing the records for a primary key, I've been able to manage that with the subform however, and it's the linking of those secondary records to the person record on the main form's combo so I can show the comments in a text box. cheers.

It is what I have. The issue is that I cannot link the comments box to the specific record highlighted in the subform. Ideally I'll put in next and previous record buttons, but that would be secondary to this issue.

I've a record-viewing form (i.e. no data entry) where I want to be able to list all the specific records for a person. The issue i've come across is that the comments box for the records are too long to be viewed in a traditional subform, so I thought about linking the specific record on the...

That was actually what I meant, how am I able to do that? Thanks a million

I've a list of customer ID numbers (about 1,500) in an excel spreadsheet of customers who need to have their loyalty status changed from false to true. The loyalty status is a TRUE/FALSE check box. Is there any way to run a query pulling a list of customer IDs where I can quickly change all of...

Thank you so much. This forum is endlessly helpful and educational, and i really appreciate it!!

Hello, I'm getting the error when clicking on the link "add new" to a seperate form that is used to enter data in the table that is shown via a subform on the page. I'm not sure what has changed exactly, but prior to christmas (when i last worked on this) everything worked fine. >_< Thanks for...

So the SQL would then look like this; SELECT tblAppointments.PatientID, Max(tblAppointments.FollowUpDate) AS MaxOfAppointmentDate FROM tblAppointments GROUP BY tblAppointments.PatientID ? Doesn't quite seem right to me

Is that instead of Max(tblAppointments.AppointmentDate)? Would I then need to delete tbl.Appointments.FollowUpDate from the SELECT statement?

Thanks for the quick reply. Not really sure how to join the query back to the table though?

I've two tables, tblPatients where the primary key is PatientID, and tblAppointments where the primary key is AppointmentID; I've multiple appointment entries for each patient, as well as a follow up date for when the next appointment is to be booked. When trying to create a 'max of' query for...

thanks dairees, works perfectly. Thanks also Ranman256 for your response :)

I realise this is an oft covered topic, but I've had trouble implementing the answers of found on other threads. I'm wanting to check if the entered "CHI", the primary key (text, not number) is already contained in the table immediately after update (or before?) of that field, i.e. just after...