Search results

You make me feel I am not alone in this world. A splash form... Incredible, like Popeye said.. Well blow me down!!! Tried removing the dialog argument, didn't go well, so is back again, hey.. "IF IT'S WORKING DON'T FIX IT" ;):):):):) I even found another glitch with 2 errors 2501 and another...

@isladogs I did not have to go that deep Colin, I see the changes you made literally GENIUS Simple yet work like a charm, At the MENU level at click: Me.Visible = False then when opening the report: DoCmd.OpenReport "AuthByUserR", acViewReport, , , acDialog then at the Report level, On...

I'm going to check your version against mine here, for the love of my mother I cannot figure out, BEFORE your post I did change the code at the Menu level MsgBox "Opening the Access Window" SetAccessWindow (SW_SHOW) MsgBox "Open the Report" DoCmd.OpenReport...

Yes Colin I have all forms and report as well as pop-up, I just followed what @theDBguy found and is working, but for the life of my body I can't figure out how to fix it. IF you happen to have a minute or 2 maybe you can, in the meantime I will just hide some essentials nav pane/ribbon I...

Krap... I can see clearly now... the rain is gone.... I went back to the post where @isladogs talks about it, and you are right Colin's 2 Cents So to be honest the idea of having a clean version to work is simply amazing and I love it, but creates a struggle at print time, since the printing...

Here is one for the books, I would much appreciate your help understanding the WHY.. Disclaimer: - Some fancy code was copied from @arnelgp , @Pat Hartman @isladogs and some other wonderful programmers I appreciate. - ALL data contained in the DB is 100% FAKE is test data. I created a very...

Save me a lot of time, 11 years later..

I promise for the life of my mother and father that I tried that already, I swear.. Read my post #1, just after the code, and you will see I DID that. and it didn't work, now I did it again and is working just like I thought it was going to work. Like Popeye's said.. WELL BLOW ME DOWN!!!!!! I...

Good Morning Larry, those 2 doctors are different ones, DoctorT is the table that holds the info for OUR doctors or PA's, the specialists are the doctors we send our patients for different needs: OUR Doctor Saul [DoctorT], send Patient with ID 12, to a Radiologist, say #15 [Centrelake] but also...

I've done a few, but this one in particular is slightly a bit so developed, and the first version is already on production, this are just the latest changes that my boss just came up with. Literally I'm toast.

Thank you, guys, I have to explain something. What looks so obvious to you, is extremely complex to me. I am a newbie in ACCESS I have programmed before, 30 years ago, in a different language, Cobol, FoxBase.. I Have been learning Access full time for about 8 months to 1 year, before it was...

I guess I have no choice but to re-do all I had, is going to be a lesson learned then, this is going to hurt....

Sorry can't, the main form is bound to the Authorization table, there is where the data is saved, not the patient, patient data saved on the authorizations table is only the ID. I really appreciate your input.

Hello ALL. I have a new request from my boss, and I can't solve it, here is why: The form I am referring is called from a search form [ALL FORMS ARE BOUND TO A TABLE] Search Form is bound to the PatientID since I need to find the patient first in order to create a new Authorization [or many]...

Yes good friend, but I was never shown the correct way, when I learn what I know so far, is what I know how to do. I understand your concept, but I am simply following what I've learn, I wish someone can actually create a learning video series on how to correctly program in Access instead of...

Just a following note: Dear: @mike60smart , @theDBguy , @MajP and of course @Pat Hartman and @Mark_ I understand your concerns and advise, and truly appreciate your input, but nevertheless I have to clear something: I am learning Access, on a let me see what next basis is. I have followed...

I did, and I am reconsidering re-creating the form, but for now time is of the essence, and I have no choice but to continue as is. On the other side, those authorizations follow a protocol internally [Paper Trail] so it is impossible to re-create the same authorization twice, this system is...

Hello ALL: @mike60smart , @theDBguy , @MajP and of course @Pat Hartman My ideas were not so lost, and after a weekend of calming down, and today, with a fresh BRAIN, I had a EUREKA moment, and the answer to my problem, WAY easier that what I thought and it works very well should I say myself...

Hello @mike60smart , @theDBguy , @MajP and of course @Pat Hartman I'll try to answer all of you here. Maybe this will explain a bit better the issue.. This is the Table where the info is SAVED the first time, once I have found the Patient: This is how I do it: I need first to find the patient...

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