Search results

Dear MVP's & Experts, Recently I am trying to build a search function on a form where there is a subform which is relate to query. Through few Combo box selection, I need to search item into subform which has been placed on main form. Also there is a Reset button which will reset the search...

Hello MVP's & Expert's, Anyone please help me out to give hints how the database has been protected to disable everything even the Access Option from top left of the screen (I am using Access 2007). below sample file (link below) http://www.access-programmers.co.uk/...t=85309&page=2 As I...

Hi Hamish, Could you please help me out here..... Appericate your prompt response. Thanks Santosh

Thanks for the hint... I moved the code from "Close Form" event to "Form_Timer" event and its working exactly what I was willing.... Thank you soooooooo.... much dear. You guys are great in Access :)

Hi Hamish, Thank you so much for your help. Now I am able to import all the objects from HRForm.mdb file... But my .mdb file doesn't ask for any password and still I am able to view the Access Option from top left of the screen (I am using Access 2007). I want to build my database as same as...

Hi All, I have just checked out following link where there is a sample .mdb file which track idle time and logout user from the database after a certain time. Could anyone help me out to view the codes and modules in sample file attached (HRForm.zip) in below link as I am unable to view...

I un-ticked the ones that read "MISSING:" references and now there is no any debug error however following code open both the forms (MainMenu1 & MainMenu2) and on front its shows MainMenu2 when today date is greater than "2 January 2012". but still MainMenu1 is shows opened. Its working fine...

Still something going wrong... I am getting the same error... however once I click the ok button its open the References window to check or uncheck available references. Please advise...

On Date (just after If) in following line: If Date < CDate("2 January 2012") Then

Thanks for your prompt response and helping out however I'm still stuck here and getting compile error: "Can't find project or library" Here is my code (in my Startup from): Private Sub Form_Close() If Date < CDate("2 January 2012") Then DoCmd.OpenForm "MainMenu2" Else DoCmd.OpenForm...

Hi All, I have a database (sample attached) with three forms: 1) Startup (Flash screen type, will close in 5 secs) 2) MainMenu2 (will be open after flash screen close) 3) MainMenu1 Want help in opening these forms (MainMenu2 or MainMenu1) after Startup form close only when some criteria...

Thanks a lot. However I try to figure out through Crosstab Query but failed. Could you please advise me what would be the easiest way to create a report look like what I had shown in the screenshot. I hope there would be some other way around to solve this problem. Please Advise !!!

Hi Experts, Could you please help me out in solving above problem. I am unable to create Report as shown in screenshot attached. It would be great helpful !!! Many Thanks, Santosh

Dear All, I am developing an access based report, but I am stuck with some issue. a) In my query “qryreportsTA” I want to have a month column as per received date. Its easy to do in excel (sample sheet attached) however not able to do in query. b) I am not able to create a report in...

Thank you soooooooo....much John :) You are really a STAR and you deserved it...really !!! This is what I was looking for... exactly.... however the table still need to be normalize as the source data was from excel sheet...and dumped to access table as it is. Your advise would be very...

Can anyone help me out here.... I am unable to solve above problem....

Can anybody help me out here..... I am in urgent need of solution on above query.... Thanks

Thank you so much John for your prompt help :) Well, I used the same concept as you suggested however the second search option demands on selection done in frame. I am unable to code for second search field :( What I want that there should be another search field same as first one ("Search...

Hi All, I have a access database which mainly deal in searching items from a table through form. I have a search field on a form which search the record through query however there is another search field (marked in Yellow colored) doesn't search the required item from the list search through...