Search results

Took me a little while to clean up the db enough so I can submit only the essentials, there's 2 zip files, FE and BE, I had them on a folder called: c:\apps DISCLAIMER: For the ones that will open the db, I AM A NEWBIE, do not expect a top notch, top class code, I did what I have learned so...

I saw the video finally, that is just outstanding, but means, is not easy as I thought it will be, you were able to fix the nulls since you know HowTo and WhereTo, but a layman as me will be lost as cannibal in the middle of Manhattan :ROFLMAO: , but nevertheless I can always come here and ask.

Thanks @Pat Hartman and everyone else, I see your point, just a little reminder, most of us that ask to undo the split is because we are newbies, the knowledge you all have is of utmost importance, to me at least, is a moment to learn, a way to understand that undoing the split is unnecessary...

the db is still not production, and I am planning to use a NAS drive instead of the server, even later IF I LEARN ENOUGH, I will move the BE to SQL SERVER, I found somewhere that there is a piece of software that moves all the tables to SQL with min effort, and apparently works pretty good, so...

Darn I'm Marvelous 🤣 🤣 🤣 🤣 🤣 🤣 🤣 🤣 🤣 will that work?

I was waiting to see yours.... :ROFLMAO: :ROFLMAO: :ROFLMAO: :ROFLMAO:

Holy CRACK Colin, it's been there all the time, and I have never seen it, darn, no wonder you are an MVP / VIP or should I say MID {Most Important Developer} that is the easiest.:)

HA.. you're a genius Pat, I just did it and it worked, now I have 2 copies, my screwup test all copy, and my splatted, when I update a form a query, etc, I do it in my screwup copy, once it works, I go to the split, import the updated modules, and voila, problem solved. Thanks, for the lesson.

Yes, all of our computers are marked WS001, 002, etc, so no luck there, my DB has a users Table, and the SuperAdmin [Me] is hard coded, so that no one can eliminate it, but there are 2 passwords, SA with password for SA, and SA with a password, that gives SA minus a few tasks. I use tempvars.

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