Search results

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...

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...

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...

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...

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...

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...

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...

I am aware that this error has been discussed numerous times and is, or at least was not uncommon. Originally, there was an apostrophe in the address link. This has been removed, both backend and front end have been compacted and the links re-established. This has not affected the frequency and...

Hello. Creating a patient database. Patient ID is 10 numbers, with the 9th number being indicative of gender, even numbers are female. I've an unbound text box ("gender") using =Mid([ID],9,1) to pull out the relevant number, then using the following code to autopopulate another unbound text box...

I have a 10 digit ID number (i.e 1412893553) which corresponds to a date of birth (14th Dec 1989) and 4 random numbers. Is there code I can use to work out of the date of birth from this ID number? Cheers

Hello, I realise this is a fairly common issue and have found some help on google, however the reasing/code behind the answer is fairly confusing to me unfortunately. I’m trying to create a query to pull a list of all patients’ most recent appointments. I’ve a base query of ‘active patients’...

In access 2007, much like a form that runs a query, I'd like to be able to run a report in between that, so typing in required criteria in a form, it then runs the query through a report. The reason I'm wanting to do this is that I want to be able to insert other buttons into the report, and...

Hello. I'm relatively new to access 2007, having been studying / working at it for around a month now. I'm creating essentially a log medical database, that is a record of all patients and all their appointments, and not much else. I'm trying to create a macro (or indeed to code) that allows a...