Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 25
Search took 0.04 seconds.
Search: Posts Made By: shatteras
Forum: Forms 09-06-2016, 04:13 AM
Replies: 5
Views: 318
Posted By shatteras
Re: Multiple Criteria Filters from Same Field

thanks for showing how to use the IN method. thank you for the help guys. I can finally move from here, ciao ^_^
Forum: Forms 09-06-2016, 03:56 AM
Replies: 5
Views: 318
Posted By shatteras
Re: Multiple Criteria Filters from Same Field

it worked! thank you..... :) thanks a lot :)
Forum: Forms 09-06-2016, 03:54 AM
Replies: 5
Views: 318
Posted By shatteras
Re: Multiple Criteria Filters from Same Field

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...
Forum: Forms 09-06-2016, 01:11 AM
Replies: 5
Views: 318
Posted By shatteras
Multiple Criteria Filters from Same Field

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...
Forum: Forms 08-01-2016, 08:58 PM
Replies: 1
Views: 214
Posted By shatteras
Enter password once for tabs

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...
Forum: Microsoft Access Tutorials 07-27-2016, 09:20 PM
Replies: 13
Views: 3,648
Posted By shatteras
Re: unload subforms within a tab of a mainform

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 :)
Forum: Microsoft Access Tutorials 07-27-2016, 04:13 AM
Replies: 13
Views: 3,648
Posted By shatteras
Re: unload subforms within a tab of a mainform

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. :)
Forum: Microsoft Access Tutorials 07-27-2016, 03:54 AM
Replies: 13
Views: 3,648
Posted By shatteras
Re: unload subforms within a tab of a mainform

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...
Forum: Microsoft Access Tutorials 07-27-2016, 03:11 AM
Replies: 13
Views: 3,648
Posted By shatteras
Re: unload subforms within a tab of a mainform

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...
Forum: Microsoft Access Tutorials 07-27-2016, 01:35 AM
Replies: 13
Views: 3,648
Posted By shatteras
Re: unload subforms within a tab of a mainform

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...
Forum: Microsoft Access Tutorials 07-27-2016, 12:02 AM
Replies: 13
Views: 3,648
Posted By shatteras
Re: unload subforms within a tab of a mainform

thank you,. I will try and be right back... I hope this works...
Forum: Microsoft Access Tutorials 07-26-2016, 11:42 PM
Replies: 13
Views: 3,648
Posted By shatteras
Re: unload subforms within a tab of a mainform

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...
Forum: Microsoft Access Tutorials 07-26-2016, 10:04 PM
Replies: 13
Views: 3,648
Posted By shatteras
unload subforms within a tab of a mainform

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...
Forum: Forms 06-15-2016, 11:07 PM
Replies: 2
Views: 956
Posted By shatteras
Re: Multiple Filters on form load

thanks! I used that earlier, but I see now that I missed a freakin quote. thank you buddy!
Forum: Forms 06-15-2016, 10:57 PM
Replies: 2
Views: 956
Posted By shatteras
Multiple Filters on form load

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...
Forum: General 05-11-2016, 04:01 AM
Replies: 36
Views: 3,053
Posted By shatteras
Re: MS Access 97 Crashing

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" ...
Forum: General 05-11-2016, 03:31 AM
Replies: 36
Views: 3,053
Posted By shatteras
Re: MS Access 97 Crashing

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...
Forum: General 05-11-2016, 03:19 AM
Replies: 36
Views: 3,053
Posted By shatteras
Re: MS Access 97 Crashing

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,...
Forum: General 05-11-2016, 02:56 AM
Replies: 36
Views: 3,053
Posted By shatteras
Re: MS Access 97 Crashing

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...
Forum: Forms 04-17-2016, 11:53 PM
Replies: 4
Views: 789
Posted By shatteras
Re: button to open subform in datasheet view within a tab

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!
Forum: Forms 04-17-2016, 11:34 PM
Replies: 4
Views: 789
Posted By shatteras
Re: button to open subform in datasheet view within a tab

hi arnelgp, thank you for your response. the previous project i created, i did that. i dragged and dropped the form to the main and yes it is showing the way i wanted it to be.

but for this...
Forum: Forms 04-17-2016, 10:41 PM
Replies: 4
Views: 789
Posted By shatteras
button to open subform in datasheet view within a tab

I have six tabs in my main form, I would like to have a button in each tabs that will open a subform within that tab, and in datasheet view.

the problem is :confused: how to open it in data...
Forum: Forms 04-11-2016, 03:59 AM
Replies: 3
Views: 314
Posted By shatteras
Forum: Forms 04-11-2016, 03:52 AM
Replies: 3
Views: 314
Posted By shatteras
change text box font color when another text box is not empty

can this be done on the conditional formatting? how? thank you...
Forum: Introduce Yourself 04-11-2016, 12:52 AM
Replies: 0
Views: 247
Posted By shatteras
hello

hello hello hello :)
Showing results 1 to 25 of 25

 
Forum Jump



All times are GMT -8. The time now is 02:59 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World