Search results

Yes, but how do I ignore the instruction when is OFF?

I have the following button that refreshes my form IF the EU changes the dates, so far it was ok, until my boss decided to change a bit: Now She wants to ADD a field we call [STAT] is a CHECK BOX, I need to add this to the equation: In my vision when the user use the check mark I want to see...

Thank you, sir, I am working in a small option, if it works, I will post it.

Yes!!! it worked, I did a change to my code where after the compact is done I ask the superadmin if he wants to open the MenuF in Full view or Restricted View, Finally I was able to perform the Backup and Compact and Repair, successfully. Thank you, Colin.

Thanks, this is OLD, but I found my solution, I just tweak it a bit. I wanted to avoid a control "SubForm" to open if the superadmin is login [me], so that I can perform a Compact and Repair thru VBA, I ask the question here in the forums, but I had no luck...

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