Search results

Hello Gurus: I have an issue [at least it is for me].. This is my Form: The Fields [Name, Last Name, DOB and Phone], are taken from the Search form is coming (I search for the Patient first) then I move the data to the txt Fields to be displayed, this is the code I use on the SEARCH Form...

Well there is something either in windows [most likely] that doesn't let me place the forms where I want no matter what I do, so I did the IT solution, change the order of the monitors, and voila.. Thank you for your help.

Great Idea I'll try with the new changes I've done..

Well something does happen, because I close the main menu in the user's computer on the monitor he wants the app to work and seems like it has a mind of its own, comes back to the main monitor. And I do not have any code to determine what monitor, that is way too advance for me Sir.

Hello Guys.. Is there any way to make sure that when my user opens the DB, this opens in the monitor they want..????? [ they have 2 monitors, a default and secondary] I have been bugged all day with this question, because the app always opens in the default monitor and most want to open it in...

There are a few this one was the easiest one but not enough: QBE Or this one as well same case: QBE2 I Love Richard Rost, he is really good I have learned a lot from him as well, but sometimes I got lost. Richard Rost

Hi Pat, I've seen many videos around, ALL lack something that I consider very important as a teacher: They left the student to wander in many things and let them go to a rabbit hole. I used to teach Networking, A+ and Network + [not anymore], I found out that many books failed to do a simple...

I followed your suggestion and thanks I found the culprit, and is working as it should, I have never done anything with SQL so I need to start learning it, thanks for all the help, I am going to google querydefs and find out, and as well I am going to start or at least try to learn SQL for...

I change it a bit strSQL does not exist so I change it to sql - Well I change the Query to show at LOAD only the Pending ones, but is not what I need, the funny part is that if I check STAT that still works fine sending all the STAT records to the TOP of the list and the rest to the bottom, but...

Not real clear since you have 3 cases Stat is true and both dates filled in Stat is true and one of the dates is not filled in Stat is false and both dates filled in Dates are filled always, and will always be last 90 days from Today all the time. I will try to make sure that ToDate is NOT...

Well thanks Sir, SCM is created before the Main Menu so it will always be there, I did that on purpose. I have set the BE in a NAS drive, I created a Batch file that created Drive H for ALL users [Never Used], then the BE DB is linked specifically to Drive H. The FE is created as well in Drive...

Hello All: I have the following SQL: Private Sub RefreshButton_Click() ' ' Code courtesy of @Arnelgp [AWF] ' Update courtesy of @MajP [AWF] ' Shout out to @theDBguy for his awesome knowledge [AWF] ' Dim sql As String Dim i As Integer Dim Db As DAO.Database If...

A million thanks @MajP for your guidance and support, the "moster" is alive, because it doesn't even make it to monster, is working with all the defects and gross programming, but is alive and well. If you have any other suggestions I am welcoming them with open eyes and ears. Thanks as well...

I think you are right, I am missing A LOT due to the change, but your logic is 100%, I really need to get rid of some of those lines they are OK until DoctorName everything eslse should populate with the Do Command, I am sorry, I am so stressed I cannot even think straight. I am going to change...

This is the flow of the App: - EU enters a new patient using Menu Maintenance ADD Patients - EU then uses Menu Add Authorization - EU Enters an IPA, Health Plan and Specialty, and Specialist -- Specialty Determines who are the Specialists within that Area so is a Cascade Combo, Specialist is...

Check the explain I gave @MajP in Post #16, so you can see where my problem resides, check the ORIGINAL data that is in the DB, or create a new record, when the AuthorizationsEditF populates the data on those fields is NOT the one saved in the original record. AND they DO NOT need to be grayed...

Yes I am sorry. The User has to do this: 1) for a new Authorization, He has to ADD [is a new DB] a new Patient [Menu Maintenance / Add Patients] 2) Once the patient is Added Goto Authorizations / ADD Authorization. 3) Once you Have an Authorization [Which will show in the bottom of the MENU] EU...

AuthorizationsEditF @Pat Hartman has a suggestion I just simply are so stress and nervous I screwed up completely, and I am getting sick, this was supposed to be simple and it end up a nightmare for me. ANY help will be much appreciated, the User Name and Temp Password to get into the App is...

I know you are only trying to help me and I am extremely grateful for that, I am TRULY sorry if you misunderstood me, I am truly expressing my guts at this point, and you guys in this forum are the only ones at this point that can UNSCREW my SCREWED App, on the contrary I am MAD at myself for...

User Admin Pass: 3Lmege77* is temporary password