trying to create a scheduling doctor appointments in Access 2013

Anonymous
2018-10-17T22:25:24+00:00

My boss asked me to do a new Access database from scratch. I’ve never done an Access database on my own before, and would appreciate any advice you guys have. This is to help employees schedule appointments for 46 medical doctors in 14 different medical offices.

As for my relationships, I hope I’ve set up everything correctly:

As you can see, I’ve set up two junction tables, but am not quite sure how to set up a search query with junction tables. I’ve looked in my two Access 2013 books, and I’ve also looked online but am not having much luck. For example, with the table Junction_Provider_Insurance, I’m not sure how to search the Junction table to pull up the doctor and if the doctor is contracted, not contracted, needs authorization or pending for the insurance. So if a doctor’s name and an insurance name such as Aetna is searched, I want the result to show that the doctor is or is not contracted with Aetna in ReportResults.

As for the search, I originally set up a wildcard search for all the search boxes. My original intention was that the user could type in anything they wanted in one or two or three of the boxes (such as doctor’s name, visit type and insurance) and do a search where the results come up. However this is not working at all and time is of the essence as I’ve already missed my deadline to turn in this a week ago.  

Due to missing the deadline, I decided to change the wildcard text search to a combo box for the Doctor’s Name, Medical Office Name, Visit Type, Specialty and Insurance in the hopes the search will finally work. I’m thinking the best way to handle this is to remove the medical office, and then just have the doctor’s name, then when that comes up, to cascade into a new combo box for the visit type (new patient, follow up, pre-op, post-op, etc.) Or is there a better way to do this? I still need the results to show in the report too.

Thank you so much for your time and help. I really appreciate it very much.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

136 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-11-21T18:06:13+00:00

    I have a report that works perfectly when I open it directly from Navigation. I called it rptStacked as it has rptSubSpeciality inside rptSpecialty, then rptSpecialty is inside rptStacked.

    However when I try to search, it keeps asking for the SubSpecialityID and the SpecialtyID. I have tried putting all IDs in rptStacked under Group and all that, but it just won't accept the IDs anywhere. The IDs are already in the sub reports. The subreports work fine when individually opened from Navigation. I have all Master and Child fields and I'm very frustrated now. I've spent a week just trying to get this fixed. Please help, thanks.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-11-12T17:23:48+00:00

    I *think* you going in the right direction.  Just remember as you get pieces working, test before moving on to the next piece.  Adding all the pieces at once makes it confusing when something goes wrong.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-11-12T16:55:45+00:00

    Thank you Gina. I had to take the weekend off from this project as it's only making me frustrated and overwhelmed.

    First, I noticed that none of the queries or the main report are pulling up the provider if the provider only has a Specialty and no Sub-Specialty. So I am trying to fix that.

    I have yet to get any of the mini-reports (or child reports or sub reports) working at all.

    I guess I have to:

    • fix the main query to pull up all providers even the providers without any Subspecialties
    • get a Sub-Specialty Query working
    • get a Sub-Specialty Report working which will be a sub-report inside Specialty Report
    • get a Specialty Query working
    • get a Specialty Report working to go to Specialty Report which will be a sub-report inside Provider Report
    • get a Provider Query working
    • get a Provider Report working to go to Provider Report which will be a sub-report inside Office Report
    • get an Office Query working
    • get an Office Report working to go to Office Report

    then lastly, tie in the Visit and Insurance at the end. Or have I confused myself?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-11-10T00:21:26+00:00

    Don't give up, it looks like you forgot to link the two reports.  You can't just drop the subreports on you need to link them LinkMasterFeild;LinkChildField.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-11-09T23:46:09+00:00

    I'm just close to tears. I've made things worse instead of better after eight hours of trying to improve things. Nothing I do seems to work at all.

    Was this answer helpful?

    0 comments