Search results

thanks for showing how to use the IN method. thank you for the help guys. I can finally move from here, ciao ^_^

it worked! thank you..... :) thanks a lot :)

I tried that but with an AND.... lemme try the OR now.. thank you. I think I could use the IN but I don't know how...

hello, I would like to know how to filter (from form property sheet) on load, I have this on Data/Filter/Property Sheet; DocName = 'NEWops' ... but I want to display not just the 'NEWops'. I wanted to display NEWops, PREops, DCVops as well. they all belong to the DocName field... please help...

hello again... please see the code below, purpose is to get a password for a certain tab. this example have 2 tabs, tab 1 requires password, tab 2 doesn't. I would like to know how to stop that tab from asking for a password once the authorized user entered it once. at least until he close the...

for the 2nd department, I used your suggested code uncle gizmo, thank you very much. thank you for your help guys. I'm learning a lot :)

i'll do that on the next half of my db. this one is only for one department, the other department have more than 5 divisions so the select case will be very helpful. thank you for the help and tip. :)

SIR THANK YOU FOR THE REFERENCE!!!! it's now working like a charm, plus my code for log can be triggered with the on load of the forms. thank you again for the help sir!!!! here's how I wrote the code based on your sample Private Sub tab_ops_Click() If Me.tab_ops = 0 Then 'first tab clicked...

can you please take a look at this code.... :( the first tab, is working. it won't load unless I click on it. but the rest remains blank even if I click on it angrily :( also because of this, the log for users who is clicking on the first tab is also working. now all I have to do is make the...

the "unloading" plan didn't work :( could you please help me in how exactly should I remove the source object while it is not yet clicked or the tab is not active? thanks a bunch thank you too uncle gizmo, I'm also reading that thread.

thank you,. I will try and be right back... I hope this works...

thank you for your response sir. but unfortunately, as I have mentioned earlier, when I put it "onload" event of the form (which is a subform within a tab control embedded to a main form), it will log the opening of the main form even if I am not selecting that particular tab. I am currently...

I am using a code I found on the net to log use of forms. (who opens it and when), the problem I am facing is, the code works if I put it in the "onload" event of a form. BUT, the forms are subforms within different tabs of the main form, so when I load the main form, the subforms in the tabs...

thanks! I used that earlier, but I see now that I missed a freakin quote. thank you buddy!

helloy guys, please help... i know this is simple but i tried a few things but nothing works. i want to load a form with two or up to 4 filters. with one im okay but adding another filter i don't know how to do that. here's the code Me.Filter = "Department = 'East'" Me.FilterOn = True that's...

I forgot it's 97,. anyway, if I'm not mistaken you can see it from "tools", "general", I think,.. then there are checkboxes there like "macro protection" or "macro virus protection" ...

it's okay, I'm novice too ;) , when you open MS ACCESS, not your database,.. click on "FILE" upper left corner, then "OPTIONS", a new window should pop up, then from the list on the left of that pop up window, you'll see 'TRUST CENTER", then click that, and then there should be a button there...

well, as mentioned by JHB, if you can open ms access only... not your database. and then go to the trust center settings. disable it from there. I hope that helps. I understand the frustration, been there like few hours ago LOL!

I have a similar problem earlier... tried this and that, and then I noticed while painstakingly checking each form that the problem was with the macro. I disabled all macros, then closed the database, and when I opened it no more crashing. except macros are disabled. then I re-enabled it again...

works like a charm, just exactly what I need. thank you :) then i can use the form view to display the form in individual details and with photo of the employee... this is great cheers!