Search results

Thanks, I got, it, and I got the name right, but I just found out another thing, I am not sure if that makes a difference, the form is based on a query that has 2 nested queries, All the other forms do not work out of a query except this one. Could that make any difference ? Thanks. Maurice.

For some weird reason I keep getting the same Runtime Error 2465, Application-defined or object-defined error. I know 100% your code is excellent and both forms work as they should be, but I am guessing something is going on while Loading the form. Troubleshoot: - When I try the Immediate I got...

I got an error: this is what I have: Forms!MenuF.frmAuthFullView.Form!ShortcutMenu = TempVars("SCM").value

I am using: Forms("FormName").ShortcutMenu = TempVars("SCM").value FormName is the Name of the SUB-FORM, not of the MAIN FORM. It works with the main Form, but not for the Sub-Form, the only way I've found to disable the Sub-Form sub menu is to go directly to the property tab and disable...

DARN Colin, you save my "rear" again..

This is an OLD one but here is the correct CLICK THIS LINK

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.