Search results

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

is not on a query is bound to AuthorizationsT

I never knew this, I don't know if it is too late now..

@Pat Hartman and @MajP Thanks I FULLY ACKNOWLEDGE THAT I HAVE TONS OF ERRORS THAT WILL MAKE ALL OF YOU RUN SCARED I FULLY ACKNOWLEDGE THAT I AM SURELY TRYING MY BEST TO THE BEST OF MY ABILITY I AM NOT ASKING TO CORRECT ALL THE ERRORS [PRETTY MUCH THE WHOLE THING IS AN ERROR POSSIBLY] I just...

Hello Gurus; I am almost finalizing my project, is not perfect but is mine thanks to the help of many of you, but I have an issue and I don't know what to do: Here is the part of the form: The user adds all those records in the ADD RECORD Form, that part is working fine. Before those records...

Thank you I was playing around with your Idea, really a great idea, when @MajP sent me his update, I applied it [with my corrections] and is working perfectly, boss is happy, extremely happy now. This is the final code in case it may be of someone else's use. Private Sub RefreshButton_Click()...

Yes, you just went full scale above what I imagine, thank you, your code added what I never saw, and made it more clear, hat off to you sir.

Yes, but how do I ignore the instruction when is OFF?

I have the following button that refreshes my form IF the EU changes the dates, so far it was ok, until my boss decided to change a bit: Now She wants to ADD a field we call [STAT] is a CHECK BOX, I need to add this to the equation: In my vision when the user use the check mark I want to see...

Thank you, sir, I am working in a small option, if it works, I will post it.

Yes!!! it worked, I did a change to my code where after the compact is done I ask the superadmin if he wants to open the MenuF in Full view or Restricted View, Finally I was able to perform the Backup and Compact and Repair, successfully. Thank you, Colin.

Thanks, this is OLD, but I found my solution, I just tweak it a bit. I wanted to avoid a control "SubForm" to open if the superadmin is login [me], so that I can perform a Compact and Repair thru VBA, I ask the question here in the forums, but I had no luck...