Search results

Sorry I was checking my code and I found out 2 things: 1] Thanks to you I figure out I was Dumb BLIND 2] I should have check twice with a clear mind. well yes, you were right, I was wrong, Quote: " The SQL string in your post should be valid, assuming " The name of the table was the wrong one...

Hello All: I got a problem with this statement: Dim strSQL As String strSQL = "UPDATE PatientT " & _ "Set AuthCanceled = True " & _ " Where PatientID = " & Me.PatientID Debug.Print strSQL CurrentDb.Execute strSQL, dbFailOnError MsgBox "Wait.." This is...

Do you want me to be Born Again ? :ROFLMAO: :ROFLMAO: Doc?.. But out of a joke, yes I got your point, Once I start with my next project, I guess I will check my errors first and try not to go over them again, thou sometimes the BLIND does step the HOLE more than once.. Thanks @The_Doc_Man...

Things they don't teach you in the books, at school, in youtube, etc. Your DB is simply one of the tools, great to avoid making some of the mistakes I usually do.

Hello Pat.. Thanks so much for caring.. I have received a file from @arnelgp and it does exactly what I needed, your DB was awesome as well, I had to combine both examples and LEARN, but now has perfectly a failsafe code. And I am sorry for confusing you more, the Idea on #1 was not erase what...

Yes... And I can see what you did, and I can see where my errors were, and thanks as well for leading me in the new use [for me] of the MMB, is simple, yet accomplish all the tasks I needed with failsafe, I actually tested the code with one of the users and just like I wanted she made a mistake...

Hi Pat, thanks for taking the time to correct me, I'm learning. #1, I got it as a Failsafe, we are dealing with Patient names, if the EU does something wrong and then remembers they should have never touch the name, people have a 3 seconds memory and after they are doomed, I have had that...

Hello All: I've been trying to fix a very small routine I had IN A FORM CALLED [ PatientEditF ]. I was instructed to correct my code to do it under the " Form_BeforeUpdate " for my routine checking my data. I did, and I rebuilt the whole form, ground up. Now I am receiving the Runtime error...

Good point Pat, is just that my boss is HARD HEADED.. my only choice is to modify as suggested and never show that part again until the whole project is finished, by that time I hope she doesn't even remember her name..

You now what @The_Doc_Man you and @tvanstiphout have way more experience than me, and thou I am big hard head, I have to get rid of my old FoxBase/Cobol habits and follow the leaders. So I am gonna follow your advise and re-do it tomorrow as soon as get to the office. Thanks. Maurice.

Thanks Tom, yes it is annoying but each date is highly important, the user must be set accountable [per my boss] and since the record [each record] saves a log of who was the last person that changed the record, someone will be accountable anyway. Logs will be deleted monthly by an admin or I...

Hello Gurus: I have an issue with my LOGIC to create a routine where: The Form is a bound form, that contains already some data. So when I close the form I need to check 3 dates If the user decides not to fill the dates is easy to check: IsNull(MyFirstDate) so I know the date(s) where left...

Thanks, please kindly check the code that @arnelgp corrected, it works perfectly, maybe it will be of use to you.

Thanks, please kindly check the code that @arnelgp corrected, it works perfectly, maybe it will be of use to you.

Thanks @arnelgp I see my blunder(s) now, thanks, I hope as well this code helps someone else, is simple, yet it works, I'll disclose all the authors in the code so they can be properly identified. Maurice.

Hello Gurus: Thru trial and error, and with lots of help from many of you here and some other places in the Access world, I was able to proudly create my own message box. While I thought it was working fine, I found out that was actually failing with a strange behavior I was not aware, so I...

Thanks it worked, I just made the adjustments as suggested and added order by referdate at the end so that it is sorted as well, it works pretty well, exactly as I imagined. Thank you @arnelgp I have attached the test Database, just in case anyone wants to see the final result, and might even...

Thanks @LarryE I tried already that and it didn't work, I'm going to try the solution from @arnelgp and will go from there.

Thanks @arnelgp , I am going to try your solution now.

Thanks, I'm going to try, @arnelgp 's solution and will go from there.