Search results

Colin, you're a genius in my book, but I do not have any idea ow can I accomplish that, nevertheless, I'll google and try. Thank you sir.

Thanks @arnelgp , but this is not even production DB, this is my test DB, I split the DB, but that's it, and I am the only one with access to the folder that contains the DB. Once I open the menu it access a form created by a Qry, when I go to menu that allows me to compact the DB, I close the...

sure, let me do clean version without all the tables and bells and whistles as soon as I get to the office. thanks.

Hello Gurus.. I have a form that when opened Opens a Sub Form containing some useful data for the user, I really as ADMIN do not need that data, and interferes when I try to perform maintenance on the DB, for some reason even when I close the Form something is left Open and the laccdb file is...

Thank you but you cannot use the name of the control for the master field, has to be the PK ID, but thanks for your help.

Like Always, right on point, thou I have to be honest, I would have never figure that one out. Thanks @arnelgp again..:)

Hello everyone, I've been working on a simple form, but I can't determine why it's out of sync when it first opens. For some reason, the selected record in my sub-form doesn't synchronize with the combo box record, but this only occurs upon opening. If I reselect the record or any other...

Thanks Pat, but most of my forms are always made Continuous, I really don't know what is DS view.. sorry for my impertinence.

Thanks Colin, that is another level, honestly, I had no Idea of the transparent property, thanks.

here it is, I am thinking [yes, it is dangerous], what if I hide the X while the record is in the (NEW) line, then enable it only when the record is saved? I am thinking something like if me.NewRecord then X=visible=false then on the after event make it enabled well I am thinking too much or...

YES... Thanks that solved my issue, instead of a button saying delete I created a button with a RED X, users now know what this means, of course the regular double warning of are you sure... bla, bla, bla.. Thanls @Pat Hartman

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