Search results

Just what I am doing at this point, and I found another small mistake, some lines in my code are calling the Table instead of the query, thanks for the support, I am learning, your words are a touch of wisdom for my bag of tricks.

Yep, I am trying to use the same form for 2 different purposes instead of creating 2 forms which I believe at this point I will have to do. In my menu I need the form for 2 purposes as I said: 1) be able to edit the records of PatientT regardless if the patient is marked as deceased or not. 2)...

Thanks for the idea, but I am a newbie, I really don't know how to do what you are suggesting.

So instead of using the query for the form, I have to change that to the DB and do the SQL on the open using OpenAClient, this way I control the SQL and the form will open depending on the SQL I build for that instance.. Genius.. Thanks @arnelgp @arnelgp : I am using a routine on Form_Load, now...

Hello ALL: I am using a form that I've been able to use thanks to @arnelgp in 2 different routines, works perfect, but I have an issue now.. I created a Query and I base the form on that Query. SELECT PatientT.PatientID, PatientT.PLastName, PatientT.PFirstName, PatientT.PDOB, PatientT.PPhone...

Yes, thank you Arnel, I got the picture, I have used OpenArgs only using Strings, so I was thinking on going on that direction, this gives me a brand-new perspective and the use of the if then, will make it simple. I am going to adapt this idea and of course give you credit, thank you so much, I...

Good Morning Pat, I have a series of buttons designed as a menu, I got the idea online, was pretty clever, I use hide and show to open the different sections of the menu (5) it works really well and honestly was my very first own code done.. and I tried with a tempvar but I screwed up, I am...

Thanks but, Sorry not sure at all how I would do that, since [I believe], I would need to send something from the menu to SearchF, then using the close button I will have to do something to open either PersonF or CompleteRecordF. But I have no idea how to do such, sorry.

Hello all: I need ADVICE, I have a form that will be opened thru a menu, this form has 2 purposes: - Open SearchF and then once a record is chosen, open a form to edit PersonF. - Open SearchF and with the INFO of that record, fill CompleteRecordF to add data. PersonF only has Info that is...

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