Search results

I never knew this, I don't know if it is too late now..

@Pat Hartman and @MajP Thanks I FULLY ACKNOWLEDGE THAT I HAVE TONS OF ERRORS THAT WILL MAKE ALL OF YOU RUN SCARED I FULLY ACKNOWLEDGE THAT I AM SURELY TRYING MY BEST TO THE BEST OF MY ABILITY I AM NOT ASKING TO CORRECT ALL THE ERRORS [PRETTY MUCH THE WHOLE THING IS AN ERROR POSSIBLY] I just...

Hello Gurus; I am almost finalizing my project, is not perfect but is mine thanks to the help of many of you, but I have an issue and I don't know what to do: Here is the part of the form: The user adds all those records in the ADD RECORD Form, that part is working fine. Before those records...

Thank you I was playing around with your Idea, really a great idea, when @MajP sent me his update, I applied it [with my corrections] and is working perfectly, boss is happy, extremely happy now. This is the final code in case it may be of someone else's use. Private Sub RefreshButton_Click()...

Yes, you just went full scale above what I imagine, thank you, your code added what I never saw, and made it more clear, hat off to you sir.

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.