Search results

I've not input any code, i've been using the expression builder, which doesn't seem enough. Not even sure under what heading the code needs to be actual put under

I'm afraid I don't really understand how to implement what you guys are talking about. Running query criteria through a form is working grand, but I'm having trouble with reports now. creating a report and setting query control source to the report, its only asking me for the first parameter...

I've got a 'close', 'new report', and 'print' button seemingly working!:confused:

this seems more logical for what I'm doing, I'll give it a try, thanks. I apologise for not making myself particularly clear. The patient table and the appointment tables are entirely seperate, linked only by the patient ID. On top of that I'm running a query of active patients, that is...

Got it working. Thanks a million. Next, I want to be able to save that calculated date into the 'patients' table, as a 'follow up date'. Having trouble working out how to bind an unbound auto-populating text box to a different table. Currently not an issue, but when the same patient comes in...

I'm really not sure where I'm going wrong, but it simply isn't working.:banghead:

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

Thanks for the quick reply, but I'm not really sure how to make that work. I'm assuming I'd name the boxes as 'period' and 'qualifier' as unbound text boxes - would combo boxes work? - and then in the unbound text box where I want the date to be shown, type in that dateadd function? Would i need...

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